Hi,

we have a Problem with Tomcat/MySQL which causes our webapplication to stop
working.
After a restart of Tomcat and MySQL it works again. But we have to do this a
few times a day.

First some Info about the Server and versions:
- SUSE LINUX Enterprise Server 9 (i586) Patchlevel 4
- jakarta-tomcat-5.0.19-29.18
- mysql-shared-4.0.18-32.37
- java2-jre-1.4.2-129.48
- java2-1.4.2-129.48


Often the follow error occurs the application is blocked:

Mar 12, 2009 9:25:19 AM org.apache.ojb.broker.util.logging.CommonsLoggerImpl
error
SEVERE: Can't lookup new HighLowSequence for field id using sequence name
SEQ_t_xx_xxx
org.apache.ojb.broker.TransactionInProgressException: Connection is already
in transaction
        at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unknown
Source)
        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Unknown
Source)
        …

This error is always in relation with the following warnings:

12 Mar 09:20:31  22794068 [http8080-Processor16] WARN 
ch.XXX.XXX.dh.PersistenceSession  -
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.accesslayer.RsIterator$ResourceClosedException:
Resources no longer reachable, RsIterator will be automatic cleaned up on
PB.close/.commitTransaction/.abortTransaction
12 Mar 09:25:19  23081606 [http8080-Processor16] INFO 
ch.XXX.XXX.dh.PersistenceSession  - Transaktion abgebrochen
12 Mar 09:25:19  23081606 [http8080-Processor16] WARN 
ch.XXX.XXX.dh.PersistenceSession  -
org.apache.ojb.broker.PersistenceBrokerException: Error while try to assign
identity value
12 Mar 09:25:19  23081606 [http8080-Processor16] WARN 
ch.XXX.XXX.servlets.BestellungSaveServlet  - Error while try to assign
identity value

Does anybody have a hint?

Thank you
-- 
View this message in context: 
http://www.nabble.com/SEVERE%3A-Can%27t-lookup-new-HighLowSequence-for-field-id-using-sequence-name-SEQ_t_xx_xxx-tp22558473p22558473.html
Sent from the Apache DB - ObjectRelationalBridge Users mailing list archive at 
Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscr...@db.apache.org
For additional commands, e-mail: ojb-user-h...@db.apache.org

Reply via email to