I have fixed my application so now all my unit tests pass in HSQL on 099.
However, when I re-run them against Oracle I get

Commit on object level failed for tx
org.apache.ojb.odmg.TransactionImpl@e3849c
java.sql.BatchUpdateException: ORA-00001: unique constraint
(DCORBIN.OUTPUT_SPECIFICATION_PK) violated
      at
oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
      at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3364)
      at
org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.doExecute(Unknown

Source)


Given that the primary key is an OID, and there are NO rows in the table, I
think something is seriously wrong.  (All the UTs passed with 098, btw).

Here's my oracle jdbc descriptor

<jdbc-connection-descriptor
            jcd-alias="default"
            default-connection="true"
        platform="Oracle"
        jdbc-level="1.0"
        driver="oracle.jdbc.driver.OracleDriver"
        protocol="jdbc"
        dbalias="thin:@cmdbdev1:1521:dbdev1"
        subprotocol="oracle"
        username="foo"
        password="foo"
        eager-release="false"
        batch-mode="true"
        useAutoCommit="0"
        ignoreAutoCommitExceptions="false">
                  <connection-pool
                        maxActive="10"
                        maxWait="-1"
                        whenExhaustedAction="0"
                        testOnBorrow="true"
                        testOnReturn="false"
                        timeBetweenEvictionRunsMillis="10000"
                        minEvictableIdleTimeMillis="0"
                        validationQuery="select 1 from dual"/>
       <sequence-manager className
="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
            <attribute attribute-name="grabSize" attribute-value="250"/>
       </sequence-manager>
      </jdbc-connection-descriptor>

Any great ideas?

Thanks.


This message contains information from Equifax Inc. which may be
confidential and privileged.  If you are not an intended recipient, please
refrain from any disclosure, copying, distribution or use of this
information and note that such actions are prohibited.  If you have
received this transmission in error, please notify by e-mail
[EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to