Hi! see, also:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg03450.html > I am getting errors when running junit. I have played around with > different usernames in Oracle, different strategies for including jar > files, searching the mailing list for hints on Oracle installs, etc but to > no avail at this point. I have followed the on line docs around install > and configuration to the tee but clearly there must be some manual, > undocumented steps I am missing for an Oracle install. I experienced the same problems! > So I changed all of the various LONG RAW columns in the core tables > in Oracle to RAW(2000). LONG RAW and RAW are both > non-interpreted binary data columns, LONG RAW supports up to 2 Gig's, > and RAW up to 2000. > Now, I don't know what OJB needs a 2GIG column for, > but my tests passed on RAW(2000). I did the "same" and startet bin\build junit-no-compile-no-prepare, but my tests did not pass! Instead I got more errors (80 instead of 77) !!! It seems to me, that OJB can not state, that it works with oracle, at least not out of the box. I tried to analyse the test-logs, but I'm not understanding what is going wrong and I get no exception and stacktrace! But such things are essential to survive! O.k. I tried to use OJB with weblogic even if the testsuite does not succeed. Then at last I got the following error which I can not resolve: [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: Create new connection pool:org.apache.ojb.broker.m [EMAIL PROTECTED] jcd-alias=default default-connection=true dbms=oracle jdbc-level=2.0 driver=oracle.jdbc.driver.OracleDriver protocol=jdbc sub-protocol=oracle eager-release=false ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, maxActive=21, maxWait=5000, removeAbandoned=false, numTes tsPerEvictionRun=10, testWhileIdle=false, minEvictableIdleTimeMillis=600000, testOnReturn=false, logAbandoned=false, rem oveAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, testOnBorrow=true} batchMode=false useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE ignoreAutoCommitExceptions=false [EMAIL PROTECTED] sequenceManagerClass=class org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl Properties={autoNaming=true, globalSequenceId=false, globalSequenceStart=10000, grabSize=20} ] ] [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection o [EMAIL PROTECTED] [org.apache.ojb.odmg.collections.DListImpl] ERROR: Generation of new id failed java.lang.Long java.lang.ClassCastException: java.lang.Long at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement .java:1971) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement .java:2052) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un known Source) at org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement(Unk nown Source) at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(U nknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong (Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unkn own Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(U nknown Source) at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown Source) at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown Source) at java.lang.Class.newInstance0(Native Method) at java.lang.Class.newInstance(Class.java:232) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlSessionBe an.getPass(AccessControlSessionBe an.java:29) at de.osc.ewetel.scopusonline.forms.contract.contractreg.ContractRegEJB_1in87l_ EOImpl.getPass(ContractRegEJB_1in 87l_EOImpl.java:125) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:59) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long java.lang.ClassCastException: java.lang.Long at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement .java:1971) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement .java:2052) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un known Source) at org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement(Unk nown Source) at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(U nknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong (Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unkn own Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(U nknown Source) at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown Source) at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown Source) at java.lang.Class.newInstance0(Native Method) at java.lang.Class.newInstance(Class.java:232) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlSessionBe an.getPass(AccessControlSessionBe an.java:29) at de.osc.ewetel.scopusonline.forms.contract.contractreg.ContractRegEJB_1in87l_ EOImpl.getPass(ContractRegEJB_1in 87l_EOImpl.java:125) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:59) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) rethrown as org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown Source) at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown Source) at java.lang.Class.newInstance0(Native Method) at java.lang.Class.newInstance(Class.java:232) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlSessionBe an.getPass(AccessControlSessionBe an.java:29) at de.osc.ewetel.scopusonline.forms.contract.contractreg.ContractRegEJB_1in87l_ EOImpl.getPass(ContractRegEJB_1in 87l_EOImpl.java:125) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:59) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) rethrown as org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow n Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlSessionBe an.getPass(AccessControlSessionBe an.java:29) at de.osc.ewetel.scopusonline.forms.contract.contractreg.ContractRegEJB_1in87l_ EOImpl.getPass(ContractRegEJB_1in 87l_EOImpl.java:125) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:59) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) [org.apache.ojb.odmg.TransactionImpl] INFO: Abort transaction was called on tx [EMAIL PROTECTED] 2, associated PB was [EMAIL PROTECTED] <22.07.2003 13:57:35 CEST> <Info> <EJB> <EJB Exception during invocation from home: de.osc.ewetel.scopusonline.forms.con [EMAIL PROTECTED] threw exception: java.lang.RuntimeException: org.apache.ojb.brok er.PersistenceBrokerException: java.lang.Long(parameters: userName: admin) java.lang.RuntimeException: org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long(parameters: userName: admin ) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlSessionBe an.getPass(AccessControlSessionBe an.java:47) at de.osc.ewetel.scopusonline.forms.contract.contractreg.ContractRegEJB_1in87l_ EOImpl.getPass(ContractRegEJB_1in 87l_EOImpl.java:125) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:59) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) > java.rmi.RemoteException: EJB Exception: ; nested exception is: java.lang.RuntimeException: org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long(parameters: userNam e: admin) java.lang.RuntimeException: org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long(parameters: userName: admin ) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlSessionBe an.getPass(AccessControlSessionBe an.java:47) at de.osc.ewetel.scopusonline.forms.contract.contractreg.ContractRegEJB_1in87l_ EOImpl.getPass(ContractRegEJB_1in 87l_EOImpl.java:125) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:59) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) <22.07.2003 13:57:35 CEST> <Error> <HTTP> <[WebAppServletContext(4443565,ScopusOnline,/ScopusOnline)] Servlet failed wit h Exception java.lang.RuntimeException: java.rmi.RemoteException: EJB Exception: ; nested exception is: java.lang.RuntimeException: org.apache.ojb.broker.PersistenceBrokerException: java.lang.Long(parameters: userNam e: admin) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlImpl.getP ass(AccessControlImpl.java:64) at de.osc.ewetel.scopusonline.forms.contract.contractreg.AccessControlTestClien t.test(AccessControlTestClient.ja va:30) at jsp_servlet.__testaccesscontrol._jspService(__testaccesscontrol.java:149) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :265) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :304) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java :200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo ntext.java:2546) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java :2260) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) > There are following errors in the testsuites: ** Several: [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED] But why is there a rollback??? What is the underlying error? ** Sometimes [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED] java.lang.Long Looks like ClassCastException, but why and where? ** [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED] Could not init Identity for given object class org.apache.ojb.broker.Article: java.lang.Long Looks like ClassCastException, too, but why and where? ** [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 ORA-00937: not a single-group group function ??? ** [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED] [org.apache.ojb.broker.accesslayer.RsIterator] ERROR: java.lang.Long ** [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED] [org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: E/A-Exception: Socket closed [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: PersistenceBrokerException during the execution of the query: E/A-Exception: Socket closed E/A-Exception: Socket closed [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback was called, do rollback on current connection [EMAIL PROTECTED] [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR: Rollback on the underlying connection failed E/A-Exception: Socket closed ** [org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: E/A-Exception: Socket closed [org.apache.ojb.broker.util.sequence.SequenceManagerHelper] WARN: Cannot lookup max value from table PERSON for column ID, PB was [EMAIL PROTECTED], using jdbc-descriptor [EMAIL PROTECTED] jcd-alias=default default-connection=true dbms=Oracle jdbc-level=1.0 driver=oracle.jdbc.driver.OracleDriver protocol=jdbc sub-protocol=oracle eager-release=false ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, maxActive=21, maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10, testWhileIdle=false, minEvictableIdleTimeMillis=600000, testOnReturn=false, logAbandoned=false, removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, testOnBorrow=true} batchMode=false useAutoCommit=AUTO_COMMIT_IGNORE_STATE ignoreAutoCommitExceptions=false [EMAIL PROTECTED] sequenceManagerClass=class org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl Properties={autoNaming=true, globalSequenceId=false, globalSequenceStart=10000, grabSize=20} ] ] E/A-Exception: Socket closed best regards Thorsten van Ellen _______________________________________ OSC-Information Management AG Dipl.-Inform. Thorsten van Ellen Industriestra�e 11, 26121 Oldenburg Tel.: 04 41/3 50 42-3 34, Fax: -3 80, Zentrale -0 E-Mail: [EMAIL PROTECTED] URL: http://www.osc-im.de --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
