Re: ConnectorJ and MySQL4.1
Re: ConnectorJ and MySQL4.1
- Subject: Re: ConnectorJ and MySQL4.1
- From: email@hidden
- Date: Mon, 8 Aug 2005 19:24:02 +0200
----- Original Message -----
From: "Dev WO" <email@hidden>
To: <email@hidden>
Cc: "WO-Dev (Omni)" <email@hidden>; "WebObjects Development"
<email@hidden>
Sent: Monday, August 08, 2005 7:08 PM
Subject: Re: ConnectorJ and MySQL4.1
> 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?
yes.
When you use EOModeler it uses the old one. thats why you have to change the
classpath in the file
"JavaConfig.plist" under windows.
When you run the application for example using Eclipse or XCode you have to
add the Another version (new).
In this case you use 2 diffrent versions.
> 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
> ---
Ok.
What version do you use for Eclipse/XCode?
Check the following stuff:
1. Can you update a row at all using the username and password saved in the
model?
2. You cant update any row via WO at all. or just in special situations?
(locking problem!)\
3. try this. activate this -DNSDebugGroups=1: to show more Logging in
Eclipse/XCode.
and send me some more output.
4. Try to execute the SQL command in another tool like "MySQL Control
Center" showed on the console from Eclipse/XCode.
>
>
> > 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
>
>
_______________________________________________
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