DB2
DB2
- Subject: DB2
- From: Jeffrey Simpson <email@hidden>
- Date: Wed, 21 Apr 2010 10:45:49 -0400
- Acceptlanguage: en-US
- Thread-topic: DB2
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.
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.
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?
Jeffrey Simpson
Senior Software Engineer
Telephone: 240.235.2144
Fax: 240.235.2174
email@hidden
Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world.
_______________________________________________
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
- Follow-Ups:
- Re: DB2
- From: Chuck Hill <email@hidden>
- Re: DB2
- From: Pascal Robert <email@hidden>