So finally I really don't know what to think about all this. When
printing the content of JavaJDBCAdaptor.framework, I found
the following :
com/webobjects/
com/webobjects/jdbcadaptor/
com/webobjects/jdbcadaptor/DerbyPlugIn$DerbyExpression.class
com/webobjects/jdbcadaptor/DerbyPlugIn$DerbySynchronizationFactory.class
com/webobjects/jdbcadaptor/DerbyPlugIn.class
com/webobjects/jdbcadaptor/FrontBaseTypes.class
com/webobjects/jdbcadaptor/FrontbasePlugIn$FrontbaseExpression.class
com/webobjects/jdbcadaptor/FrontbasePlugIn
$FrontbaseSynchronizationFactory$FrontbaseColumnDescription.class
com/webobjects/jdbcadaptor/FrontbasePlugIn
$FrontbaseSynchronizationFactory$FrontbaseIndexDescription.class
com/webobjects/jdbcadaptor/FrontbasePlugIn
$FrontbaseSynchronizationFactory$FrontbaseTableDescription.class
com/webobjects/jdbcadaptor/FrontbasePlugIn
$FrontbaseSynchronizationFactory.class
com/webobjects/jdbcadaptor/FrontbasePlugIn.class
com/webobjects/jdbcadaptor/JDBCAdaptor.class
com/webobjects/jdbcadaptor/JDBCAdaptorException.class
com/webobjects/jdbcadaptor/JDBCChannel.class
com/webobjects/jdbcadaptor/JDBCColumn.class
com/webobjects/jdbcadaptor/JDBCContext.class
com/webobjects/jdbcadaptor/JDBCExpression.class
com/webobjects/jdbcadaptor/JDBCExpressionFactory.class
com/webobjects/jdbcadaptor/JDBCFetchPrivate.class
com/webobjects/jdbcadaptor/JDBCPlugIn$LobEntry.class
com/webobjects/jdbcadaptor/JDBCPlugIn.class
com/webobjects/jdbcadaptor/MerantPlugIn$MerantExpression.class
com/webobjects/jdbcadaptor/MerantPlugIn
$MerantSynchronizationFactory.class
com/webobjects/jdbcadaptor/MerantPlugIn.class
com/webobjects/jdbcadaptor/MicrosoftPlugIn$MicrosoftExpression.class
com/webobjects/jdbcadaptor/MicrosoftPlugIn
$MicrosoftSynchronizationFactory.class
com/webobjects/jdbcadaptor/MicrosoftPlugIn.class
com/webobjects/jdbcadaptor/MySQLPlugIn$MySQLExpression.class
com/webobjects/jdbcadaptor/MySQLPlugIn$MySQLSynchronizationFactory.class
com/webobjects/jdbcadaptor/MySQLPlugIn.class
com/webobjects/jdbcadaptor/OpenBasePlugIn$OpenBaseExpression.class
com/webobjects/jdbcadaptor/OpenBasePlugIn
$OpenBaseSynchronizationFactory$OpenBaseColumnDescription.class
com/webobjects/jdbcadaptor/OpenBasePlugIn
$OpenBaseSynchronizationFactory$OpenBaseIndexDescription.class
com/webobjects/jdbcadaptor/OpenBasePlugIn
$OpenBaseSynchronizationFactory$OpenBaseTableDescription.class
com/webobjects/jdbcadaptor/OpenBasePlugIn
$OpenBaseSynchronizationFactory.class
com/webobjects/jdbcadaptor/OpenBasePlugIn.class
com/webobjects/jdbcadaptor/OraclePlugIn$OracleExpression.class
com/webobjects/jdbcadaptor/OraclePlugIn
$OracleSynchronizationFactory.class
com/webobjects/jdbcadaptor/OraclePlugIn.class
com/webobjects/jdbcadaptor/SybasePlugIn$SybaseExpression.class
com/webobjects/jdbcadaptor/SybasePlugIn
$SybaseSynchronizationFactory.class
com/webobjects/jdbcadaptor/SybasePlugIn.class
META-INF/INDEX.LIST
As you can see, there is no SqlitePlugIn anywhere..... I can't figure
out how WO printed it in the logs.
And with some breakpoints in my code and a little jad help, I found
that the problem seems to come from
JDBCChannel, method _bindInputVariablesWithBindingsAndExecute which
contains a code like :
ResultSet resultset = _statement.getResultSet();
and, unfortunately it happens that Sqlite jdbc driver doesn't return
any ResultSet with INSERT/UPDATE
queries....
So... what could be done to fix this ? Overload the evaluateExpression
method in a custom class which
inherits from JDBCChannel ? Or write a new JDBC driver which returns
for every request a ResultSet ?
Finally it is maybe the only wau to use WO with mysql and then export/
dump to sqlite :D
Josef
Le 17 janv. 09 à 22:35, James Cicenia a écrit :
Now isn't that ironic! I was actually using WebObjects to manage a
mySQL database that I was then
going to use as a master to a sqlLite database!
Heck going straight to sqlite would actually be useful
James Cicenia
On Jan 17, 2009, at 12:34 PM, Pascal Robert wrote:
No, the next question is when Wonder will fix it :-P
Yep, you're right .. who knew .. the next question is whether it
actually works :)
ms
On Jan 17, 2009, at 1:16 PM, Josef Vanek wrote:
I think there is one, givent the following log :
Using JDBCPlugIn 'com.webobjects.jdbcadaptor.SqlitePlugIn' for
jdbcadap...@1939071484
[2009-01-17 16:42:28 CET] <main> connecting with dictionary:
{driver = "org.sqlite.JDBC"; plugin = ""; password = "<password
deleted for log>"; URL = "jdbc:sqlite:/<path>/database.db"; }
[2009-01-17 16:42:28 CET] <main> fetching JDBC Info with
jdbccont...@731400457
Josef
Le 17 janv. 09 à 18:52, Mike Schrag a écrit :
Driver: org.sqlite.JDBC
URL: jdbc:sqlite:/<absolute path>/database.db
JDBC driver: sqlitejdbc-v054.jar
Is there even a sqlite plugin for WO? I didn't think so
(although it might not be a bad idea to make one). You could
try FrontBase if you're looking for painless install (or maybe
Apache Derby).
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/pallas%40free.fr
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
This email sent to [email protected]
-------------------------------------------------------
Pascal Robert
http://www.macti.ca
http://www.aircourriel.com
http://www.linkedin.com/in/macti
Skype: MacTICanada
AIM/iChat : MacTICanada
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/james%40jimijon.com
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/pallas%40free.fr
This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
