tested with other oracle version,it's a restriction because oracle jdbc driver doesn't works with prepareStatement( sql, autoGeneratedKeys ) but works with prepareStatement( sql, new int[]{ 1 } ) ,it's no matter with oracle server version.