You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Gerardo Arroyo <ge...@flecharoja.com> on 2003/06/19 20:45:50 UTC

TransactionNotInProgressException on a production server!

Hi,

I am having a problem with OJB 0.9.9 running under Sybase 11.9.2.  We
used OJB for a lot of time in a development server, but now on a
production server I am getting at least 4 times per day the next
exception:

I check the online archive mail list and found several interesting
topics, with I am unable to read them, so.. here I am.

Any help will be really appreciated!!!

The repository.xml config is:

<jdbc-connection-descriptor
		jcd-alias="default"
		default-connection="true"
   		platform="SybaseASE"
   		jdbc-level="2.0"
   		driver="com.sybase.jdbc2.jdbc.SybDriver"
   		protocol="jdbc"
   		subprotocol="sybase"
   		dbalias="Tds:10.1.1.137:5000/tms"
   		username="USER"
   		password="PASSWD"
	>
        <sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerInMemoryImpl">
            <attribute attribute-name="grabSize" attribute-value="5"/>
        </sequence-manager>

    </jdbc-connection-descriptor>


Thanks!!
Gerardo



[org.apache.ojb.broker.platforms.PlatformDefaultImpl] ERROR: Set
autoCommit(true) failed
SET CHAINED command not allowed within multi-statement transaction.

com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed
within multi-statement transaction.

	at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2429)
	at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1865)
	at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
	at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
	at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
	at
com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1479)
	at
com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1462)
	at
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:88)
	at com.sybase.jdbc2.tds.Tds.setOption(Tds.java:1012)
	at
com.sybase.jdbc2.jdbc.SybConnection.setAutoCommit(SybConnection.java:577)
	at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.changeAutoCommitState(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localCommit(Unknown Source)
	at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.commitTransaction(Unknown Source)
	at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.commitTransaction(Unknown Source)
	at com.unify.webcenter.broker.MainBroker.update(MainBroker.java:63)
	at
com.unify.webcenter.action.schedulesAction.perform(schedulesAction.java:312)
	at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1720)
	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
	at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
	at java.lang.Thread.run(Thread.java:536)

SEVERE: Fatal Error:
org.apache.ojb.broker.TransactionNotInProgressException
org.apache.ojb.broker.TransactionNotInProgressException
	at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.abortTransaction(Unknown Source)
	at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.abortTransaction(Unknown Source)
	at com.unify.webcenter.broker.MainBroker.update(MainBroker.java:65)
	at
com.unify.webcenter.action.schedulesAction.perform(schedulesAction.java:312)
	at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1720)
	at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
	at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
	at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
	at java.lang.Thread.run(Thread.java:536)



Ing. Gerardo Arroyo Arce
Flecha Roja Technologies

Re: TransactionNotInProgressException on a production server!

Posted by Armin Waibel <ar...@code-au-lait.de>.

Hi Gerardo,

> com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed
> within multi-statement transaction.

Seems something special for Sybase. This I found this in web:

<snip>
> We are developing a web based using Java servlets and Sybase 11.9.2.
> We are using Jconnect downloaded from the Sybase website for databse
> connectivity.
> We frequently get this message on random which kepps disappearing and
> appearing all the time.
> It read like this
> "SET CHAINED command not allowed in multi-statement transaction"
> What am I misssing here    ?

The T-SQL command 'set chained on/off' is used to set chained
mode. It is normally off and shouldn't really be called. If its
on, it makes every statement a transaction until a commit. I'm
not familiar with JConect, but have a look around. There's probably
something in the docs about it. Also search for 'AutoCommit'.
<snip>

regards,
Armin

----- Original Message -----
From: "Gerardo Arroyo" <ge...@flecharoja.com>
To: <oj...@db.apache.org>
Sent: Thursday, June 19, 2003 8:45 PM
Subject: TransactionNotInProgressException on a production server!


> Hi,
>
> I am having a problem with OJB 0.9.9 running under Sybase 11.9.2.  We
> used OJB for a lot of time in a development server, but now on a
> production server I am getting at least 4 times per day the next
> exception:
>
> I check the online archive mail list and found several interesting
> topics, with I am unable to read them, so.. here I am.
>
> Any help will be really appreciated!!!
>
> The repository.xml config is:
>
> <jdbc-connection-descriptor
> jcd-alias="default"
> default-connection="true"
>    platform="SybaseASE"
>    jdbc-level="2.0"
>    driver="com.sybase.jdbc2.jdbc.SybDriver"
>    protocol="jdbc"
>    subprotocol="sybase"
>    dbalias="Tds:10.1.1.137:5000/tms"
>    username="USER"
>    password="PASSWD"
> >
>         <sequence-manager
>
className="org.apache.ojb.broker.util.sequence.SequenceManagerInMemoryIm
pl">
>             <attribute attribute-name="grabSize" attribute-value="5"/>
>         </sequence-manager>
>
>     </jdbc-connection-descriptor>
>
>
> Thanks!!
> Gerardo
>
>
>
> [org.apache.ojb.broker.platforms.PlatformDefaultImpl] ERROR: Set
> autoCommit(true) failed
> SET CHAINED command not allowed within multi-statement transaction.
>
> com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed
> within multi-statement transaction.
>
> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2429)
> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1865)
> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
> at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
> at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
> at
> com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1479)
> at
>
com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1462)
> at
>
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStat
ement.java:88)
> at com.sybase.jdbc2.tds.Tds.setOption(Tds.java:1012)
> at
>
com.sybase.jdbc2.jdbc.SybConnection.setAutoCommit(SybConnection.java:577
)
> at
>
org.apache.ojb.broker.platforms.PlatformDefaultImpl.changeAutoCommitStat
e(Unknown Source)
> at
>
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localCommit(Unkn
own Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.commitTransaction(U
nknown Source)
> at
>
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.commitTransac
tion(Unknown Source)
> at com.unify.webcenter.broker.MainBroker.update(MainBroker.java:63)
> at
>
com.unify.webcenter.action.schedulesAction.perform(schedulesAction.java:
312)
> at
>
org.apache.struts.action.ActionServlet.processActionPerform(ActionServle
t.java:1720)
> at
>
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
> at
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja
va:246)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
3)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468
)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:1012)
> at
>
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
1107)
> at java.lang.Thread.run(Thread.java:536)
>
> SEVERE: Fatal Error:
> org.apache.ojb.broker.TransactionNotInProgressException
> org.apache.ojb.broker.TransactionNotInProgressException
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.abortTransaction(Un
known Source)
> at
>
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.abortTransact
ion(Unknown Source)
> at com.unify.webcenter.broker.MainBroker.update(MainBroker.java:65)
> at
>
com.unify.webcenter.action.schedulesAction.perform(schedulesAction.java:
312)
> at
>
org.apache.struts.action.ActionServlet.processActionPerform(ActionServle
t.java:1720)
> at
>
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
> at
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja
va:246)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
3)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468
)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:1012)
> at
>
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
1107)
> at java.lang.Thread.run(Thread.java:536)
>
>
>
> Ing. Gerardo Arroyo Arce
> Flecha Roja Technologies
>