Re: Not working with derby 10.3.1.4
> > status=#status#, > > > > downloadlimit=#downloadLimit#, > > > > unused0=#unused0#, > > > > unused2=#eauthid#, > > > > hostname=#hostName#, > > > > lastlogin=#lastLogin#, > > > indexed='0' > WHERE > id = #id# > > > > UPDATE users SET lastlogin=#lastLogin# > > hostname=#hostName# > > WHERE id=#id# > > > > DELETE FROM users WHERE $userIdInClause$ > > > > UPDATE users SET indexed='1' WHERE id=#value:INTEGER# > > > > UPDATE users SET indexed='0' WHERE id=#value:INTEGER# > > > > SELECT * FROM users > > > resultMap="userResult"> > SELECT * FROM users > > prepend="AND"> > indexed=#indexed# > > > > > cacheModel="account-cache" resultMap="userResult"> > SELECT * FROM users > > > id IN > close=")" conjunction=","> > #id[]# > > > > > name=#name# > > > prepend="AND"> > firstname=#firstname# > > > prepend="AND"> > lastname=#lastname# > > > prepend="AND"> > company=#company# > > > prepend="AND"> > > RTRIM(passwd)=${PASSWORD_ENCRYPT}(#passwd#) > > > > email=#email# > > > > status IN > close=")" conjunction=","> > #status[]# > > > > prepend="AND"> > unused2=#eauthid# > > > > ORDER BY name > > > parameterClass="java.util.Map" cacheModel="account-cache" > resultMap="userResult"> > SELECT * FROM users > WHERE > > firstname=#firstName# AND > > lastname=#lastName# AND > status='activated' AND > unused2 IS NULL > ORDER BY lastlogin DESC > > > $LIMIT$ > > > > > > Zsolt > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > > Of Larry Meadors > > Sent: Monday, September 03, 2007 5:51 AM > > To: user-java@ibatis.apache.org > > Subject: Re: Not working with derby 10.3.1.4 > > > > 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) > > > > > > > > > > > > >
RE: Not working with derby 10.3.1.4
SELECT * FROM users indexed=#indexed# SELECT * FROM users id IN #id[]# name=#name# firstname=#firstname# lastname=#lastname# company=#company# RTRIM(passwd)=${PASSWORD_ENCRYPT}(#passwd#) email=#email# status IN #status[]# unused2=#eauthid# ORDER BY name SELECT * FROM users WHERE firstname=#firstName# AND lastname=#lastName# AND status='activated' AND unused2 IS NULL ORDER BY lastlogin DESC $LIMIT$ Zsolt > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Larry Meadors > Sent: Monday, September 03, 2007 5:51 AM > To: user-java@ibatis.apache.org > Subject: Re: Not working with derby 10.3.1.4 > > 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: 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 . > > > > 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 '' 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.j > av > > a:82) > > at > > > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.jav > a > > : > > 59) > > at > > > com.intland.codebeamer.persistence.util.SqlMapClientWrapper.insert(SqlMapC > li > > entWrapper.java:298) > > at > > > com.intland.codebeamer.persistence.dao.AbstractDao.create(AbstractDao.
Re: Not working with derby 10.3.1.4
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: 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 . > > 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 '' 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 '' 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 '' from a data value of type 'VARCHAR'. > at > org.apache.derby.client.am.SQLExceptionFacto
RE: Not working with derby 10.3.1.4
VARCHAR(255) Zsolt _ From: Brandon Goodin [mailto:[EMAIL PROTECTED] 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 . 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 '' 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 '' 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 '' 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 co
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 . 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 '' 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 '' 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 '' 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
Not working with derby 10.3.1.4
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 '' 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 '' 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 '' 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 '' from a data value o