Connection.rollbackTransaction seem to be not rolling back the transaction

Hi all,

In my server-side JS code. I have code similar to

myConn.beginTransaction

myConn.execute(str)

myConn.rollbackTransaction

But on verification 'str' seem to be still there in the database (SQL Server

7.0)

Checked up everything. Any inputs more than welcome.

regards,

-Sanjeev

[356 byte] By [] at [2007-11-25 7:18:40]
# 1

You could check whether autoCommit is turned on for your connection; if it

is, then that may be why.

"Sanjeev" <saggarwal@etreby.com> wrote in message

news:9ioaqa$jjl1@secnews.netscape.com...

> Hi all,

>In my server-side JS code. I have code similar to

>myConn.beginTransaction

>myConn.execute(str)

>myConn.rollbackTransaction

>

> But on verification 'str' seem to be still there in the database (SQL

Server

> 7.0)

>Checked up everything. Any inputs more than welcome.

>regards,

> -Sanjeev

>

>

at 2007-6-29 17:55:38 > top of Java-index,Web & Directory Servers,Web Servers...
# 2

"Sanjeev" <saggarwal@etreby.com> wrote in message

news:9ioaqa$jjl1@secnews.netscape.com...

> Hi all,

>In my server-side JS code. I have code similar to

>myConn.beginTransaction

>myConn.execute(str)

>myConn.rollbackTransaction

>

> But on verification 'str' seem to be still there in the database (SQL

Server

> 7.0)

>Checked up everything. Any inputs more than welcome.

>regards,

> -Sanjeev

>

>

at 2007-6-29 17:55:38 > top of Java-index,Web & Directory Servers,Web Servers...