Re: DB2
Re: DB2
- Subject: Re: DB2
- From: Pascal Robert <email@hidden>
- Date: Wed, 21 Apr 2010 10:55:57 -0400
Le 10-04-21 à 10:45, Jeffrey Simpson a écrit :
Does anyone else use DB2 with WebObjects?
Looking at the results of the 2009 surveys, only two organizations are
using EOF with DB2, yours being one of the two.
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
_______________________________________________
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: | |
| | >DB2 (From: Jeffrey Simpson <email@hidden>) |