Hi all,
I am trying to get some stored procedures performing after insertion
of new records. The stored procedures generate unique number for
records. That reason why I am using stored procedures is that the
generation can only be done properly on the SQL level. The procedures
themselves are functional. I ran them many times from the OpenBase
cmd line, no problems.
Now I am trying to get WO to automatically invoke them, by defining
and triggering them in the model. However, when I call saveChanges()
on an editing context, which should trigger the stored procedure, I
get the following exception:
com.webobjects.eoaccess.EOGeneralAdaptorException:
evaluateExpression: com.webobjects.jdbcadaptor.JDBCChannel
[EMAIL PROTECTED]: illegal attempt to
evaluateExpression while a fetch is in progress
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 com.havaso.dvis.server.AdminUserCreator.createAdminUsers
(AdminUserCreator.java:181)
at com.havaso.dvis.server.Application.<init>(Application.java:43)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at com.webobjects.appserver.WOApplication.main(WOApplication.java:323)
at com.havaso.dvis.server.Application.main(Application.java:23)
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 com.webobjects._bootstrap.WOBootstrap.main(WOBootstrap.java:71)
No changes are saved to the database.
Separately, both the code and the stored procedure perform as
expected. But after adding the trigger in the model, this is the
outcome. Anyone has an idea why?
Thanks,
Flor
_______________________________________________
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]
