java Array insertion into postgres

Question

I am trying to insert a java Array into postgres and get the following error:

Exception in thread "main" org.postgresql.util.PSQLException: No value specified for parameter 2

Code below:

public static void main(String[] args) throws SQLException {
    String sku = "1";
    String[] cross = { "0514", "0414", "0314", "0214", "0114", "1213", "1113", 
        "1013", "0913", "0813", "0713", "0613" };
    String sqlString = "Insert into dbo.Inventory_Metrics skus, cross values(?,?)";
    Connection conn = DriverManager.getConnection(getPostgresConnUrl());
    PreparedStatement ps = conn.prepareStatement(sqlString);
    ps.setObject(1, sku);
    ps.setObject(1, cross, java.sql.Types.VARCHAR, cross.length);

    //This next line throws the error
    int status = ps.executeUpdate();
    ps.close();
    System.out.print(status);
}

public static String getPostgresConnUrl() {
    String database = "mycode";
    String userName = "xxxxxxxx";
    String password = "xxxxxxxx";
    return "jdbc:postgresql://xxx.xxx.xxx.xxx:xxxx/" + database + "?user=" + 
        userName + "&password=" + password; 
}

There is a typo. You are setting first parameter twice.

lifus
– lifus

2014-09-23 19:23:51 +00:00
Commented Sep 23, 2014 at 19:23 — lifus
– lifus, Commented Sep 23, 2014 at 19:23

Patrick J Abare II · Accepted Answer · 2014-09-23 19:22:46Z

4

Look at the second ps.setObject() it's setting the first parameter a second time.

It should read

ps.setObject(1, sku);
ps.setObject(2, cross, java.sql.Types.VARCHAR, cross.length);

answered Sep 23, 2014 at 19:22

Patrick J Abare II

1,1291 gold badge10 silver badges31 bronze badges

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

Comments

Indrajith · Accepted Answer · 2014-09-23 19:30:23Z

2

You haven't specified the second parameter for the PreparedStatement. You are repeating the value for first parameter twice

ps.setObject(1, sku);
ps.setObject(1, cross, java.sql.Types.VARCHAR, cross.length);

should be

ps.setObject(1, sku);
ps.setObject(2, cross, java.sql.Types.VARCHAR, cross.length);

edited Sep 23, 2014 at 19:30

answered Sep 23, 2014 at 19:24

Indrajith

90012 silver badges21 bronze badges

Collectives™ on Stack Overflow

java Array insertion into postgres

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related