The following bug has been logged online:
Bug reference: 1308
Logged by: Simon Lesage-Tremblay
Email address: simonlt@thevco.com
PostgreSQL version: 7.4.2
Operating system: Linux
Description: Bug with JDBC driver on duplicate
Details:
I have the version 7.4.2 of Postgres and I use the JDBC driver version
pg74.215.jdbc3 and I run it on JBoss server.
My problem is when I insert a record that have a problem of duplicate key,
my request fall in a frozing mode.
I test my commands with pgadmin and I got a message of duplicate key. So I
supposed that is a problem with the driver.
This is the line that it's supposed to do :
insert INTO data_format_sps(dataformatid, datatype, signed, precision,
scale) VALUES (100,1,false,0,0);
insert INTO data_format_sps(dataformatid, datatype, signed, precision,
scale) VALUES (101,1,true,0,0);
insert INTO data_format_sps(dataformatid, datatype, signed, precision,
scale) VALUES (102,1,true,0,1);
insert INTO data_format_sps(dataformatid, datatype, signed, precision,
scale) VALUES (103,2,false,0,0);
insert INTO data_format_sps(dataformatid, datatype, signed, precision,
scale) VALUES (100,1,false,0,0);
Got this error ERROR: duplicate key violates unique constraint
"data_format_sps_pkey" with pgadmin.
This is a part of the java code that froze :
try{
String req = "INSERT INTO data_format_sps (dataformatid, datatype,
signed, precision, scale) VALUES (?,?,?,?,?)";
PreparedStatement state = con.prepareStatement(req);
state.setInt(1, in_DataFormatID);
state.setInt(2, in_DataType);
state.setBoolean(3, in_Signed);
state.setInt(4, in_Precision);
state.setInt(5, in_Scale);
state.executeUpdate();
}catch(Exception e){
System.out.println("Got an error " + e.getMessage());
}
This is the structure of my table :
CREATE TABLE public.data_format_sps
(
dataformatid int4 NOT NULL,
datatype int4 NOT NULL,
signed bool NOT NULL,
precision int4 NOT NULL,
scale int4 NOT NULL,
CONSTRAINT data_format_sps_pkey PRIMARY KEY (dataformatid)
) WITH OIDS;
Can you help me? I didn't see fix on that in newer version.
Thank you
Simon Lesage-Tremblay