Re: DB2
Re: DB2
- Subject: Re: DB2
- From: Jeffrey Simpson <email@hidden>
- Date: Thu, 22 Apr 2010 16:50:27 -0400
- Acceptlanguage: en-US
- Thread-topic: DB2
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@hidden 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
- Follow-Ups:
- Re: DB2
- From: Chuck Hill <email@hidden>
| References: | |
| | >DB2 (From: Jeffrey Simpson <email@hidden>) |
| | >Re: DB2 (From: Chuck Hill <email@hidden>) |