com.ibm.db2.jcc.b.SQLException

The value of input host variable or parameter number "2" cannot be used because of its data type.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web12

  • via Oracle Community by 3004, 1 year ago
    The value of input host variable or parameter number "2" cannot be used because of its data type.
  • via Oracle Community by 843829, 1 year ago
    The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". at com.ibm.ejs.container.ContainerManagedBeanO.store(ContainerManagedBeanO.java(Compiled Code)) at com.ibm.ejs.container.EntityBeanO.beforeCompletion
  • The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". at com.ibm.ejs.container.ContainerManagedBeanO.store(ContainerManagedBeanO.java(Compiled Code)) at com.ibm.ejs.container.EntityBeanO.beforeCompletion
  • Stack trace

    • com.ibm.db2.jcc.b.SQLException: The value of input host variable or parameter number "2" cannot be used because of its data type. at com.ibm.db2.jcc.b.ce.e(ce.java:1093) at com.ibm.db2.jcc.b.ce.a(ce.java:884) at com.ibm.db2.jcc.a.bd.n(bd.java:535) at com.ibm.db2.jcc.a.bd.i(bd.java:228) at com.ibm.db2.jcc.a.bd.c(bd.java:54) at com.ibm.db2.jcc.a.r.c(r.java:53) at com.ibm.db2.jcc.a.bp.h(bp.java:156) at com.ibm.db2.jcc.b.ce.j(ce.java:880) at com.ibm.db2.jcc.b.cf.a(cf.java:1516) at com.ibm.db2.jcc.b.cf.executeQuery(cf.java:303) at com.solarmetric.datasource.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:93) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedQueryInternal(SQLExecutionManagerImpl.java:707) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQueryInternal(SQLExecutionManagerImpl.java:600) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:355) at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeQuery(SQLExecutionManagerImpl.java:339) at com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.loadByPK(ClassMapping.java:940) at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.initialize(JDBCStoreManager.java:388) at com.solarmetric.kodo.runtime.StateManagerImpl.loadInitialState(StateManagerImpl.java:215) at com.solarmetric.kodo.runtime.PersistenceManagerImpl.getObjectByIdFilter(PersistenceManagerImpl.java:1278) at com.solarmetric.kodo.runtime.PersistenceManagerImpl.getObjectById(PersistenceManagerImpl.java:1179) at au.com.aig.aiaa.services.productionreports.test.AgentProductionReportTest.testGetAgentProductionReportId(AgentProductionReportTest.java:65) at java.lang.reflect.Method.invoke(Native Method) at junit.framework.TestCase.runTest(TestCase.java:166) at junit.framework.TestCase.runBare(TestCase.java:140) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:131) at junit.framework.TestSuite.runTest(TestSuite.java:173) at junit.framework.TestSuite.run(TestSuite.java:168) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.