Re: SEVERE: Can't lookup new HighLowSequence for field id using sequence name SEQ_t_xx_xxx

--001636c5b8ef8556f504685fa30e
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Hi,

The first think I'd try, could be to switch to java 1.5 or higher.

Anyway you should say if the error you get is always when executing the sam=
e
piece of code or it is "aleatory",

Try to isolate the problem and provide more information.

regards

Alessandro

On Thu, Apr 23, 2009 at 2:43 PM, ChupaMe <[email protected]> wrote:

>
> Hello,
>
> does anybody have a clue? Please help.
>
> Thank You!
>
>
>
> ChupaMe wrote:
> >
> > 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 na=
me
> > SEQ_t_xx_xxx
> > org.apache.ojb.broker.TransactionInProgressException: Connection is
> > already in transaction
> >         at
> >
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unknow=
n
> > Source)
> >         at
> > org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Unkno=
wn
> > Source)
> >         =85
> >
> > 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-fi=
eld-id-using-sequence-name-SEQ_t_xx_xxx-tp22558473p23196144.html
> Sent from the Apache DB - ObjectRelationalBridge Users mailing list archi=
ve
> at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>

--001636c5b8ef8556f504685fa30e--