Re: MySQL v5 connectivity

Sorry to come in late in the discussion, but isn't there an option for 
the MySQL 5 server to run the "old" way for legacy support? (Sorry, i 
don't remember the setting. Has something to do with using the old user 
authentication from memory)

You could set your development MySQL 5 server to use this setting and 
your production to use the normal way.

regards

Peter

Cheong Hee (Datasonic) wrote:
> 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
>>
>
>
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>