Re: Problem in mysql connection with EOModeler

Hi

As far as I am concerned, it should work under application running mode.  EOModel will not support this connector version.  Write a small test program from MySQL website.

Cheers

Cheong Hee
ps Pls channel the response back to newsgroup.

----- Original Message ----- 
  From: Ashutoshsharma_Sharma 
  To: Cheong Hee (Datasonic) 
  Sent: Friday, January 12, 2007 7:38 PM
  Subject: RE: Problem in mysql connection with EOModeler


  Hi,

   

  As suggested by you I have tried WO5.2.4/ Connector-J v3.1.13 / MYSQL v5 combination but getting the error saying org.gjt.mm.mysql.Driver not found.

  I made changes in the classpath also.

   

  Please tell me what to do?

   

  Regards,

  Ashutosh Sharma

   

   


------------------------------------------------------------------------------

  From: Cheong Hee (Datasonic) [mailto:[email protected]] 
  Sent: Thursday, January 11, 2007 11:27 PM
  To: Ashutoshsharma_Sharma; [email protected]
  Subject: Re: Problem in mysql connection with EOModeler

   

  Maybe my previous email with regards to this matter on 11th October 2006 could be helpful.  

   

  A couple of tests have been performed to find out the best combination (I think) of WO/Connector-J/MySQL.  The following are the extract of the contents that could be helpful if you are using WO/MySQL on Windows.  It looks like you will need to switch to Connector-J V3.1.13, and problem shall be resolved.  

   

  Reason?  Refer to the doc in the url of MySQL attached below.

   

  Cheers

   

  Cheong Hee

   

   

  >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
  > 

    ----- Original Message ----- 

    ----- Original Message ----- 

    From: Ashutoshsharma_Sharma 

    To: [email protected] 

    Sent: Thursday, January 11, 2007 10:09 PM

    Subject: Problem in mysql connection with EOModeler

     

    Hi,

     

    I am working on webobjects 5.2 windows version and trying to connect the mysql database with EOModeler.

    I am using MySql 5.0 and mysql-connector-java-2.0.14-bin.jar in order to connect it to EOModeler and MySql DB.

    I have done all the changes in java.plist file and also copied this jar file in the apple/library/java directory.

     

    But while trying to connect it prompts a message saying "Communication failure during handshake: Is there a server running on localhost: 3306"

    Is it a driver problem or what?

    Do anyone have idea about this. How to solve this problem?

     

    Thanks in advance

    Ashutosh Sharma

     

    DISCLAIMER:
    This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.. 


----------------------------------------------------------------------------

    _______________________________________________
    WebObjects-dev mailing list
    [email protected]
    http://www.omnigroup.com/mailman/listinfo/webobjects-dev


  DISCLAIMER:
  This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated..

_______________________________________________
WebObjects-dev mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/webobjects-dev