Thanks Mark!, it works. Any idea why we need to do this? -Sridhar
----- Original Message ----- From: "Martin Fekete" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]>; "sridhar ramalingam" <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 12:08 AM Subject: Re: Can't start a cloned connection while in manual transaction mode. > add to your connection URL SelectMethod=cursor > > feky > > ----- Original Message ----- > From: "sridhar ramalingam" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, January 22, 2002 4:52 AM > Subject: Can't start a cloned connection while in manual transaction mode. > > > Hello, > I'm getting this exception when doing database operation, any ideas?. > > > Thanks a lot. > Sridhar > > > java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a > cloned connection while in ma > nual transaction mode. > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > Source) > at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown > Source) > at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown > Source) > at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown > Source) > at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown > Source) > at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown > Source) > at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown > Source) > at > org.apache.struts.util.GenericConnection.prepareStatement(GenericConnection. > java:509) > at > com.wrox.tourism.db.AttractionDAO.findByPrimaryKey(AttractionDAO.java:163) > at com.wrox.tourism.db.AttractionDAO.create(AttractionDAO.java:49) > at > com.wrox.tourism.business.AttractionBO.registerAttraction(AttractionBO.java: > 42) > at > com.wrox.tourism.actions.RegisterAttractionAction.perform(RegisterAttraction > Action.java:3 > 5) > at > org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja > va:1786) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1145) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.j > ava:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:193) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > 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.ja > va:215) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase > .java:472) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > 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:2366) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > 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 > :163) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > 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: > 1005) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098 > ) > at java.lang.Thread.run(Unknown Source) > com.wrox.tourism.business.AttractionException: error.unexpected > at > com.wrox.tourism.business.AttractionBO.registerAttraction(AttractionBO.java: > 56) > at > com.wrox.tourism.actions.RegisterAttractionAction.perform(RegisterAttraction > Action.java:3 > 5) > at > org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja > va:1786) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1145) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.j > ava:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:193) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > 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.ja > va:215) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase > .java:472) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > 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:2366) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 64) > 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 > :163) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > 66) > 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: > 1005) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098 > ) > at java.lang.Thread.run(Unknown Source) > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
