setSavepoint Exception with MsAccess

[ShoKazamatsuri]

My code is

Savepoint savePoint = con.setSavepoint("SAVEPOINT_UPDATE");

when this statement is executed. It's throw an exception :

java.lang.UnsupportedOperationException
sun.jdbc.odbc.JdbcOdbcConnection.setSavepoint(JdbcOdbcConnection.java:1713)

do you know why?

I'm using Ms Access 2000 database, java 1.6.2, and JDBC.ODBC Driver to connect Java with Ms Access?

Thx in advance.

[dlorde]

do you know why?The error message says it all. Did you read the API docs for the setSavePoint(..) method?

Throws:
SQLFeatureNotSupportedException - if the JDBC driver does not support this method.

Looks like they're not throwing exactly the right exception, but UnsupportedOperationException means the same thing (it's supposed to be used with collections).

Today, most software exists, not to solve a problem, but to interface with other software...
I.O. Angell