1. use prepareStatement(String sql, int columnIndexes[]) instead of
prepareStatement(String sql, int autoGeneratedKeys) to make oracle
driver supports generated keys.
2. replace sequence with sequence-identity for native generator in
oracle and postgresql