Hi i am new to Hibernate .I am using WSAD 5.1.1 and DB2.I am getting the following exception while trying to insert data first time .but if i try next time with same data i am able to insert and i did not get any exception. help me to solve this exception .

Thanks



[11/9/06 12:58:57:340 IST] 2a806e7c JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: null
[11/9/06 12:58:57:355 IST] 2a806e7c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
[11/9/06 12:58:57:355 IST] 2a806e7c JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -301, SQLState: 07006
[11/9/06 12:58:57:965 IST] 2a806e7c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Error for batch element #0: The value of input host variable or parameter number "9" cannot be used because of its data type.
[11/9/06 12:58:57:980 IST] 2a806e7c JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: null
[11/9/06 12:58:57:980 IST] 2a806e7c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
[11/9/06 12:58:57:980 IST] 2a806e7c JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -301, SQLState: 07006
[11/9/06 12:58:58:012 IST] 2a806e7c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Error for batch element #0: The value of input host variable or parameter number "9" cannot be used because of its data type.
[11/9/06 12:58:58:027 IST] 2a806e7c SessionImpl E net.sf.hibernate.impl.SessionImpl Could not synchronize database state with session
[11/9/06 12:58:58:043 IST] 2a806e7c SystemErr R net.sf.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

Check the data types of the record you are trying to insert. It looks like you have defined the wrong data type eg trying to insert a String where you have defined the field as an Integer

Hi knoxor ...

Everything fine. See if i am trying second time with same data it is working fine.