strange SQL error
strange SQL error
- Subject: strange SQL error
- From: Johann Werner <email@hidden>
- Date: Tue, 24 Apr 2007 16:10:07 +0200
Hi,
sorry for posting this question but unfortunately I am in a hurry to
correct that strange behaviour as just now people are beginning to
use my WO app :-O
I had my WO app running with MySQL up to now but had to switch to
another database since yesterday, so I chose FrontBase. Now I got it
up running without problems (after I found the tip that foreign key
constraints have to be deactivated for FrontBase)... though I thought
it was.
As I checked my mails I saw some errors (the app sends me any
occuring exceptions per mail). What is really intriguing me is that
the app is not really big and I tested everything and had no error at
all. These errors originated from other users accessing the app. So I
could not reproduce the error myself, even the SELECT statement that
the error is about does not get generated in the sql-logfiles when I
use the app. The error output is:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.FrontbasePlugIn
$FrontbaseExpression: "SELECT "ID" FROM USER WHERE ("ID" = 1000004
AND "EMAIL" = 'email@hidden') AND ID = ID">:
Next exception:SQL State:00 subclass = " -- error code:
130 -- msg: Syntax error 130. Expected <table reference> not found.
Next exception:SQL State:00 subclass = " -- error code:
130 -- msg: Syntax error 130. Expected <table reference> not found.
Next exception:SQL State:00 subclass = " -- error code:
108 -- msg: Syntax error 108. Expected .
Next exception:SQL State:40 subclass = 00 -- error code:
363 -- msg: Exception condition 363. Transaction rollback.
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.FrontbasePlugIn
$FrontbaseExpression: "SELECT "ID" FROM USER WHERE ("ID" = 1000004
AND "EMAIL" = 'email@hidden') AND ID = ID">:
Next exception:SQL State:00 subclass = " -- error code:
130 -- msg: Syntax error 130. Expected <table reference> not found.
Next exception:SQL State:00 subclass = " -- error code:
130 -- msg: Syntax error 130. Expected <table reference> not found.
Next exception:SQL State:00 subclass = " -- error code:
108 -- msg: Syntax error 108. Expected .
Next exception:SQL State:40 subclass = 00 -- error code:
363 -- msg: Exception condition 363. Transaction rollback.
at
com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextI
nformationAdded(EODatabaseContext.java:4685)
at com.webobjects.eoaccess.EODatabaseContext.performChanges
(EODatabaseContext.java:6393)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingCo
ntext(EOObjectStoreCoordinator.java:415)
at com.webobjects.eocontrol.EOEditingContext.saveChanges
(EOEditingContext.java:3226)
at StudentenEingabeMaske.datenSpeichern(StudentenEingabeMaske.java:243)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at KeyValueCodingProtectedAccessor.methodValue
(KeyValueCodingProtectedAccessor.java:54)
at com.webobjects.foundation.NSKeyValueCoding
$_MethodBinding.valueInObject(NSKeyValueCoding.java:1160)
at com.webobjects.foundation.NSKeyValueCoding
$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1268)
at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:
1539)
at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey
(NSKeyValueCoding.java:498)
at com.webobjects.foundation.NSKeyValueCodingAdditions
$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:
212)
at com.webobjects.appserver.WOComponent.valueForKeyPath
(WOComponent.java:1600)
at
com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent
(WOKeyValueAssociation.java:46)
at com.webobjects.appserver._private.WOSubmitButton.invokeAction
(WOSubmitButton.java:70)
at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction
(WODynamicGroup.java:101)
at com.webobjects.appserver._private.WODynamicGroup.invokeAction
(WODynamicGroup.java:110)
at com.webobjects.appserver._private.WOForm.invokeAction(WOForm.java:
82)
at
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction
(WODynamicGroup.java:101)
at com.webobjects.appserver._private.WODynamicGroup.invokeAction
(WODynamicGroup.java:110)
at com.webobjects.appserver.WOComponent.invokeAction
(WOComponent.java:945)
at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1168)
at com.webobjects.appserver.WOApplication.invokeAction
(WOApplication.java:1375)
at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWit
hPreparedPage(WOComponentRequestHandler.java:196)
at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWit
hPreparedSession(WOComponentRequestHandler.java:287)
at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWit
hPreparedApplication(WOComponentRequestHandler.java:322)
at
com.webobjects.appserver._private.WOComponentRequestHandler._handleReque
st(WOComponentRequestHandler.java:358)
at
com.webobjects.appserver._private.WOComponentRequestHandler.handleReques
t(WOComponentRequestHandler.java:432)
at com.webobjects.appserver.WOApplication.dispatchRequest
(WOApplication.java:1306)
at com.webobjects.appserver._private.WOWorkerThread.runOnce
(WOWorkerThread.java:173)
at com.webobjects.appserver._private.WOWorkerThread.run
(WOWorkerThread.java:254)
at java.lang.Thread.run(Thread.java:613)
As I am not yet very experienced with WO/FrontBase/SQL and I am
getting short of time I hope someone can give me some hints. I
apologize for this mail as elsewise I would have digged around to try
to get myself a solution.
I should additionally note that the function where this exception
gets thrown is a method that is called when the user sends a form
that is on a component. The function sets different attributes of an
EO named Student and stops at the line ec.saveChanges(). A one-to-one
relation exists between Student <-> User that is listed in the
exception though nothing is accessed through that relation in that
method.
Thanks in advance
Johann Werner
_______________________________________________
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