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]>

Reply via email to