Re: MySQL v5 connectivity

Tried with version 2.0.14 resolved my of JDBC connector error.  Now there is 
a comms error now about the server/port is not running (In fact it is 
running!).  Naturally it makes sense to downgrade MYSQL version to v4 to try 
out.   However, seeing there are already some discussions using MYSQL v5 
here.  I just wondered how to make it connects to MYSQL v5.  Do these 
combinations work?
WO5.2.3/ (J Connector v2.0.14) / MYSQL v 4
WO5.2.3/ (what if not J Connector v3.1.13?? PlugIn?) / MYSQL v5

Thanks for sharing.

Cheers

Cheong Hee

----- Original Message ----- 
From: "Pierre Gilquin" <[email protected]>
To: "Cheong Hee (Datasonic)" <[email protected]>; 
<[email protected]>
Sent: Monday, October 09, 2006 2:26 PM
Subject: Re: MySQL v5 connectivity


> On Windows, EOModel use version 2 of JDBC Driver. This is only true for 
> developpement.
> So you have to had this driver (ie mm.mysql-2.0.14-bin.jar) in 
> C:\Apple\Library\Java
> and modify  JavaConfig.plist :
>
> DefaultClasspath = 
> ".....";$NEXT_ROOT/Library/Java/mm.mysql-2.0.14-bin.jar";
>
>
>
> Hope that help
>
>
>
>
>
> Pierre
>
> ----- Original Message ----- 
> From: Cheong Hee (Datasonic)
> To: [email protected]
> Sent: Monday, October 09, 2006 8:03 AM
> Subject: MySQL v5 connectivity
>
>
> I have just tried to convert to MYSQL and do the jdbc connection in 
> EOMOdel.  Have checked Anjo Krank's set up and Kieran Kelleher blog site. 
> Everything looks so simple but yet it just could not found the driver in 
> my EOModel.
>
> I am using Windows XP/WO5.2.3/MySQL 5.  Below is the error message and the 
> classpath is set.  Also tried in classpath set in ProjectBuilder but to no 
> avail.  Is it due to MySQL v5, Windows platform WO or missing in some 
> other setting?
>
> Error from JDBC adaptor: 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 : 
> C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;
> C:\Program 
> Files\Java\j2re1.4.2_03\lib\ext\QTJava.zip;C:\Apple\Library\Java\mysql-connector-java-3.1.13-bin.jar;
> ;/Library/Java;C:/Apple/Local/Library/Java;
> C:/Apple/Library/Java;C:/Apple/Library/JDK/lib/classes.zip;
> C:/Apple/Library/Frameworks/JavaVM.framework/Classes/awt.jar;
> C:/Apple/Library/JDK/lib/swingall.jar
>
> Thanks and appreciate any info.
>
>
>
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>