Freaky. Can you share the SQL Map and the bean (if there is one)? Larry
On 9/2/07, Zsolt Koppany <[EMAIL PROTECTED]> wrote: > > > > > VARCHAR(255) > > > > > Zsolt > > > ________________________________ > > > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: Friday, August 31, 2007 4:39 PM > To: [email protected] > Subject: Re: Not working with derby 10.3.1.4 > > > > > 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 > >
