PostgreSQL and Apache Derby proper column name in JAVA Dao

Asked May 25 '17 at 17:47

Active May 25 '17 at 17:47

Viewed 46 times

I have Dao layer on Java. When I call insert method i want get "id" of inserted row. Im doing like this

connection.prepareStatement(INSERT_SQL, new String[] { "id" }))

All works fine in Postgres. But when i try doing same in Derby(in my integration test) ive got this java.sql.SQLException:Field "id" doesnt exist. When i change to this new String[] { "ID" }) - Derby works fine but PostgreSQL write same bug java.sql.SQLException:Field "id" doesnt exist. I dont want to use this answer coz i have to rewrite many requests: How to create table in lower case name - JavaDB/Derby?

Can some one help me?

asked May 25 '17 at 17:47

Anton Kolosok

1

Try `prepareStatement(INSERT_SQL, Statement.RETURN_GENERATED_KEYS)` – May 25 '17 at 18:56
Have tried. Works fine with Postgre, But Derby: `java.sql.SQLException:Field "id" doesnt exist.` – Anton Kolosok May 26 '17 at 08:12

PostgreSQL and Apache Derby proper column name in JAVA Dao

0 Answers0