Hi,
I am using the glassfishv2.1 bundled with HADB , server is running fine with sun DB2 datasource : com.sun.sql.jdbcx.db2.DB2DataSource
My property settings are :
<property name="databasename" value=""/>
<property name="url" value=""/>
<property name="DriverType" value=""/>
<property name="username" value=""/>
<property name="password" value=""/>
<property name="servername" value=""/>
<property name="AlternateID" value=""/>
<property name="batchPerformanceWorkaround" value="true"/>
For some of the Insert , update & select operation its working fine . but some of the operation which involve batch updation it throwing Exception :
NestedStackTrace:
com.sun.sql.jdbc.base.BaseBatchUpdateException: [sunm][DB2 JDBC Driver][DB2]VALUE OF INPUT HOST VARIABLE NUM 84 NOT USED; WRONG DATA TYPE
at com.sun.sql.jdbc.db2.DB2ImplStatement.executeBatch(Unknown Source)
at com.sun.sql.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.sun.sql.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
at com.sun.sql.jdbcx.base.BaseStatementWrapper.executeBatch(Unknown Source)
at com.sun.gjc.spi.base.StatementWrapper.executeBatch(StatementWrapper.java:537)
at com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.DBStatement.executeBatch(DBStatement.java:154)
at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeUpdateBatch(SQLStoreManager.java:598)
at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeBatch(SQLStoreManager.java:536)
at com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.updatePersistent(SQLStateManager.java:922)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.flushToDataStore(PersistenceManagerImpl.java:1499)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.flushTxCache(PersistenceManagerImpl.java:1426)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:1360)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.notifyBeforeCompletion(TransactionImpl.java:1151)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.commitBefore(TransactionImpl.java:790)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.beforeCompletion(TransactionImpl.java:681)
at com.sun.ejb.containers.ContainerSynchronization.beforeCompletion(ContainerSynchronization.java:167)
at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99)
please let me know if i have missed any property setting in my Datasource configuration.
Thanks in Advance
Regards
Prahlad
[Message sent by forum member 'usn45678' (usn45678)]
http://forums.java.net/jive/thread.jspa?messageID=340227