Using the Transaction's Savepoint and getting Exception

Hi,

my code is as follows:

connection.setAutoCommit(false);

Statement stmt = con.createStatement();

execute Query 1. // 1

Savepoint s1 = conn.setSavepoint(); // 2

execute Query 2. // 3

i m using the JDBC-ODBC bridge driver.

when the statement 2 executed the exception occurs as follows:

java.lang.UnsupportedOperationException

at sun.jdbc.odbc.JdbcOdbcConnection.setSavepoint(Unknown Source)

I m not able to understand why it is coming.

Thanking u.

[531 byte] By [jaimatadi@12a] at [2007-11-27 7:31:58]
# 1
your driver is not support savepoint.
j_shadinataa at 2007-7-12 19:12:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
means JDBC-ODBC Driver not Support the savePoint
jaimatadi@12a at 2007-7-12 19:12:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
I have used another driver i.e jdbc.sqlserver Driver but now another exception generated: Exception in thread "main" java.lang.AbstractMethodError: com.microsoft.jdbc.sqlserver.SQLServerConnection.setSavepoint(Ljava/lang/String;)Ljava/sql/Savepoint;
jaimatadi@12a at 2007-7-12 19:12:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
thats driver also not support.so you are working with microsoft sql server? try this driver: http://sourceforge.net/project/showfiles.php?group_id=33291
j_shadinataa at 2007-7-12 19:12:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...