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();
            }

        } catch (SQLException ex) {
            Logger lgr = Logger.getLogger(PreparedStatement.class.getName());
            lgr.log(Level.SEVERE, ex.getMessage(), ex);
        }
    }
}

And here the exceptions

SEVERE: ERROR: relation "test2" does not exist
  Position: 13
org.postgresql.util.PSQLException: ERROR: relation "test2" does not exist
  Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)
    at test.Test.main(Test.java:30)

You have to create the table test2 before inserting data.

Daniel Rikowski
– Daniel Rikowski

2012-10-12 20:09:12 +00:00
Commented Oct 12, 2012 at 20:09 — Daniel Rikowski
– Daniel Rikowski, Commented Oct 12, 2012 at 20:09

score 4 · Accepted Answer · 2012-10-12 21:17:21Z

4

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;

edited Oct 12, 2012 at 21:17

answered Oct 12, 2012 at 20:20

user330315

Sign up to request clarification or add additional context in comments.

3 Comments

Thanassis Over a year ago

Thanks a lot! Do you know how to fix this without to remake all the tables again?

Thanassis Over a year ago

Also I did all the tables with pgadmin. I didn't put any quotes

user330315 Over a year ago

@thanassis: you definitely used quotes somewhere, otherwise the table would not have been created that way. See my edit on how to rename them.

divanov · Accepted Answer · 2012-10-12 20:10:21Z

1

Table test2 doesn't exist. Try to login to PostgreSQL and check this table.

You can list all existing tables in the database with command line utility

psql -d postgres
\dt

answered Oct 12, 2012 at 20:10

divanov

6,3453 gold badges35 silver badges53 bronze badges

Comments

Jijo Mathew · Accepted Answer · 2017-08-29 18:49:21Z

0

Check for the schema in which you create the table test2. If it is one of the schemas not in the search path, then you have two options:-

Add the schema to your search_path(comma separated list in the file postgres.conf)
Refer to the table by prepending schema name and dot to the table name. For example if the concerned table test2 is in my_schema, then your query should be
insert into my_schema.test2(ID) values(?).

answered Aug 29, 2017 at 18:49

Jijo Mathew

3522 silver badges15 bronze badges

Collectives™ on Stack Overflow

Postgres with Java I can't insert data

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related