Thanks for your help guys. The attributes of the problem entity were not prototyped. When I added prototypes everything worked fine. Why this is true I do not know. I talked to my boss and he has committed to us writing a DB2 plugin for Wonder. I do not get to work on this until after I complete this upgrade.
Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. [email protected] Apr 21, 2010, at 2:00 PM, Chuck Hill wrote: > > On Apr 21, 2010, at 7:45 AM, Jeffrey Simpson wrote: > >> Does anyone else use DB2 with WebObjects? I have was thinking of >> cleaning up my DB2 plugin and submitting it to Wonder. I did not >> write most of it. All the comments are in German and the dates are >> all pre 2004. I would love to know who the author was. If someone >> has a more up to date Db2 plugin I would love to know. > > We have not used it for a while now, but I think having support in > Wonder would be good. > > >> I have been upgrading my app to 5.4 and started to get the following >> error on inserts: >> >> EvaluateExpression failed: <com.webobjects.jdbcadaptor.As400PlugIn >> $As400Expression: "INSERT INTO >> YFUALFADEV.USERNAME_PASSWORD_SESSION(USERNAME_PASSWORD_ID, >> APP_INSTANCE, BROWSER_SESSION_ID, CLIENT_IP, PLATFORM, >> BROWSER_VERSION, SESSION_ID, ADVISELOGOUT, BROWSER_NAME, LOGIN_TIME, >> LOGOUT_TIME, APP_HOST, ID, CLIENT_HOST) VALUES (?, ?, ?, >> NULL, ?, ?, ?, ?, ?, ?, NULL, ?, ?, NULL)" withBindings: >> 1:3220(usernamePasswordID), 2:-1(applicationInstance), >> 3:"A0C108B79214BFB73C25DBDA6EE2D860"(browserSessionID), >> 4:"MacOS"(platform), 5:"5.0"(browserVersion), >> 6:"jXggdoBSYar5rpo6iMhT7g"(sessionID), 7:1(adviseLogout), >> 8:"Mozilla"(browserName), 9:2010-04-21 10:42:32(loginTime), >> 10:"chekov.yfuusa.local"(applicationHost), 11:-12508119(id)>: Next >> exception:SQL State:22501 -- error code: -311 -- msg: [SQL0311] >> Length in a varying-length or LOB host variable not valid. >> Cause . . . . . : Host variable was specified. The value in the >> length portion of the variable length or LOB host variable is either >> negative or greater than the declared length. If the host variable >> is graphic the length should be the number of DBCS characters. The >> host variable number is . The specified length is . The variable is >> declared to have length . Recovery . . . : Change the length portion >> of the varying-length or LOB host variable to a valid positive >> number or zero. Try the request again. Next exception:SQL Warning: >> 01H10 -- error code: -99999 -- msg: Extra URL elements are ignored. > > I am not sure what that means. Are you using Wonder? If not, is > there out dated jdbc2info in your EOModel? It kind of seems like it > is interpreting what you are using for varchar as CLOB. > > >> Anyone have any idea? I checked the model and none of the values >> are larger then the columns. Do you think rewriting the plugin to >> match the Wonder examples may help? > > > It might, but it seems more like a mismatch in data type. Are the > wrong prototypes getting loaded? Do you need an updated DB2 JDBC > driver? > > > Chuck > > > -- > Chuck Hill Senior Consultant / VP Development > > 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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
