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: Jerry Haynes <email@hidden>
- Date: Tue, 17 Jul 2007 17:47:58 -0400
Yes, I am relying on the connection dictionary in the model. For this
project I just change the username in Application.java to bounce
between Dev and Production.
Application.java:
//Get the FAS EOModel for this project.
EOModel fasModel = EOModelGroup.defaultGroup().modelNamed
(System.getProperty("FASModelName"));
//Get the connection dictionary from the model.
NSDictionary fasModelDict = fasModel.connectionDictionary();
//Duplicate the connection dictionary and replace the login name.
NSMutableDictionary fasConnectDict = new NSMutableDictionary();
fasConnectDict.addEntriesFromDictionary(fasModelDict);
fasConnectDict.setObjectForKey(fasUserLoginName, "username");
fasConnectDict.setObjectForKey("********", "password");
fasModel.setConnectionDictionary(fasConnectDict);
Properties file:
FASModelName=fas
#Unquote for FAS Test
FASUserName=fldadj
#Unquote for FAS Production
#FASUserName=fieldadj
Jerry
On Jul 17, 2007, at 5:26 PM, Chuck Hill wrote:
Cross posting to WOLips as this is where this topic belongs.
On Jul 17, 2007, at 2:09 PM, Jerry Haynes wrote:
I never figured out the issue with Eclipse 3.2.2 and WOLips
2.0.0.4118 but downgrading worked.
I installed a second copy of Eclipse 3.2.2 with WOLips 2.0.0.3702.
I chose this version randomly. I had no issues with my project
with this setup. Records were successfully created.
Because my original installation of Eclipse contains other plug-
ins, I installed a third version of Eclipse 3.2.2 with WOLips
2.0.0.4118. The problem re-appeared.
Nothing else changed on my computer except the version of WOLips.
This will teach me to stop updating when nothing was broken in the
first place.
Any new ideas would be appreciated.
None of the WOLips or Eclipse code runs in the JVM when your app
runs so I don't see how this can be causing the problem.
Are you relying on the connection dictionary in the model or
setting it dynamically at runtime?
Chuck
On Jul 16, 2007, at 5:37 PM, Chuck Hill wrote:
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.primaryKeysForNewRowsWithEnt
ity(JDBCChannel.java:537)
at
com.webobjects.eoaccess.EODatabaseContext._batchNewPrimaryKeysWithE
ntity(EODatabaseContext.java:5900)
at
com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordin
ator(EODatabaseContext.java:5883)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEdit
ingContext(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
--
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