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