What is your column type in derby? Apparently the JDBC driver is reporting it as a type of <UNKNOWN>.
Brandon On 8/31/07, Zsolt Koppany <[EMAIL PROTECTED]> wrote: > > Hi, > > I tried to upgrade to derby 10.3.1.4 but I get strange error messages that > I > didn't get with derby 10.2.2.0. > > I use ibatis-2.3.0.677. > > Any ideas? > > Zsolt > > com.intland.codebeamer.persistence.util.PersistenceException: > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in > com/intland/codebeamer/persistence/dao/sqlmap/UserDao.xml. > --- The error occurred while applying a parameter map. > --- Check the createUser-InlineParameterMap. > --- Check the parameter mapping for the 'hostName' property. > --- Cause: java.sql.SQLException: An attempt was made to get a data value > of > type '<UNKNOWN>' from a data value of type 'VARCHAR'. > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate > (Ge > neralStatement.java:91) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert > (SqlMapExecutorDe > legate.java:447) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert( > SqlMapSessionImpl.jav > a:82) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert( > SqlMapClientImpl.java: > 59) > at > com.intland.codebeamer.persistence.util.SqlMapClientWrapper.insert > (SqlMapCli > entWrapper.java:298) > at > com.intland.codebeamer.persistence.dao.AbstractDao.create(AbstractDao.java > :8 > 1) > at > com.intland.codebeamer.persistence.dao.impl.UserDaoImpl.create( > UserDaoImpl.j > ava:81) > at > > com.intland.codebeamer.persistence.test.WorkingSetItemDaoTests.prepareDummy > ( > WorkingSetItemDaoTests.java:72) > at > com.intland.codebeamer.persistence.test.WorkingSetItemDaoTests.testCrud > (Work > ingSetItemDaoTests.java:32) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > :39 > ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke > (DelegatingMethodAccessorImpl > .java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at junit.framework.TestCase.runTest(TestCase.java:154) > at junit.framework.TestCase.runBare(TestCase.java:127) > at > org.springframework.test.ConditionalTestCase.runBare( > ConditionalTestCase.jav > a:69) > 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:118) > at > org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run > (JUnit3T > estReference.java:130) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java > :3 > 8) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests > (RemoteTestRu > nner.java:460) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests > (RemoteTestRu > nner.java:673) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run > (RemoteTestRunner. > java:386) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main > (RemoteTestRunner > .java:196) > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in > com/intland/codebeamer/persistence/dao/sqlmap/UserDao.xml. > --- The error occurred while applying a parameter map. > --- Check the createUser-InlineParameterMap. > --- Check the parameter mapping for the 'hostName' property. > --- Cause: java.sql.SQLException: An attempt was made to get a data value > of > type '<UNKNOWN>' from a data value of type 'VARCHAR'. > ... 26 more > Caused by: java.sql.SQLException: An attempt was made to get a data value > of > type '<UNKNOWN>' from a data value of type 'VARCHAR'. > at > org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.client.am.SqlException.getSQLException(Unknown > Source) > at org.apache.derby.client.am.PreparedStatement.setNull(Unknown > Source) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > :39 > ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke > (DelegatingMethodAccessorImpl > .java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke > (PreparedStat > ementLogProxy.java:70) > at $Proxy1.setNull(Unknown Source) > at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter > (Ba > sicParameterMap.java:171) > at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameters > (B > asicParameterMap.java:125) > at > com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate( > SqlExecutor.jav > a:79) > at > > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate > (GeneralStatement.java:200) > at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate > (Ge > neralStatement.java:78) > ... 25 more > Caused by: org.apache.derby.client.am.SqlException: An attempt was made to > get a data value of type '<UNKNOWN>' from a data value of type 'VARCHAR'. > at > > org.apache.derby.client.am.PreparedStatement$PossibleTypes.throw22005Excepti > on(Unknown Source) > ... 37 more > > > Zsolt > >
