db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <ma...@Remulak.Net>
Subject Re: setNull on prepared statement not working?
Date Tue, 08 Feb 2005 02:58:12 GMT
>From a quick look at what you have posted, your setNull should look like following
insertPreparedStatement.setNull(5,Types.TIMESTAMP).

If you look at java.sql.Types, you will see that Types.NULL is int 0 under the covers
and the error you are getting is because Derby is trying to extract TIMESTAMP value
from 0.

Mamta

Jeremiah Jahn wrote:

> Am I on crack or shouldn't this work?
>
>         insertPreparedStatement.setNull(5,Types.NULL); where column is a
> timestamp column.
>
> This is with the latest official release(10.0.2.1). running on java 5
> and linux.
>
> SQL Exception: An attempt was made to get a data value of type 'TIMESTAMP' from a data
value of type '0'.
>         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
>         at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
>         at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(ConnectionChild.java)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(EmbedPreparedStatement.java)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setNull(EmbedPreparedStatement.java)
>         at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.prepareEventTable(DatabaseTestHelper.java:383)
>         at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.prepareCaseEvidenceTable(DatabaseTestHelper.java:500)
>         at com.goodinassociates.evidencetracking.main.MainControllerTest.testMain(MainControllerTest.java:40)
>         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 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 junit.framework.TestSuite.runTest(TestSuite.java:208)
>         at junit.framework.TestSuite.run(TestSuite.java:203)
>         at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421)
>         at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
>         at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
>
> Be different: conform.
>
>   ------------------------------------------------------------------------------------------------------------------------
>                        Name: signature.asc
>    signature.asc       Type: application/pgp-signature
>                 Description: This is a digitally signed message part


Mime
View raw message