Solves this exception when using an MS SQL db server and the MS Type 4 JDBC
driver
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't
start
manual transaction mode because there are cloned connections.
Serge
--- faq.html Fri Nov 01 12:56:43 2002
+++ faq1.html Fri Nov 01 12:55:58 2002
@@ -262,7 +262,16 @@
<a href="#14">How can I make sendmail route local mail (or all mail) through James on
the same machine?</a>
</li>
-
+
+<li>
+
+<a href="#15">I am using Microsoft's SQL Type 4 JDBC Driver, why do I get the
+following exception?
+<br>
+java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
+JDBC]Can't start manual transaction mode because there are cloned connections.</a>
+
+</li>
+
</ul>
</p>
@@ -838,7 +847,35 @@
</td>
</tr>
</table>
-
+
+<a name="15"></a>
+<table width="100%" cellpadding="2" cellspacing="0" border="0">
+<tr>
+<td bgcolor="#828DA6"><font face="arial,helvetica.sanserif" color="#ffffff"><a
+name="MSSQL"><strong>I am using Microsoft's SQL Type 4 JDBC Driver, why do I get the
+following exception?
+<br>
+java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
+JDBC]Can't start manual transaction mode because there are cloned
+connections.</strong></a></font></td>
+</tr>
+<tr>
+<td>
+
+<blockquote>
+This seems to be a problem with the Microsoft Type 4 JDBC Driver and concurrent
+statements/transactions/resultsets on the same database conntection.
+<br>
+To solve this you need to add <b>;SelectMethod=cursor</b> to the end of your dburl
+string. Your dburl string would then look something like this
+<p>
+<dburl>jdbc:microsoft:sqlserver://dbserver.host.name:1433;SelectMethod=cursor</dburl>
+</p>
+<p>
+NOTE. some people have complained about performance when using this option, the
+alternative is a 3rd party JDBC driver but these are often not free.
+</p>
+Serge Sozonoff
+</blockquote>
+
+</td>
+</tr>
+</table>
+
</blockquote>
</td>
</tr>
--
To unsubscribe, e-mail: <mailto:james-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:james-user-help@;jakarta.apache.org>
