Re: MySQL JDBC connection
Re: MySQL JDBC connection
- Subject: Re: MySQL JDBC connection
- From: Arturo Perez <email@hidden>
- Date: Fri, 24 Mar 2006 10:00:12 -0500
Andrew Satori wrote:
On OSX Server, IIRC, postgresql is installed because it is used by one
of the Apple tools (asset-management? server admin?). I forget which
one. I don't think OSX client has it, though.
Just an interesting aside.
-arturo
When deploying on MacOS I've even gone so far as to dump all my JDBC
drivers (PostgreSQL, MSSQL) in the /Library/Java/Extensions folder and
just let them exist in the classpath. Install once ,test using
SQLGrinder, and go.
I would also like to mention a couple of things WRT MySQL.
Excellent tool, lousy access tools. The issue mention in this rant
is but one of many, and the core reason is that the access libraries
all have 'quirks' some more severe than others, some are just
licensing quirks, but in general none of them are 100%. The upside is
that it's installed by default, my preference of PostgreSQL is not.
The second upsise, PostgreSQL take a bit more work to get working to
WO than MySQL does. The last, finding people that know and use MySQL
is pretty easy (finding people that know it well, less so).
Take all of this with a grain of salt, I come from an Oracle &
Micorosoft SQL Server background, and am the geek behind the
PostreSQL for Mac project on SourceForge.
Andy
On Mar 24, 2006, at 7:43 AM, Arturo Pérez wrote:
<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:
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
_______________________________________________
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