oracle and unit tests

[Durham David Contr 805 CSS/SCBE <Da...@scott.af.mil>]

I know this question has been asked before, but -- Has anyone
successfully ran the unit tests against an oracle db?

I get at least the following errors:

1)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the query (for a org.apache.ojb.broker.Person):
ORA-00937: not a single-group group function

2)
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: Io
exception: Socket closed
[org.apache.ojb.broker.util.sequence.SequenceManagerHelper] WARN: Cannot
lookup max value from table SM_TAB_MAX_BB for column SM_ID, PB was
org.apache.ojb.broker.core.PoolablePersistenceBroker@1a1644b, using
jdbc-descriptor
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@d3d6f[

3)
[org.apache.ojb.broker.platforms.PlatformDefaultImpl] ERROR: Set
autoCommit(false) failed

4)
[org.apache.ojb.odmg.collections.DListImpl] ERROR: Generation of new id
failed
Set autoCommit(false) failed: Io exception: Socket closed
------------- ---------------- ---------------
------------- Standard Error -----------------
java.lang.ClassCastException
	at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedState
ment.java:1971)
	at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedState
ment.java:2052)
	at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen
t(PlatformDefaultImpl.java:230)
	at
org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement
(PlatformOracleImpl.java:130)
	at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(StatementM
anager.java:493)
	at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcces
sImpl.java:198)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBr
okerImpl.java:1919)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroker
Impl.java:1834)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroker
Impl.java:650)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingP
ersistenceBroker.java:155)
	at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequen
ce(SequenceManagerHighLowImpl.java:300)
	at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUnique
Long(SequenceManagerHighLowImpl.java:201)
	at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(
AbstractSequenceManager.java:252)
	at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVal
ue(AbstractSequenceManager.java:167)
	at
org.apache.ojb.odmg.collections.DListImpl.generateNewId(DListImpl.java:2
94)
	at
org.apache.ojb.odmg.collections.DListImpl.<init>(DListImpl.java:117)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
	at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
	at java.lang.Class.newInstance0(Class.java:306)
	at java.lang.Class.newInstance(Class.java:259)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1303)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1460)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Pe
rsistenceBrokerImpl.java:1428)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu
ery(DelegatingPersistenceBroker.java:292)
	at
org.apache.ojb.odmg.oql.OQLQueryImpl.execute(OQLQueryImpl.java:285)
	at
org.apache.ojb.odmg.OdmgExamples.testOQLQuery(OdmgExamples.java:172)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	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 junit.framework.TestSuite.runTest(TestSuite.java:208)
	at junit.framework.TestSuite.run(TestSuite.java:203)
	at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTe
stRunner.java:325)
	at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitT
estRunner.java:524)


Maybe I should try a new SequenceManager?

Thanks,

Dave


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org