Re: Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key
Re: Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key
- Subject: Re: Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key
- From: Chuck Hill <email@hidden>
- Date: Mon, 16 Jul 2007 14:37:52 -0700
Did you forget to set the plugin class in the model connection
dictionary?
Chuck
On Jul 16, 2007, at 2:32 PM, Jerry Haynes wrote:
I think my problem began when I updated WOLips to 2.0.0.4118 but
I'm not exactly sure. I'm getting the error below while creating a
new record in a Sybase database. I've tried starting up the project
in java 1.4 and 1.5 but the problem persists.
I've used the the SybasePlugin.java (or one similar to the one in
the link below) for several years but my project doesn't seem to be
using it anymore. I threw some logging into the newPrimaryKeys
method but I never see the output.
Is this a Eclipse/WOLips newbie problem?
SybasePlugIn
<http://docjar.org/html/api/org/objectstyle/woproject/util/
SybasePlugIn.java.html>
The SybasePlugIn is supposed to use eo_sequence_table instead of
EO_PK_TABLE. I do have a EoPkForTable stored procedure in my model.
[2007-07-16 17:02:25 EDT] <Thread-1> evaluateExpression:
<com.webobjects.jdbcadaptor.SybasePlugIn$SybaseExpression: "UPDATE
EO_PK_TABLE SET PK = PK WHERE NAME = 'dbo.VendTransaction'">
[2007-07-16 17:02:26 EDT] <Thread-1> unable to find primary key
value for dbo.VendTransaction
[2007-07-16 17:02:26 EDT] <Thread-1>
com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.SybasePlugIn$SybaseExpression:
"UPDATE EO_PK_TABLE SET PK = PK WHERE NAME = 'dbo.VendTransaction'">:
Next exception:SQL State:42000 -- error code: 208 -- msg:
EO_PK_TABLE not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
at com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel
(JDBCContext.java:138)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression
(JDBCChannel.java:310)
at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression
(JDBCChannel.java:261)
at com.webobjects.jdbcadaptor.JDBCPlugIn.newPrimaryKeys
(JDBCPlugIn.java:561)
at
com.webobjects.jdbcadaptor.JDBCChannel.primaryKeysForNewRowsWithEntity
(JDBCChannel.java:537)
at
com.webobjects.eoaccess.EODatabaseContext._batchNewPrimaryKeysWithEnti
ty(EODatabaseContext.java:5900)
at
com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinato
r(EODatabaseContext.java:5883)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditing
Context(EOObjectStoreCoordinator.java:409)
at com.webobjects.eocontrol.EOEditingContext.saveChanges
(EOEditingContext.java:3226)
at SyncCRC.syncCRC(SyncCRC.java:137)
at SyncCRCPage.performAction(SyncCRCPage.java:60)
at com.webobjects.woextensions.WOLongResponsePage.run
(WOLongResponsePage.java:155)
at java.lang.Thread.run(Thread.java:613)
Thanks,
Jerry Haynes
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
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