Re: Can't insert more than 80 registers!?

Thanks very much for the reply.
I found the problem. I'm using a plugin in Eclipse (JFaceDBC) for my DB viewing
and looks like its limited to a view of 80 registers per table (wierd).
I did a select count(*) via psql and there they where... the 90 registers.

Thanks Oliver.

> Carlos Barroso wrote:
>
> > 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 just tested this schema & code against 7.4.2 and pg74.213.jdbc3.jar.
> It works as expected, inserting 90 rows. The only difference in schema
> was that I dropped the foreign key constraints as you didn't provide DDL
> or data for the referenced tables.
>
> Here's what I did:
>
> > oliver(at)flood:~$ sandbox-7.4.2/bin/psql -p 5742 test
> > [... startup banner ...]
> > test=> CREATE TABLE PLANO_ENSAIO (
> > test(> id INT8 NOT NULL
> > test(> , ensaio_fk INT8 NOT NULL
> > test(> , op_fk INT8 NOT NULL
> > test(> , data_hora TIMESTAMP(10) NOT NULL
> > test(> , estado CHAR(1) NOT NULL
> > test(> , user_id CHAR(10) NOT NULL
> > test(> , dt_hr TIMESTAMP(10) NOT NULL
> > test(> , PRIMARY KEY (id) );
> > WARNING: TIMESTAMP(10) precision reduced to maximum allowed, 6
> > WARNING: TIMESTAMP(10) precision reduced to maximum allowed, 6
> > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"plano_ensaio_pkey" for table "plano_ensaio"
> > CREATE TABLE
> > test=> \q
> >
> > oliver(at)flood:~$ cat Test.java
> > import java.sql.*;
> >
> > public class Test {
> > public static void main(String[] args) throws Exception {
> > Class.forName("org.postgresql.Driver");
> > Connection conn =
> >
DriverManager.getConnection("jdbc:postgresql://localhost:5742/test",
> > "oliver", "oliver");
> >
> > 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();
> > }
> > }
> >
> > oliver(at)flood:~$ javac -classpath pg74.213.jdbc3.jar Test.java
> > oliver(at)flood:~$ java -classpath pg74.213.jdbc3.jar:. Test
> > oliver(at)flood:~$ sandbox-7.4.2/bin/psql -p 5742 test
> > [... startup banner ...]
> > test=> select count(*) from plano_ensaio;
> > count
> > -------
> > 90
> > (1 row)
> >
>
> Can you provide something similar showing exactly what you're doing?
> Obviously there's something different between our setups.
>
> I'd also check the server logs for any errors; perhaps something is
> masking a failure to insert.
>
> Finally, if you do the same inserts by hand via psql, what happens?
>
> -O
--
Adira j ao Net Dialup Light. Acesso profissional gratuito.
NovisNet, a Internet de quem trabalha. http://www.novisnet.pt