ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Not working with derby 10.3.1.4
Date Mon, 03 Sep 2007 03:50:42 GMT
Freaky. Can you share the SQL Map and the bean (if there is one)?

Larry


On 9/2/07, Zsolt Koppany <zkoppanylist@intland.com> wrote:
>
>
>
>
> VARCHAR(255)
>
>
>
>
> Zsolt
>
>
>  ________________________________
>
>
> From: Brandon Goodin [mailto:brandon.goodin@gmail.com]
>  Sent: Friday, August 31, 2007 4:39 PM
>  To: user-java@ibatis.apache.org
>  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 < 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