[hibernate-dev] weird LockTest regression when running with Oracle

[Scott Marlow]

On Fri, 2010-03-05 at 09:12 -0600, Steve Ebersole wrote:
> odd.  were you able to fix this by cleaning up db?  We do use some 
> triggers as part of other tests; could it maybe be an issue with schema 
> export not able to cleanup those tables?  But even there the error is 
> strange because we do not commit nor rollback as part of the trigger.

Is it okay if I clean up the database?

Looking at the test user in the database, I see the following:

Tables:

"HIBBRTRU"."HT_ANIMAL", "HIBBRTRU"."HT_CHILD",
"HIBBRTRU"."HT_FILTER_HQL_JOINED_CUST",
"HIBBRTRU"."HT_FILTER_HQL_JOINED_EMP",
"HIBBRTRU"."HT_FILTER_HQL_JOINED_PERSON",
"HIBBRTRU"."HT_FILTER_HQL_JOINED_USER", "HIBBRTRU"."HT_FOOS",
"HIBBRTRU"."HT_HUMAN", "HIBBRTRU"."HT_ITEMS", "HIBBRTRU"."HT_JCUSTOMER",
"HIBBRTRU"."HT_JEMPLOYEE", "HIBBRTRU"."HT_JOINER",
"HIBBRTRU"."HT_JPERSON", "HIBBRTRU"."HT_LEAFSUBSUBCLASS",
"HIBBRTRU"."HT_MAMMAL", "HIBBRTRU"."HT_PRODUCT_TABLE",
"HIBBRTRU"."HT_TRUCK", "HIBBRTRU"."HT_VEHICLE", "HIBBRTRU"."POINT"

stored procedures:

"HIBBRTRU"."CREATEENTITYE", "HIBBRTRU"."CREATEENTITYP",
"HIBBRTRU"."DELETEENTITYE", "HIBBRTRU"."UPDATEENTITYE"

stored functions:

"HIBBRTRU"."DELETEENTITYP", "HIBBRTRU"."SQUIRREL_GET_ERROR_OFFSET",
"HIBBRTRU"."UPDATEENTITYP"

Triggers owned by this user:

None


Anyone recognize the stored procedures/functions?


> 
> basically i have no clue; this sounds 'off'.
> 
> On 03/04/2010 08:14 PM, Scott Marlow wrote:
> > I ran org.hibernate.ejb.test.lock.LockTest and get a weird "ORA-04092:
> > cannot COMMIT in a trigger" failure in:
> >
> > testLockOptimistic(org.hibernate.ejb.test.lock.LockTest)
> > testLockWrite(org.hibernate.ejb.test.lock.LockTest)
> > testLockWriteOnUnversioned(org.hibernate.ejb.test.lock.LockTest)
> > testLockPessimisticForceIncrement(org.hibernate.ejb.test.lock.LockTest)
> > testLockOptimisticForceIncrement(org.hibernate.ejb.test.lock.LockTest)
> > testContendedPessimisticReadLockTimeout(org.hibernate.ejb.test.lock.LockTest)
> > testContendedPessimisticWriteLockTimeout(org.hibernate.ejb.test.lock.LockTest)
> > testContendedPessimisticWriteLockNoWait(org.hibernate.ejb.test.lock.LockTest)
> > testQueryTimeout(org.hibernate.ejb.test.lock.LockTest)
> >
> > test failures are here http://pastebin.com/F07aBFvm
> >
> > Did anyone commit changes that could impact the above tests?  I'm also
> > wondering if my oracle test database is hosed somehow (using
> > -Poracle11gRAC).
> >
> > Thanks for any advice.  This is blocking me from fixing HHH-4972.
> >
> > Scott
> >
> > _______________________________________________
> > hibernate-dev mailing list
> > hibernate-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>