Re: MySQL v5 connectivity

Appreciate to those have feedbacked.  After some testing on Windows, it 
worked.  Have not tested intensively yet but with a small database.  At 
lease at this point in time, the best combination shall be the following, 
and would like to share with those who may be interested:
WO5.2.4/ Connector-J v3.1.13 / MYSQL v5

Forget about Connector-J v2 as it could not get connected with local host 
database server under Windows.  The latest v3 did overcome the problem.  The 
eomodel also will not support this connector, so we have to forgo EOModel 
for data viewing and table creation.

more info:
http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html


Cheers

Cheong Hee

----- Original Message ----- 
From: "Cheong Hee (Datasonic)" <[email protected]>
To: "Pierre Gilquin" <[email protected]>; <[email protected]>
Sent: Tuesday, October 10, 2006 11:38 AM
Subject: 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
>>
>
>
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>