File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a clone
 
Similar Threads
what's "Can't start a cloned connection while in manual transaction mode"
Getting SQL Exception although stored procedure is correct!!!
Can't start manual transaction mode because there are cloned connections
JDBC drivers for MS SQL 2000
connectionURL to SQL Server 2005