This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a clone Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can Watch "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can New topic
Author

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a clone

sonika singal
Greenhorn

Joined: Dec 26, 2002
Posts: 1
I am using Microsoft SQL Server JDBC driver,
Also I am using connection pooling.
50% of the time its working fine but sometimes it gives the following error:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
or
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a manual transaction because connections are cloned.
I am using multiple statements per connection, but only select statements.
If anybody is aware of this problem,Please cooperate.
Sonika
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
I have seen this error, and I think it had something to do with the connection having been closed.
Rahul Juneja
Ranch Hand

Joined: Aug 03, 2002
Posts: 425
Hi Sonika,
This is a problem which occurs when ure using manual connection commit i mean autocommit(false) and this can be prevented when u write selectMethod='cursor' and this is there because u are using multiple statement objects with a single connection object
thanx & regards,
Rahul Juneja
rahul.juneja@vfusion.net


Rahul Juneja
ThoughtClicks - http://techlabs.thoughtclicks.com
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a clone
 
Similar Threads
Can't start manual transaction mode because there are cloned connections
JDBC drivers for MS SQL 2000
what's "Can't start a cloned connection while in manual transaction mode"
connectionURL to SQL Server 2005
Getting SQL Exception although stored procedure is correct!!!