Primavera (MOSC)

MOSC Banner

Setting autoCommit to false not working with Primavera SDK

edited Jun 28, 2010 7:20PM in Primavera (MOSC) 4 commentsAnswered
 Hi,
I'm using the following JAVA code to insert some resources:

------------------------------------------------------------------------------------------------------------------------------
            .......
            Connection con = null;
            Statement stmt = null;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:P6SDKODBC","admin","admin");
            con.setAutoCommit(false);
            stmt = con.createStatement();
            stmt.executeUpdate("INSERT INTO RSRC (rsrc_id) VALUES (0)");
            .......
            con.commit();
------------------------------------------------------------------------------------------------------------------------------



However, the record is inserted into the database even before the con.commit() is called.

Thanks for your help,
Praveen.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center