Postgres with Java I can't insert data

Question

I tried to make an insert to my postgres database with Java. I have default configuration for my local database. I want to put some data in a table and I have some issues. Here is the code : ``` import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; public static void main(String[] args) { Connection con = null; PreparedStatement pst = null; String url = "jdbc:postgresql://localhost/postgres"; String user = "postgres"; String password = "thanassis"; try { con = DriverManager.getConnection(url, user, password); String stm = "INSERT INTO TEST2(ID) VALUES(?)"; pst = con.prepareStatement(stm); pst.setInt(1, 1); pst.executeUpdate(); } catch (SQLException ex) { Logger lgr = Logger.getLogger(PreparedStatement.class.getName()); lgr.log(Level.SEVERE, ex.getMessage(), ex); } finally { try { if (pst != null) { pst.close(); } if (con != null) { con.close(); } } cat…

Accepted Answer

Your table is called `TEST2` not `test2`. Apparently you created it using double quotes, which makes Postgres (and other standard-compliant DBMS) case-sensitive.

Because of that you now have to enclose the table in name in double quotes each time you refer to it.

```
String stm = "INSERT INTO \"TEST2\"(ID) VALUES(?)";
```

Most probably this is not what you intended, so just re-recreate the table without using double quotes around the identifiers:

```
CREATE TABLE test2
(
  ...
)
```

create a different table than:

```
CREATE TABLE "test2"
(
  ...
)
```

If you do not want to re-create the tables, you can rename them:

```
alter table "TEST2" rename to test2;
```

Postgres with Java I can't insert data

Solution

Problem