Re: From Oracle to MySql - Part II
Re: From Oracle to MySql - Part II
- Subject: Re: From Oracle to MySql - Part II
- From: Kieran Kelleher <email@hidden>
- Date: Tue, 4 Jan 2005 09:57:06 -0500
Unlike Mac OS X, Windows version of EOModeler uses OLD type JDBC.
WebObjects applications use the latest type of JDBC. I don't develop on
Windows, but here is the information I have gathered on that topic:
http://homepage.mac.com/kelleherk/iblog/C1216817469/E562266648/
index.html
If that does not help, I am sure there is _someone_ on this list that
knows where to put the two jdbc drivers simultaneously so that both
EOModeler and WebObjects app work and get their respective jdbc drivers
when needed.
-Kieran
________________________________________________________________
Dev Config = OS X 10.3.5 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 /
MySQL 4.0.20 / Connector-J 3.0.11
Deploy Config = OS X 10.3.7 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL
4.0.20 / Connector-J 3.0.11
My Blog: http://webobjects.webhop.org/
On Jan 4, 2005, at 9:36 AM, Pierre Gilquin wrote:
Kieran,
Thank you for you help.
I am using MySql 4.0.20a
I have also try the mm.mysql-2.0.14-bin.jar JDBC driver and it is
exactely
the same problem.
I have try the mysql-connector-java-3.0.16-ga-bin.jar but I was not
able to
make EOModel connect the database.
I am on a Windows machine. That may be why ?
Pierre
----- Original Message -----
From: "Kieran Kelleher" <email@hidden>
To: "Pierre Gilquin" <email@hidden>
Cc: <email@hidden>
Sent: Tuesday, January 04, 2005 3:10 PM
Subject: Re: From Oracle to MySql - Part II
I would first try and use the latest MySQL jdbc driver ..... 2.0.4 is
pretty old. I use 3.0.11
What version of MySQL are you using?
________________________________________________________________
Dev Config = OS X 10.3.5 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 /
MySQL 4.0.20 / Connector-J 3.0.11
Deploy Config = OS X 10.3.5 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL
4.0.20 / Connector-J 3.0.11
My Blog: http://webobjects.webhop.org/
On Jan 4, 2005, at 3:50 AM, Pierre Gilquin wrote:
Hi all,
I have transform an Oracle EOmodel to MySql using switch adaptor.
Everything
works fine, the attribute are translated in the MySql types and I am
able to
fetch anything in EOmodel.
But it seems that I have problems with sub-classes in applications.
I am able to create an object from a sub classe of Substance (defined
by
category = 'CYT') but impossible to read it afterward !
The mysql jdbc driver is mm.mysql-2.0.4-bin.jar
The trace is the following :
...
[2005-01-04 09:09:31 CET] <main> Using JDBCPlugIn
'com.webobjects.jdbcadaptor.MySQLPlugIn' for JDBCAdaptor@12818976
[2005-01-04 09:09:31 CET] <main> connecting with dictionary: {plugin
= "";
username = "root"; driver = "org.gjt.mm.mysql.Driver"; password =
"<password
deleted for log>"; URL =
"jdbc:mysql://localhost/test?capitalizeTypeNames=true
"; }
[2005-01-04 09:09:32 CET] <main> === Begin Internal Transaction
[2005-01-04 09:09:32 CET] <main> evaluateExpression:
<com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT
t0.AUC,
t0.Cmax, t0.DCI, t0.Q0, t0.TDemi, t0.Vd, t0.id, t0.biodisponibilite,
t0.category, t0.idEMediat, t0.invisible, t0.isomere, t0.VERROU,
t0.metabolite, t0.metaboliteActif, t0.nomLocal, t0.poidsMoleculaire
FROM
Substance t0 WHERE t0.category = ?" withBindings: 1:"CYT"(category)>
[2005-01-04 09:09:32 CET] <main> fetch canceled
[2005-01-04 09:09:32 CET] <main> 0 row(s) processed
[2005-01-04 09:09:32 CET] <main> === Commit Internal Transaction
[2005-01-04 09:09:32 CET] <main> === Commit Internal Transaction
[2005-01-04 09:09:32 CET] <main> A fatal exception occurred: null
[2005-01-04 09:09:32 CET] <main>
com.webobjects.jdbcadaptor.JDBCAdaptorException
at
com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:
322)
at
com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:304)
at
com.webobjects.jdbcadaptor.JDBCChannel.fetchRow(JDBCChannel.java:
1395)
at
com.webobjects.eoaccess.EODatabaseChannel._fetchObject(EODatabaseChan
ne
l.jav
a:303)
Thank in advance for any help
Pierre.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
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