Problem with SP3 JDBC Driver for SQL Server

Hi,
I noticed an interesting behaviour. When the autoCommit is turned off, I am not able to use the same connection handle to create multiple Statement/PreparedStatement handles.It goes into Manual Transaction Mode and says cannot clone connections.
Is this a bug? Can someone give some pointers here.
thanks
Shreyas
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
You need to add a property to the code that's making your connection:
selectMethod=cursor
Joe Weinstein at BEA
shreyask@.gmail.com wrote:
> Hi,
> I noticed an interesting behaviour. When the autoCommit is turned off, I am not able to use the same connection handle to create multiple Statement/PreparedStatement handles.It goes into Manual Transaction Mode and says cannot clone connections.
> Is this a bug? Can someone give some pointers here.
> thanks
> Shreyas
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||You need to add a property to the code that's making your connection:
selectMethod=cursor
Joe Weinstein at BEA
shreyask@.gmail.com wrote:
> Hi,
> I noticed an interesting behaviour. When the autoCommit is turned off, I am not able to use the same connection handle to create multiple Statement/PreparedStatement handles.It goes into Manual Transaction Mode and says cannot clone connections.
> Is this a bug? Can someone give some pointers here.
> thanks
> Shreyas
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Shreyas Kaushik (shreyask@.gmail.com) wrote in message news:<eMtbpzUxEHA.2564@.TK2MSFTNGP12.phx.gbl>...
> Hi,
> I noticed an interesting behaviour. When the autoCommit is turned off, I am not able to use the same connection handle to create multiple Statement/PreparedStatement handles.It goes into Manual Transaction Mode and says cannot clone connections.
> Is this a bug? Can someone give some pointers here.
> thanks
> Shreyas
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
This is one of the number of unfortunate consequences of the fact that
the driver silently creates >1 connection to the database when you
create > 1 statement. This is an example of what I was referring to in
my post in this group on 10/27 comparing the free MS driver to
comercial drivers.
So, well, yes its free but you have to deal with issues like this
one.. I guess you get what you pay for..