ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Not working with derby 10.3.1.4
Date Fri, 31 Aug 2007 14:38:32 GMT
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 <zkoppanylist@intland.com> 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
>
>

Mime
View raw message