Problem with PreparedStatement
От | Esteban Chiner Sanz |
---|---|
Тема | Problem with PreparedStatement |
Дата | |
Msg-id | 380B5347.106559E4@tissat.es обсуждение исходный текст |
Ответы |
Re: [INTERFACES] Problem with PreparedStatement
Re: [INTERFACES] Problem with PreparedStatement |
Список | pgsql-interfaces |
I'm trying to do this: if (counter != -1) /* No ha habido ningún error */ { PreparedStatement pstmt=null; sql="insert into tar_historico values (?,?,?)"; razon="<br>Query: " + sql; try { pstmt = con.prepareStatement(sql); pstmt.setString(1,Integer.toString(counter)); pstmt.setString(2,"1"); pstmt.setTimestamp(3,new Timestamp(new java.util.Date().getTime())); pstmt.executeUpdate(sql); pstmt.close(); con.close(); } But I get this error message in the PostgreSQL log: query: insert into tar_historico values (?,?,?) ERROR: parser: parse error at or near "," What could be the problem? I've tried everything and I haven't found the solution yet. Please, help. Thanks in advance, Esteban Chiner ------------------------------------------------------------Esteban Chiner Sanz mailto (work): echiner@tissat.esTISSATAv.Aragon, 30, 5ª planta Phone: 96 393 9950Valencia (SPAIN)
В списке pgsql-interfaces по дате отправления: