Re: SQLite INSERT errors with WO
Re: SQLite INSERT errors with WO
- Subject: Re: SQLite INSERT errors with WO
- From: Chuck Hill <email@hidden>
- Date: Mon, 19 Jan 2009 12:29:12 -0800
On Jan 17, 2009, at 2:33 PM, Josef Vanek wrote:
So finally I really don't know what to think about all this. When
printing the content of JavaJDBCAdaptor.framework, I found
the following :
As you can see, there is no SqlitePlugIn anywhere..... I can't
figure out how WO printed it in the logs.
It might just be a misleading log message. IF there was a plug-in,
that would be the default class name that WO would use.
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 ?
Maybe. It might be as simple as making a plug-in (Wonder has some
good examples) with
public boolean useBindVariables() {
return false;
}
Or write a new JDBC driver which returns for every request a
ResultSet ?
That should not be necessary.
Finally it is maybe the only wau to use WO with mysql and then
export/dump to sqlite :D
Or just use a real database like FrontBase. :-) It is free, easy to
install and use, powerful, and supported. Why use a toy?
Chuck
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:
@free.fr
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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