stored procedure unittests failing on oracle

From: Craig Miskell (cmiskel..lbatross.co.nz)
Date: Sun Mar 30 2003 - 15:23:15 EST

Next message: Andrus Adamchik: "Re: Regression failures"

Previous message: Andrus Adamchik: "Re: Unit Test Reports"
Next in thread: Andrus Adamchik: "Re: stored procedure unittests failing on oracle"
Reply: Andrus Adamchik: "Re: stored procedure unittests failing on oracle"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,
Just noticed that my nightly unit tests have been failing for at least
the last 3 days when run against Oracle 8.0.3 and 8i. Details below...
I'm off to try and figure it out, unless someone else knows what it is.

Craig

     [java] [junit] INFO DatabaseSetupDelegate: CREATE OR REPLACE
PACKAGE cayenne_types
     [java] [junit] AS
     [java] [junit] TYPE ref_cursor IS REF CURSOR;
     [java] [junit] END;

     [java] [junit] INFO DatabaseSetupDelegate: CREATE OR REPLACE
FUNCTION cayenne_tst_select_proc (a_name IN VARCHAR2, painting_price IN
NUMBER)
     [java] [junit] RETURN cayenne_types.ref_cursor
     [java] [junit] AS
     [java] [junit] artists cayenne_types.ref_cursor;
     [java] [junit] BEGIN
     [java] [junit] SET TRANSACTION READ WRITE;

     [java] BUILD FAILED
     [java] java.lang.ExceptionInInitializerError
     [java] at java.lang.Class.forName0(Native Method)
     [java] [junit] UPDATE PAINTING SET ESTIMATED_PRICE =
ESTIMATED_PRICE * 2
     [java] [junit] WHERE ESTIMATED_PRICE < painting_price;
     [java] [junit] COMMIT;
     [java] [junit]
     [java] at java.lang.Class.forName(Class.java:140)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUnitTestRunner.java:237)
     [java] [junit] OPEN artists FOR
     [java] [junit] SELECT DISTINCT A.ARTIST_ID,
A.DATE_OF_BIRTH, A.ARTIST_NAME
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUnitTestRunner.java:219)
     [java] [junit] FROM ARTIST A, PAINTING P
     [java] [junit] WHERE A.ARTIST_ID = P.ARTIST_ID AND
     [java] [junit] A.ARTIST_NAME like a_name || '%';

     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:778)
     [java] [junit] RETURN artists;
     [java] [junit] END;

     [java] [junit] ERROR CayenneTestResources: Error creating test
database.
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:551)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:527)
     [java] [junit] java.sql.SQLException: ORA-00955: name is
already used by an existing object

     [java] at org.apache.tools.ant.Task.perform(Task.java:319)
     [java] at org.apache.tools.ant.Target.execute(Target.java:309)
     [java] [junit] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
     [java] [junit] at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
     [java] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
     [java] at
org.apache.tools.ant.Project.executeTarget(Project.java:1306)
     [java] [junit] at
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
     [java] [junit] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
     [java] at
org.apache.tools.ant.Project.executeTargets(Project.java:1250)
     [java] at org.apache.tools.ant.Main.runBuild(Main.java:610)
     [java] at org.apache.tools.ant.Main.start(Main.java:196)
     [java] [junit] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
     [java] at org.apache.tools.ant.Main.main(Main.java:235)
     [java] Caused by: org.objectstyle.cayenne.CayenneRuntimeException:
Error creating test database.
     [java] [junit] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
     [java] [junit] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.createTestDatabase(CayenneTestResources.java:294)
     [java] [junit] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.<init>(CayenneTestResources.java:154)
     [java] [junit] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.startDbConnections(CayenneTestResources.java:133)
     [java] [junit] at
org.objectstyle.cayenne.unittest.DatabaseSetupDelegate.executeDDL(DatabaseSetupDelegate.java:158)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.init(CayenneTestResources.java:110)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestCase.<clinit>(CayenneTestCase.java:78)
     [java] ... 15 more
     [java] [junit] at
org.objectstyle.cayenne.unittest.DatabaseSetupDelegate.executeDDL(DatabaseSetupDelegate.java:170)
     [java] [junit] at
org.objectstyle.cayenne.unittest.OracleDelegate.createdTables(OracleDelegate.java:105)
     [java] Caused by: java.sql.SQLException: ORA-00955: name is already
used by an existing object

     [java] [junit] at
org.objectstyle.cayenne.unittest.CayenneTestDatabaseSetup.setupTestTables(CayenneTestDatabaseSetup.java:196)
     [java] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
     [java] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
     [java] [junit] at
org.objectstyle.cayenne.unittest.CayenneTestResources.createTestDatabase(CayenneTestResources.java:291)
     [java] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
     [java] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
     [java] [junit] at
