Using Statement.RETURN_GENERATED_KEYS with MS-Access JDBC-ODBC throws exception

Question

import java.sql.* ;
import java.util.* ;
import java.io.* ;

class DataBaseFactory{
    public static Connection getConnection() {
        // ...
    }
}

class Demo{
    public static void main(String []args) throws SQLException {
        Connection con = DataBaseFactory.getConnection() ;

        // This is throwing exception
        // PreparedStatement ps = con.prepareStatement("insert into user values(?,?)", Statement.RETURN_GENERATED_KEYS) ;

        // But this is working fine
        PreparedStatement ps = con.prepareStatement("insert into user values(?,?)") ;
    }
}

Dupe: http://stackoverflow.com/questions/2249600/return-generated-keys-doesnt-work-using-jdbc-odbc/2252196#2252196 — BalusC, Apr 01 '10 at 11:58

score 0 · Answer 1 · answered Jun 20 '09 at 16:49

0

My guess would be that the database driver you're using does not support RETURN_GENERATED_KEYS. What is the database you're trying to connect to?

answered Jun 20 '09 at 16:49

Yuliy

17,381
6
41
47

i am using Microsoft access (Type-1 driver). – mogli Jun 20 '09 at 18:15
That's probably the issue (I see you also posted this on the Sun forums, and received a similar reply there). – Yuliy Jun 21 '09 at 05:48
1

There is a method to find taht out: connection.getMetaData().supportsGetGeneratedKeys() – Tim Büthe Dec 04 '09 at 15:55

score 0 · Answer 2 · edited May 23 '17 at 11:56

0

The JDBC-ODBC Bridge is obsolete and has been removed from Java 8. Fortunately, we can use the free, open-source UCanAccess JDBC driver to work with Access databases from Java, and UCanAccess supports RETURN_GENERATED_KEYS. For more information, see

Manipulating an Access database from Java without ODBC

edited May 23 '17 at 11:56

Community

1
1

answered Mar 09 '15 at 10:53

Gord Thompson

116,920
32
215
418

Using Statement.RETURN_GENERATED_KEYS with MS-Access JDBC-ODBC throws exception

2 Answers2