• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: ConnectorJ and MySQL4.1
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: ConnectorJ and MySQL4.1


  • Subject: Re: ConnectorJ and MySQL4.1
  • From: Dev WO <email@hidden>
  • Date: Mon, 8 Aug 2005 19:08:14 +0200

Hi Sako,
but if I put 2 version, only one will be use by EOF anyway, because it is written in the connection dictionary, am I wrong?
I don't know about the CheckHands problem,
my problem is that now my database is 4.1, I can no longer get the accentuated character to display properly through the web application (web browser).
And even if I could get something to display, I'm not able to edit or add record in the database... getting the following error:
---
com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier -- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database
---



What is your problem exactly? is it the CheckHands problem?
you need 2 diffrent versions of JDBC drivers (at least for windows. Mac i
have no idea)
1. an old version, because EOModeler uses an old version. it needs it. so
install it.
which version? just try what you have. one must work. i use
mm.mysql-2.0.4-bin.jar for WINDOWS
2. a new version, for your java code. to run properly.
mysql-connector-java-3.0.17-ga-bin.jar for WINDOWS


HTH
Sako.


----- Original Message ----- From: "Dev WO" <email@hidden> To: "WebObjects Development" <email@hidden>; "WO-Dev (Omni)" <email@hidden> Sent: Monday, August 08, 2005 6:32 PM Subject: ConnectorJ and MySQL4.1



Hi list,
I really can't believe I'm the only one with this issue in fact, but
debugging it may help someone soon as it must happen...
So far I'm still having issues related to the migration, so as I
don't want to keep posting all the time about this, I'll try to be as
clear as I can.
I installed a MySQL 4.1.13 on my local machine to try to figure out
what was wrong.
In fact the previous trick about using the "useOldUTF8Behavior=true"
wasn't good enough as the adminitration application crashes everytime
I try to update a row (and even adding one).
I red the debugging of jdbc connection from Chuck's book, but I
couldn't figure out...In fact I even tried to put the jdbc connector
in /Library/WebObjects/Extensions, but then EOModeler would complain
about having no driver in the classpath...
So here's my setup:
-MySQL 4.1.13 Debug (the installer of the standard version just
didn't work)
-Connector/J 3.1.10, not the "g" one (mysql-connector-java-3.1.10-
bin.jar)
-Latest WO and Xcode 2.1

Here's the previous setup that worked:
-MySQL 4.0.x
-Connector/J 3.1.8 (mysql-connector-java-3.1.8-bin.jar) with the
following values "useUnicode=true&characterEncoding=utf8"
-Latest WO and Xcode 2.1

My first question would be: should I use this version of the
connector/J?
My second question would be: anyone with this setup (or something
with MySQL 4.1.x) with accentuated characters (UTF-8) that works?

Thanks for your support... I can't believe I wasted one more day on
this and it's still not fix...I still don't even know if the problem
comes from the data (MySQL) or the connector:(

Xavier

PS: and sorry for so many post relating to this... next ones next
year with Leopard;)
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:


40itcc.datos.de


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
  • Follow-Ups:
    • Re: ConnectorJ and MySQL4.1
      • From: email@hidden
References: 
 >ConnectorJ and MySQL4.1 (From: Dev WO <email@hidden>)

  • Prev by Date: Re: [WO5.2.3] Problem with char parameter in stored procedure(EOF mapping)
  • Next by Date: AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
  • Previous by thread: ConnectorJ and MySQL4.1
  • Next by thread: Re: ConnectorJ and MySQL4.1
  • Index(es):
    • Date
    • Thread