• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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: Mike Schrag <email@hidden>
  • Date: Mon, 16 Jul 2007 17:40:58 -0400

I would verify that the plugin class is defined properly in your model's connection dictionary (or in Properties if you override that) to point to the correct Sybase plugin. You can see from the exception that you're using "com.webobjects.jdbcadaptor.SybasePlugIn $SybaseExpression" which is the builtin version (which DOES use EO_PK_TABLE).

ms

On Jul 16, 2007, at 5: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:
40mdimension.com


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


References: 
 >Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key (From: Jerry Haynes <email@hidden>)

  • Prev by Date: Re: Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key
  • Next by Date: Re: [OT] developing for the iPhone
  • Previous by thread: Re: Eclipse 3.2.2, WOLips 2.0.0.4118 and SybasePlugin not generating primary key
  • Next by thread: ERXMessageEncoding in Project Wonder
  • Index(es):
    • Date
    • Thread