Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

SQL: Unsupported method error executing java code that calls the setSavepoint method.

[DataDirect][OpenEdge JDBC Driver]Unsupported method: Connection.setSavepoint"

Executing a java program similar to the following:
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.Savepoint;

public class TestsetSavepoint {
public static void main(String[] args) {
try {
Class.forName("com.ddtek.jdbc.openedge.OpenEdgeDriver");
Connection conn = DriverManager.getConnection ("jdbc:datadirect:openedge://localhost:23456;databaseName=sports2000","yshanshi","");
conn.setAutoCommit(false);
System.out.println("Driver Version: " + conn.getMetaData().getDriverVersion());
System.out.println("JDBC Version: " + conn.getMetaData().getJDBCMajorVersion());
Statement stmt = conn.createStatement();
conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
int updrows = 0;
Savepoint svpt1 = conn.setSavepoint("svpt1");
updrows = stmt.executeUpdate("UPDATE PUB.customer SET name = 'Oscar Nivia' WHERE custnum = 1");
System.out.println(updrows + " Rx UPDs");
conn.rollback(svpt1);
conn.commit();
}
catch (Exception e) {
System.err.println("Excepcion xxx: " + e);
return;
}
}
}

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1B03 Service Pack
OpenEdge 10.1C
OpenEdge 10.1C01 Service Pack

CAUSE:

The Connection.setSavepoint method is not currently supported by the OpenEdge JDBC driver.

FIX:

Do not use the Connection.setSavepoint method at this time. It is not yet supported by the OpenEdge SQL JDBC driver.