I suspect, you may have hit a bug in driver for batch update support. A
simple work around is to disable batching. You can achieve this by
setting system property
"com.sun.jdo.spi.persistence.support.sqlstore.USE_BATCH" to "false" in
your domain.xml
glassfish_at_javadesktop.org wrote:
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>