I've ran junit against Hypersonic successfully, but when I ran it against PostgreSQL I get some failures.
I'm using PostgreSQL 7.3.3, ojb 1.0.rc3, compiled with jsdk 1.4.01 . Any help would be greatly appreciated.
Here are my steps:
$> createdb ojb psql:ojb# create user oleg; psql:ojb# grant all on database ojb to oleg;
$>bin/build.sh prepare-testdb $>bin/build.sh junit-no-compile-no-prepare
Result:
junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 209, Failures: 9, Errors: 3, Time elapsed: 206.233 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties: file:/home/tina/apps/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
[junit] Tests run: 156, Failures: 4, Errors: 5, Time elapsed: 43.482 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties: file:/home/tina/apps/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.497 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.655 sec
BUILD SUCCESSFUL Total time: 4 minutes 27 seconds
Should I be concerned about the 9 failures with org.apache.ojb.broker.AllTests? How do I see which specific tests failed? Dumping the database with "pg_dump ojb" confirms, there are many tables and entries created in database ojb.
Results from the prepare-testdb step contained many DROP TABLE failures because the table does not exist.
Failed to execute: DROP TABLE Kategorien
[torque-insert-sql] java.sql.SQLException: ERROR: table "kategorien" does not exist
... many other DROP TABLE failures...
[torque-insert-sql] 256 of 342 SQL statements executed successfully
Here are some other configuration data:
#########snippets from postgresql.profile #################
database = postgresql
database.manual.creation = true
# other stuff not included here
dbmsName = PostgreSQL
jdbcLevel = 2.0
urlProtocol = jdbc
urlSubprotocol = postgresql
urlDbalias = ojb
databaseDriver = org.postgresql.Driver
databaseUser = oleg
databasePassword =
databaseHost = localhost
databaseUrl = ${urlProtocol}:${urlSubprotocol}://${databaseHost}:5432/${urlDbalias}
createDatabaseUrl = ${databaseUrl}
buildDatabaseUrl = ${databaseUrl}
sameJavaName=false
#####end of snippets from postgresql.profile##############
#####snippets from OJB.properties############ PersistenceBrokerFactoryClass=org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl PersistenceBrokerClass=org.apache.ojb.broker.core.PersistenceBrokerImpl ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl SqlGeneratorClass=org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl StatementManagerClass=org.apache.ojb.broker.accesslayer.StatementManager JdbcAccessClass=org.apache.ojb.broker.accesslayer.JdbcAccessImpl ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCachePerBrokerImpl LockManagerClass=org.apache.ojb.odmg.locking.LockManagerDefaultImpl LockMapClass=org.apache.ojb.odmg.locking.InMemoryLockMapImpl LockTimeout=60000 ImplicitLocking=true LockAssociations=WRITE LoggerClass=org.apache.ojb.broker.util.logging.PoorMansLoggerImpl LoggerConfigFile=log4j.properties OJBTxManagerClass=org.apache.ojb.odmg.LocalTxManager ##### end snippets from OJB.properties############
Thanks in advance! Tina
