From: | Carlos Barroso <miguel(dot)barroso(at)mail(dot)pt> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Can't insert more than 80 registers!? |
Date: | 2004-05-11 10:35:21 |
Message-ID: | 20040511103520.1ADC6D1B1EE@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi! My first post.
I have a problem that's getting crazy. I'm going to discriminate what I used to
get a better understanding.
Tools used:
-----------
Postgres 7.4.2
JDBC
Drivers tested (all downloaded from Postgres site):
---------------------------------------------------
pg74.1jdbc2.jar
pg74.213.jdbc2.jar
pg74.213.jdbc3.jar
Table (DDL):
------------
CREATE TABLE PLANO_ENSAIO (
id INT8 NOT NULL
, ensaio_fk INT8 NOT NULL
, op_fk INT8 NOT NULL
, data_hora TIMESTAMP(10) NOT NULL
, estado CHAR(1) NOT NULL
, user_id CHAR(10) NOT NULL
, dt_hr TIMESTAMP(10) NOT NULL
, PRIMARY KEY (id)
, CONSTRAINT plano_ensaio_fk FOREIGN KEY (ensaio_fk) REFERENCES ENSAIO
(id)
, CONSTRAINT plano_ensaio_op_fk FOREIGN KEY (op_fk) REFERENCES OP (id)
);
NOTE:
I compiled Postgres server without any tweaking.
Here's the testing code:
Class.forName("org.postgresql.Driver");
Connection conn =
DriverManager.getConnection("jdbc:postgresql://localhost:6543/dbdev",
"developer", "xpto");
Statement st = null;
for(int i = 1; i <= 90; i++) {
st = conn.createStatement();
st.executeUpdate("INSERT INTO
plano_ensaio(id,ensaio_fk,op_fk,data_hora,estado,user_id,dt_hr) VALUES (" + i +
",1,1,'2004-04-04 10:11:11','A','mike','2004-05-05 05:55:55')");
}
st.close();
conn.close();
Results:
The code above doesn't give any error. The BIG problem is that it's only
inserting 80 and NOT 90 registers!?
I've tried everything I know and I can't get it working.
I thought it could be because of some WAL configuration, so I increased the
"wal_buffers" parameter, but got no success.
Can someone please help me? Don't know what to do.
--
Adira j ao Net Dialup Light. Acesso profissional gratuito.
NovisNet, a Internet de quem trabalha. http://www.novisnet.pt
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2004-05-11 11:40:44 | Re: Can't insert more than 80 registers!? |
Previous Message | Dave Cramer | 2004-05-10 18:04:35 | Re: problem with transactions |