Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: SQLite INSERT errors with WO

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQLite INSERT errors with WO

Subject: Re: SQLite INSERT errors with WO
From: Josef Vanek <email@hidden>
Date: Sat, 17 Jan 2009 23:33:50 +0100

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 JDBCAdaptor@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 JDBCContext@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@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
-------------------------------------------------------
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@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


_______________________________________________
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: SQLite INSERT errors with WO
From: Chuck Hill <email@hidden>


References:  
  >SQLite INSERT errors with WO (From: Josef Vanek <email@hidden>)
  >Re: SQLite INSERT errors with WO (From: Mike Schrag <email@hidden>)
  >Re: SQLite INSERT errors with WO (From: Josef Vanek <email@hidden>)
  >Re: SQLite INSERT errors with WO (From: Mike Schrag <email@hidden>)
  >Re: SQLite INSERT errors with WO (From: Pascal Robert <email@hidden>)
  >Re: SQLite INSERT errors with WO (From: James Cicenia <email@hidden>)




Prev by Date:
Re: Class names or value type mismach in EOModel ?

Next by Date:
Re: Class names or value type mismach in EOModel ?

Previous by thread:
Re: SQLite INSERT errors with WO

Next by thread:
Re: SQLite INSERT errors with WO

Index(es):

Date
Thread