db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremiah Jahn <jerem...@goodinassociates.com>
Subject more setNull issues
Date Tue, 08 Feb 2005 16:09:06 GMT
Thoughts on this one? This follows the examples given in the replies exactly. 

if (currentIteration %2 == 0){
	insertPreparedStatement.setTimestamp(5,new Timestamp(new Date().getTime()));
}
else {
	insertPreparedStatement.setNull(5,Types.TIMESTAMP); <-----problem code
}

java.sql.BatchUpdateException: An attempt was made to get a data value of type 'TIMESTAMP'
from a data value of type 'null'.
	at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(EmbedStatement.java)
	at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.prepareEventTable(DatabaseTestHelper.java:399)
	at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.prepareEvidenceEventTable(DatabaseTestHelper.java:466)
	at com.goodinassociates.evidencetracking.evidence.EvidenceTest.testGetEvidence(EvidenceTest.java:37)
	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)


"What I've done, of course, is total garbage." -- R. Willard, Pure Math
430a

Mime
View raw message