This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
sonika singal
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have seen this error, and I think it had something to do with the connection having been closed.
 
Rahul Juneja
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic