we need it because ...
"SelectMethod={cursor | direct}. Determines whether or not Microsoft SQL
Server "server cursors" are used for SQL queries.
Setting SelectMethod to direct allows SQL statements to be executed without
incurring server-side overhead for managing a database cursor over the SQL
statement. Direct mode is the most efficient for executing Select
statements; however, applications are limited to a single active statement
while executing inside a transaction. If multiple result sets are required
from a single query execution, then the application must set SelectMethod to
direct.
Setting SelectMethod to cursor allows multiple active statements within a
transaction.
The default is direct." - Microsoft SQL Server 2000 JDBC Driver Help
but i found sollution for this problem on sun's forums ;]
Feky
----- Original Message -----
From: "sridhar ramalingam" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 22, 2002 6:49 PM
Subject: Re: Can't start a cloned connection while in manual transaction
mode.
> 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]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