org.objectstyle.cayenne.unittest.CayenneTestResources.<init>(CayenneTestResources.java:154)
     [java] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
     [java] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
     [java] [junit] at
org.objectstyle.cayenne.unittest.CayenneTestResources.startDbConnections(CayenneTestResources.java:133)
     [java] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
     [java] [junit] at
org.objectstyle.cayenne.unittest.CayenneTestResources.init(CayenneTestResources.java:110)
     [java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
     [java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
     [java] [junit] at
org.objectstyle.cayenne.unittest.CayenneTestCase.<clinit>(CayenneTestCase.java:78)
     [java] [junit] at java.lang.Class.forName0(Native
Method)
     [java] at
org.objectstyle.cayenne.unittest.DatabaseSetupDelegate.executeDDL(DatabaseSetupDelegate.java:158)
     [java] [junit] at
java.lang.Class.forName(Class.java:140)
     [java] [junit] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUnitTestRunner.java:237)
     [java] at
org.objectstyle.cayenne.unittest.DatabaseSetupDelegate.executeDDL(DatabaseSetupDelegate.java:170)
     [java] at
org.objectstyle.cayenne.unittest.OracleDelegate.createdTables(OracleDelegate.java:105)
     [java] [junit] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUnitTestRunner.java:219)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestDatabaseSetup.setupTestTables(CayenneTestDatabaseSetup.java:196)
     [java] [junit] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:778)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.createTestDatabase(CayenneTestResources.java:291)
     [java] ... 19 more
     [java] Total time: 18 seconds
     [java] [junit] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:551)
     [java] java.lang.ExceptionInInitializerError
     [java] at java.lang.Class.forName0(Native Method)
     [java] at java.lang.Class.forName(Class.java:140)
     [java] [junit] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:527)
     [java] [junit] at
org.apache.tools.ant.Task.perform(Task.java:319)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUnitTestRunner.java:237)
     [java] [junit] at
org.apache.tools.ant.Target.execute(Target.java:309)
     [java] [junit] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUnitTestRunner.java:219)
     [java] [junit] at
org.apache.tools.ant.Project.executeTarget(Project.java:1306)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:778)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:551)
     [java] [junit] at
org.apache.tools.ant.Project.executeTargets(Project.java:1250)
     [java] [junit] at
org.apache.tools.ant.Main.runBuild(Main.java:610)
     [java] at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:527)
     [java] at org.apache.tools.ant.Task.perform(Task.java:319)
     [java] [junit] at
org.apache.tools.ant.Main.start(Main.java:196)
     [java] [junit] at
org.apache.tools.ant.Main.main(Main.java:235)
     [java] at org.apache.tools.ant.Target.execute(Target.java:309)
     [java] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
     [java] at
org.apache.tools.ant.Project.executeTarget(Project.java:1306)
     [java] at
org.apache.tools.ant.Project.executeTargets(Project.java:1250)
     [java] at org.apache.tools.ant.Main.runBuild(Main.java:610)
     [java] at org.apache.tools.ant.Main.start(Main.java:196)
     [java] at org.apache.tools.ant.Main.main(Main.java:235)
     [java] Caused by: org.objectstyle.cayenne.CayenneRuntimeException:
Error creating test database.
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.createTestDatabase(CayenneTestResources.java:294)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.<init>(CayenneTestResources.java:154)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.startDbConnections(CayenneTestResources.java:133)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.init(CayenneTestResources.java:110)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestCase.<clinit>(CayenneTestCase.java:78)
     [java] ... 15 more
     [java] Caused by: java.sql.SQLException: ORA-00955: name is already
used by an existing object
     [java] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
     [java] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
     [java] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
     [java] at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
     [java] at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
     [java] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
     [java] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
     [java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
     [java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
     [java] at
org.objectstyle.cayenne.unittest.DatabaseSetupDelegate.executeDDL(DatabaseSetupDelegate.java:158)
     [java] at
org.objectstyle.cayenne.unittest.DatabaseSetupDelegate.executeDDL(DatabaseSetupDelegate.java:170)
     [java] at
org.objectstyle.cayenne.unittest.OracleDelegate.createdTables(OracleDelegate.java:105)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestDatabaseSetup.setupTestTables(CayenneTestDatabaseSetup.java:196)
     [java] at
org.objectstyle.cayenne.unittest.CayenneTestResources.createTestDatabase(CayenneTestResources.java:291)
     [java] ... 19 more

Next message: Andrus Adamchik: "Re: Regression failures"
Previous message: Andrus Adamchik: "Re: Unit Test Reports"
Next in thread: Andrus Adamchik: "Re: stored procedure unittests failing on oracle"
Reply: Andrus Adamchik: "Re: stored procedure unittests failing on oracle"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Sun Mar 30 2003 - 15:24:14 EST