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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
