SQL Drivers are notorious for being cryptic with their exceptions. "Invalid conversion" sounds just great. :-)
From reading the info below, it seems to me that it could be the Websphere CMP problem, not the driver. I would recommend starting with the latest patches to the Websphere. Maybe you can convert that particular bean to BMP and see if the problem comes back.
Here are some ideas from Google:
http://www.daimi.au.dk/~dbuser/db2l0/sqll1328.htm
07006 Invalid conversion. The data value cannot be converted to the C data type specified by the argument TargetType.
The function has been called before for the same ColumnNumber value but with a different TargetType value.
http://download-west.oracle.com/otndoc/oracle9i/901_doc/ifs.901/a75172/Errormessages.html
IFS-10406 Invalid AttributeValue conversion ({0} to Java {1}) Cause:
This error generally occurs when writing directly against the Java API. The error is coercing an attribute value to an incorrect datatype. An example of an invalid conversion is coercing a DATE to a BOOLEAN. An example of a valid conversion is coercing an INTEGER to a STRING.
One case worthy of a special mention is in converting from PUBLICOBJECT to PUBLICOBJECT. This will fail if the user does not have permission to access the PublicObject referenced in the AttributeValue.
The parameters {0} and {1} will have the actual values that caused the error.
Possible Actions:
1. Check the datatypes, and modify them to be compatible datatypes.
2. In the case of coercing to a PublicObject, check whether the user can access the PublicObject referenced in the AttributeValue.
Good Luck,
Greg
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 12:04 PM
To: JDJList
Subject: [jdjlist] Websphere 3.5 + DB2
Hi guys,
I am getting the following error in my application that uses Websphere
APP server 3.5 and DB2 (It is a CMP entity bean that is trying to save the
data):
[02.08.28 14:58:59:022 GMT-03:00] 989e1d TransactionCo E Transaction resumed
com.ibm.ejs.jts.jts.LocalOnlyControl@8c8c00
[02.08.28 14:58:58:889 GMT-03:00] a64eaa PortabilityLa > translateException
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0102E Invalid
conversion. SQLSTATE=07006
It happens only sometimes, aparently when the number of users increases.
Does anyone have any clues on that, like a known bug in the DB2 JDBC
driver?
Thanks in advance,
Tedi
To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm
To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm