Re: MySQL JDBC connection
Re: MySQL JDBC connection
- Subject: Re: MySQL JDBC connection
- From: Arturo Pérez <email@hidden>
- Date: Fri, 24 Mar 2006 07:43:58 -0500
<rant>The more I use mysql the more I dislike it. Take this for
example. The driver you mention below org.gjt.mm.mysql.Driver allows
datatimes with a value of zero to be stored (not null, 0). The
official mysql driver com.mysql.jdbc.Driver (or some such) properly
throws an error when it encounters a zero date. Now, why isn't that
logic part of the database, as opposed to a driver? My production
application uses the org driver and stores all kinds of junk (I
inherited the pile of festering code) and my other applications use the
official driver. What a pain!</rant>
In any case, the WebObjects problem is the same as any other Java JDBC
database driver problem. You would get the same problem with any java
application if you don't install the driver properly. I would just
toss it into the endorsed directory and leave it at that since you'll
probably have more than one thing needing the driver anyway.
-arturo
On Mar 23, 2006, at 11: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:
email@hidden
This email sent to email@hidden
_______________________________________________
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