Re: Strange SQL Statement generated....
Re: Strange SQL Statement generated....
- Subject: Re: Strange SQL Statement generated....
- From: Sherry Tirko <email@hidden>
- Date: Thu, 4 Sep 2008 10:47:02 -0400
As part of the update, did you move to a different machine? We were
seeing strange EOF problems because we were using an updated JBDC
driver and should have stayed with the original one.
On Sep 3, 2008, at 10:05 PM, Owen McKerrow wrote:
Hi All,
Updating an old application and have come across a very weird
situation. Code which was working fine 2 days ago now produces an
error. So I made the simplest test case I could and yet I still get
the error.....
GeneralInfo gi =
(GeneralInfo)EOUtilities.objectWithFetchSpecificationAndBindings(ec,
"GeneralInfo", "find", new NSDictionary());
gi.setUpdaterRunning(new Integer(3));
ec.saveChanges();
which produces the following SQL and error message
....
11:58:39,855 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) -
evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn
$OracleExpression: "SELECT t0.client_id, t0.common_rules,
t0.general_info, t0.menu_Message, t0.updater_running FROM
GENERAL_INFO t0 WHERE t0.client_id = ?" withBindings: 1:2(client_id)>
11:58:39,863 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) - 1
row(s) processed
11:58:39,864 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) - ===
Commit Internal Transaction
11:58:39,881 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) - ===
Begin Internal Transaction
11:58:39,881 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) -
evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn
$OracleExpression: "SELECT t0.client_id, t0.common_rules,
t0.general_info, t0.menu_Message, t0.updater_running FROM
GENERAL_INFO t0 WHERE t0.client_id = ? FOR UPDATE" withBindings:
1:2(client_id)>
11:58:39,893 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) - 1
row(s) processed
11:58:39,898 DEBUG [Thread-1] (Log.NSLogDebug:1546 appendln) - ===
Rollback Internal Transaction
11:58:39,898 DEBUG [Thread-1] (Main:187 doUpdate) -
updateStatementForRow: qualifier may not be null
11:58:39,934 OFF [Thread-1] (Log.NSLogErr:1546 appendln) -
EXCEPTION:
updateStatementForRow: qualifier may not be null
DATE/TIME:
2008-09-04 01:58:39 Etc/GMT
null
STACK TRACE:
at
_exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:
4685)
at performChanges(EODatabaseContext.java:6393)
at saveChangesInEditingContext(EOObjectStoreCoordinator.java:415)
at saveChanges(EOEditingContext.java:3226)
at doUpdate(SyncUtil.java:114)
at run(SyncUtil.java:81)
I don't understand why it wants to fetch the GeneralInfo object from
the database again? And I don't think I have ever seen SQL "FOR
UPDATE" which is tacked onto the end of the second select statement.
Can anyone suggest what may be going on and why ?
Owen McKerrow
WebMaster, emlab
Ph : +61 02 4221 5517
http://emlab.uow.edu.au
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - -
"I like the way this project has somehow, against all common sense,
got itself made."
- Peter Jackson, "The Lord of The Rings"
_______________________________________________
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