I am running OJB succesfully in production on both Oracle 8i (8.1.7.4.0) and Oracle 9i (9.2.0.2.0). I haven't had any problems except that in Oracle you can't have multiple long (is that the right one?) columns in a single table. I just changed the data types. I'll have to look up what I changed them too.
Can you describe some of the problems you are having? Jason McKerr Northwest Alliance for Computational Science and Engineering On Tue, 2003-06-17 at 04:55, [EMAIL PROTECTED] wrote: > I am currently evaluating the use of OJB for a new web application server > framework for my company and would very much like to use OJB or some other > object - relational framework. I have had many problems and issues > getting the OJB unit test scripts to work against my database however, so > I don't have a great deal of confidence that OJB1.0 can be rolled out > successfully in an enterprise production environment based upon Oracle > 8.1.7. > > Can someone share with me any of their experiences with a working, > production Oracle instance of OJB? Does anyone have a working, functional > OJB installation and configuration in production based upon an Oracle > backend? Can you send your config files that you use/used to successfully > run junit? > > thx in advance > > Peter > > > > > > > > [EMAIL PROTECTED] > 06/13/2003 09:10 AM > Please respond to "OJB Users List" > > > To: "OJB Users List" <[EMAIL PROTECTED]> > cc: "OJB Users List" <[EMAIL PROTECTED]> > Subject: RE: Problem with junit testing on Oracle 8.1.7 > > > Looks like I got around the class not found problem by converting the zip > file into a jar and then putting it in the lib directory. Now my junit > output looks like: > > junit-no-compile-no-prepare: > [junit] Running org.apache.ojb.broker.AllTests > [junit] Tests run: 209, Failures: 12, Errors: 66, Time elapsed: 97.977 > > sec > [junit] TEST org.apache.ojb.broker.AllTests FAILED > [junit] Running org.apache.ojb.odmg.AllTests > [junit] [BOOT] INFO: OJB.properties: > file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties > [junit] Tests run: 156, Failures: 12, Errors: 57, Time elapsed: 16.604 > > sec > [junit] TEST org.apache.ojb.odmg.AllTests FAILED > [junit] Running org.apache.ojb.soda.AllTests > [junit] [BOOT] INFO: OJB.properties: > file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties > [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 5.758 sec > [junit] Running org.apache.ojb.otm.AllTests > [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.859 sec > > > Doesn't give me a warm and fuzzy that this package is ready for prime time > > on Oracle 8i. > > Peter > > > > > > > [EMAIL PROTECTED] > 06/13/2003 07:55 AM > Please respond to "OJB Users List" > > > To: "OJB Users List" <[EMAIL PROTECTED]> > cc: > Subject: RE: Problem with junit testing on Oracle 8.1.7 > > > Thanks for the response Mahler. > > There's the rub, its a zip file actually. I have modified the build.bat > script to incorporate the zip file in the JVM classpath argument as > follows: > > @echo off > REM Please let JAVA_HOME point to your JDK base directory > if "%JAVA_HOME%" == "" set JAVA_HOME=C:\jdk1.3.1_08 > > set JAVA=%JAVA_HOME%\bin\java > set cp= > for %%i in (lib\*.jar) do call bin\cp.bat %%i > set > CP=..\target\classes;..\target\classestest;%JAVA_HOME%\lib\tools.jar;%CP% > > set > local_cp=c:\ora8i\jdbc\lib\classes12.zip;c:\websphere\appserver\lib\j2ee.jar;%CP% > echo JVM classpath is %local_cp%... > > "%JAVA%" -classpath "%local_cp%" -Dant.home=lib org.apache.tools.ant.Main > %1 %2 %3 %4 %5 %6 -buildfile build.xml > > This seemed to work fine when I built the test db (bin\build > prepare-testdb) but does not seem to work when I run the unit tests > (bin\build junit)??? I'm a bit stumped. > > Peter > > > > > > Mahler Thomas <[EMAIL PROTECTED]> > 06/13/2003 03:20 AM > Please respond to "OJB Users List" > > > To: "'OJB Users List'" <[EMAIL PROTECTED]> > cc: > Subject: RE: Problem with junit testing on Oracle 8.1.7 > > > Just place the drivers jar file in the OJB lib directory. > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 13, 2003 12:13 AM > > To: OJB Users List > > Subject: Re: Problem with junit testing on Oracle 8.1.7 > > > > > > It looks like the JVM that is executing the tests can't find > > my driver > > class, even though classes12.zip (the Oracle driver library) > > is on the JVM > > classpath when it executes. Is there a specific > > modification/configuration I need to make to force junit to > > find my driver > > class? > > > > Here is a sample of the errors I am getting in target\test > > > > thx in advance > > > > Peter > > > > > > > > Testsuite: org.apache.ojb.broker.AllTests > > Tests run: 209, Failures: 20, Errors: 150, Time elapsed: 60.805 sec > > ------------- Standard Output --------------- > > [BOOT] INFO: OJB.properties: > > file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: > > Create new connection > > pool:[EMAIL PROTECTED] > > jcd-alias=default > > default-connection=true > > dbms=Oracle > > jdbc-level=1.0 > > driver=oracle.jdbc.driver.OracleDriver > > protocol=jdbc > > sub-protocol=oracle > > db-alias=oci8:@WBSP.WORLD > > user=storefront > > password=***** > > 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_SET_TRUE_AND_TEMPORARY_FALSE > > ignoreAutoCommitExceptions=false > > > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc > > [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.ConnectionFactoryAbstractIm > > pl] ERROR: > > oracle.jdbc.driver.OracleDriver > > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: > > PersistenceBrokerException during the execution of > > materializeObject: Used > > ConnectionManager instance could not obtain a connection: > > Could not borrow > > connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > jcd-alias=default > > default-connection=true > > dbms=Oracle > > jdbc-level=1.0 > > driver=oracle.jdbc.driver.OracleDriver > > protocol=jdbc > > sub-protocol=oracle > > db-alias=oci8:@WBSP.WORLD > > user=storefront > > password=***** > > 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_SET_TRUE_AND_TEMPORARY_FALSE > > ignoreAutoCommitExceptions=false > > > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc > > [EMAIL PROTECTED] > > sequenceManagerClass=class > > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > > Properties={autoNaming=true, globalSequenceId=false, > > globalSequenceStart=10000, grabSize=20} > > ] > > ]: A class was not found: oracle.jdbc.driver.OracleDriver > > Used ConnectionManager instance could not obtain a > > connection: Could not > > borrow connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > jcd-alias=default > > default-connection=true > > dbms=Oracle > > jdbc-level=1.0 > > driver=oracle.jdbc.driver.OracleDriver > > protocol=jdbc > > sub-protocol=oracle > > db-alias=oci8:@WBSP.WORLD > > user=storefront > > password=***** > > 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_SET_TRUE_AND_TEMPORARY_FALSE > > ignoreAutoCommitExceptions=false > > > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc > > [EMAIL PROTECTED] > > sequenceManagerClass=class > > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > > Properties={autoNaming=true, globalSequenceId=false, > > globalSequenceStart=10000, grabSize=20} > > ] > > ]: A class was not found: oracle.jdbc.driver.OracleDriver > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractIm > > pl] ERROR: > > oracle.jdbc.driver.OracleDriver > > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: > > PersistenceBrokerException during the execution of delete: Used > > ConnectionManager instance could not obtain a connection: > > Could not borrow > > connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > jcd-alias=default > > default-connection=true > > dbms=Oracle > > jdbc-level=1.0 > > driver=oracle.jdbc.driver.OracleDriver > > protocol=jdbc > > sub-protocol=oracle > > db-alias=oci8:@WBSP.WORLD > > user=storefront > > password=***** > > 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_SET_TRUE_AND_TEMPORARY_FALSE > > ignoreAutoCommitExceptions=false > > > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc > > [EMAIL PROTECTED] > > sequenceManagerClass=class > > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > > Properties={autoNaming=true, globalSequenceId=false, > > globalSequenceStart=10000, grabSize=20} > > ] > > ]: A class was not found: oracle.jdbc.driver.OracleDriver > > Used ConnectionManager instance could not obtain a > > connection: Could not > > borrow connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > jcd-alias=default > > default-connection=true > > dbms=Oracle > > jdbc-level=1.0 > > driver=oracle.jdbc.driver.OracleDriver > > protocol=jdbc > > sub-protocol=oracle > > db-alias=oci8:@WBSP.WORLD > > user=storefront > > password=***** > > 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_SET_TRUE_AND_TEMPORARY_FALSE > > ignoreAutoCommitExceptions=false > > > > sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc > > [EMAIL PROTECTED] > > sequenceManagerClass=class > > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > > Properties={autoNaming=true, globalSequenceId=false, > > globalSequenceStart=10000, grabSize=20} > > ] > > ]: A class was not found: oracle.jdbc.driver.OracleDriver > > > > > > > > > > > > > > [EMAIL PROTECTED] > > 06/12/2003 05:33 PM > > Please respond to "OJB Users List" > > > > > > To: "OJB Users List" <[EMAIL PROTECTED]> > > cc: > > Subject: Problem with junit testing on Oracle 8.1.7 > > > > > > My output is below but it looks like most of my test cases > > failed. Anyone > > > > have any idea what mught be causing the problem? It looks like I got > > through the DB creation steps just fine. Is there a > > properties or XML > > file I need to change in order to configure junit? > > > > I am running Oracle 8.1.7 on Windows 2000. > > > > Peter > > > > > > > > > > project-sql-classpath: > > [echo] +------------------------------------------+ > > [echo] | | > > [echo] | Generating SQL for OJB Testsuite! | > > [echo] | enJoy! | > > [echo] | | > > [echo] +------------------------------------------+ > > [torque-sql] Using contextProperties file: > > C:\db-ojb-1.0.rc3\build.properties > > [torque-sql] Using classpath > > [torque-sql] Generating to file > > C:\db-ojb-1.0.rc3\target\src\sql\report.ojbtest.sql.generation > > [torque-sql] Resolver: used database.dtd from > > org.apache.torque.engine.database.transform package > > [torque-sql] Resolver: used database.dtd from > > org.apache.torque.engine.database.transform package > > > > project-create-db-classpath: > > > > project-datasql-classpath: > > [echo] +-----------------------------------------------+ > > [echo] | | > > [echo] | Generating SQL from data XML ! | > > [echo] | enJoy! | > > [echo] | | > > [echo] +-----------------------------------------------+ > > [echo] taking build.properties from: build.properties > > [torque-datasql] Using contextProperties file: > > C:\db-ojb-1.0.rc3\build.properties > > [torque-datasql] Using classpath > > [torque-datasql] Generating to file > > C:\db-ojb-1.0.rc3\target\src\sql\ojbtest-data.sql > > [torque-datasql] Resolver: used database.dtd from > > org.apache.torque.engine.database.transform package > > [torque-datasql] Resolver: used > > C:\db-ojb-1.0.rc3\src\schema\ojbtest-data.dtd > > > > project-insert-sql: > > [torque-insert-sql] Our new url -> jdbc:oracle:oci8:@WBSP.WORLD > > [torque-insert-sql] Executing file: > > C:\db-ojb-1.0.rc3\target\src\sql\ojbtest-schema.sql > > [torque-insert-sql] Executing file: > > C:\db-ojb-1.0.rc3\target\src\sql\ojbcore-schema.sql > > [torque-insert-sql] Executing file: > > C:\db-ojb-1.0.rc3\target\src\sql\ojbtest-data.sql > > [torque-insert-sql] 428 of 428 SQL statements executed successfully > > > > junit-no-compile-no-prepare: > > [junit] Running org.apache.ojb.broker.AllTests > > [junit] Tests run: 209, Failures: 20, Errors: 150, Time elapsed: > > 56.709 sec > > [junit] TEST org.apache.ojb.broker.AllTests FAILED > > [junit] Running org.apache.ojb.odmg.AllTests > > [junit] [BOOT] INFO: OJB.properties: > > file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties > > [junit] Tests run: 156, Failures: 13, Errors: 63, Time > > elapsed: 6.589 > > sec > > [junit] TEST org.apache.ojb.odmg.AllTests FAILED > > [junit] Running org.apache.ojb.soda.AllTests > > [junit] [BOOT] INFO: OJB.properties: > > file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties > > [junit] Tests run: 3, Failures: 3, Errors: 0, Time > > elapsed: 4.336 sec > > [junit] TEST org.apache.ojb.soda.AllTests FAILED > > [junit] Running org.apache.ojb.otm.AllTests > > [junit] Tests run: 1, Failures: 0, Errors: 1, Time > > elapsed: 4.456 sec > > [junit] TEST org.apache.ojb.otm.AllTests FAILED > > > > junit-no-compile: > > > > junit: > > > > BUILD SUCCESSFUL > > Total time: 2 minutes 19 seconds > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
