Re: MySQL JDBC connection
Re: MySQL JDBC connection
- Subject: Re: MySQL JDBC connection
- From: netBrackets <email@hidden>
- Date: Thu, 23 Mar 2006 22:26:38 -0600
Well, I'm not actually a database newbie, I've actually done a fair
amount of database work, including using MySQL although it's been a
few years. It's using it with (and connecting it to) webobjects that
I'm a newbie at.
And yes, the main reason I'm using MySQL is cost. I'm not even sure
if or how much I would use a database in the end so I was hoping to
just play with MySQL and maybe add a simple table and corresponding
EO to my app just to get my feet wet.
Thanks,
Jeff
http://www.netbrackets.com - nothin' but net!
On Mar 23, 2006, at 10:15 PM, Chuck Hill wrote:
Let me give you a piece of advice. I'm not sure if it is one word
or two. FrontBase. There it is. Yes, you would eventually have
to pay for a license to deploy. But it installs cleanly, comes all
setup for WO, is free for development, and is SQL92 compliant.
OpenBase would be another option with simlar qualities but lacking
sql92 compliance.
MySQL, for a database newbie, is gonna be hell. Use something easy
to install and get running. Get comfortable with WO, learn how it
works. Then, when all of this is less mysterious, try out
PostgreSQL or, if you must, MySQL.
Chuck
On Mar 23, 2006, at 8:01 PM, netBrackets wrote:
Now I remember why I have never used a database in my app. While
EOM looks like very cool stuff, I can never get past the very
first step of getting the EOModeler to connect to my database.
Well, I'm trying again (for about the 4th time in as many years)
and running into the same old problem. I am using MySQL on Mac OS
X Server 10.4. I've started MySQL using the MySQL utitliy, and
I've installed the MySQL JDBC adapter (mysql-connector-java-3.0.17-
ga.bin.jar) in /Library/Java/Extensions and I get the following
error from the EOModeler wizard using a URL of jdbc:mysql://
localhost/WOnetBrackets:
JDBC connection failed for driver :'org.gjt.mm.mysql.Driver'.
Driver not found in Java Runtime! Please verify your CLASSPATH
environment variable. The current CLASSPATH for your application
is : /Developer/Applications/WebObjects/EOModeler.app/Contents/
Resources/Java/eomodeler.zip:/Users/netbrackets/Library/Java:/
Library/Java:/System/Library/Java:/Network/Library/Java:/System/
Library/Frameworks/JavaVM.framework/Classes/classes.jar:/System/
Library/Frameworks/JavaVM.framework/Classes/ui.jar:/Developer/
Applications/WebObjects/EOModeler.app/Contents/Resources/Java/
eomodeler.zip:/System/Library/Frameworks/JavaVM.framework/Versions/
1.5.0/Classes/.compatibility/14compatibility.jar
So, just what is the Driver, and how do I verify my CLASSPATH to I
get it into my Java Runtime? Also, I can't seem to find much
documentation on setting up WO for different databases (I even
searched the archives, which is where I got the info on the MySQL
adaptor and where to install it). Does it exist anywhere such
that a DB newbie could use it?
Thanks,
Jeff
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Coming in 2006 - an introduction to web applications using
WebObjects and Xcode http://www.global-village.net/wointro
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems. http://www.global-village.net/products/
practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden