I see the following error when my test tries to insert FLOAT.MAX_VALUE . I am executing the test using DB2 Type 2 driver.

      ps.setFloat(15, Float.MAX_VALUE); -> does not work
     // ps.setFloat(15, 1); -> works

Exception is com.ibm.db2.jcc.a.dh: Non-atomic batch failure. The batch was submi
tted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements.
getErrorCode()-99999
getSQLState()null
Exception iscom.ibm.db2.jcc.a.SqlException: Error for batch element #0: DB2 SQL
error: SQLCODE: -302, SQLSTATE: 22003, SQLERRMC: null
getErrorCode()-302
getSQLState()22003

Here is the database related information for DB2 :

getURL():jdbc:db2://agni-1.sfbay.sun.com:50000/dbsmpl1
isReadOnly():false
getConnection():com.ibm.db2.jcc.c.b@16fd0b7
getResultSetHoldability():1
getUserName():j2ee
getDatabaseProductName():DB2/SUN
getDatabaseProductVersion():SQL08014
getDriverName():IBM DB2 JDBC Universal Driver Architecture
getDriverVersion():1.5.54

Please contact me if you require more information.

Thanks
Sailaja
x 15285

~
###@###.### 2004-03-09