Thanks for the info Jason -
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.
My bin\build 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: 86.388
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: 15.059
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.116 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.197 sec
I am getting errors when trying to allocate connections, invalid user name
and password errors, could init identitiy for given object errors (all
java.lang.Long errors). Any configuration help you can provide me to get
my Oracle junit tests at an acceptable level would be great. I am
currently evaluating Hibernate as well.
Peter
Jason McKerr <[EMAIL PROTECTED]>
06/17/2003 12:06 PM
Please respond to "OJB Users List"
To: OJB Users List <[EMAIL PROTECTED]>
cc:
Subject: Re: Any Oracle OJB Users in Production?
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]
