Skip site navigation (1) Skip section navigation (2)

Re: Columns out of range-error

From: "Andreas Percher" <andreas(dot)percher(at)automedia(dot)de>
To: <pg(at)fastcrypt(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>, <tobias(dot)zielke(at)automedia(dot)de>
Subject: Re: Columns out of range-error
Date: 2004-08-20 15:20:16
Message-ID: 000601c486c9$33972b30$1600a8c0@developer (view raw or flat)
Thread:
Lists: pgsql-jdbc
> First of all, do not use begin, use setAutoCommit(false);
Silly question:
Where ?
How ?

I don't get any acces to the postgresDB, only the JDBC-Conection.

> I still need to see the loop that you are inserting the data in?
This is what Woolve73 will send to you, i guess.

Dave
On Fri, 2004-08-20 at 11:05, (AnPe) Andreas Percher wrote:
> I'm a Newbe in using commitment control.
> Toby (Woolve73) is my Colleague.
> So I try to refine his question.
> 
> Step 1
> We've got a Table with 203 columns.
> We wan't to add (insert) up to 150 new rows.
> Each row need 38-52 columns.
> 
> Step 2
> Using pgAdmin anithing is fine.
> Adding "begin" and "roolback" (we don't want to kill our live 
> database)
> - it works.
> Sending the inserts out of our Java-Application without start/roolback
> works too.
> 
> Step 3
> Now back in Java.
> Sending a "begin" it gives us a SQL Error
> "Spaltenindex außerhalb des gültigen Bereichs"
> Which meens
> "The column index is out of range."
> 
> --> postgresql.res.colrange:Spaltenindex außerhalb des gültigen 
> --> Bereichs postgresql.res.colrange:The column index is out of range.
> 
> This error message occur after 13-16 inserts, depending on the column 
> count of each insert. Sending the inserts without the long data field 
> "specialequipment", results in letting the error occur one insert 
> later.
> 
> In case of the Error, round about 600 columns (counted over all 
> inserts) are waiting for its commitment.
> 
> Step 4
> We are confused.
> We need to use commitment control, because if one insert, update or 
> delete fails, or if an error in the data input stream occurs, we have 
> to rollback.
> 
> > Toby,
> > 
> > You will have to give us more information.
> > can you show us the relevant code ?
> > But in general you can't put 650 columns into 200 columns ? How is 
> > that supposed to work ?
> > 
> > Dave
> > On Fri, 2004-08-20 at 10:20, Tobias Zielke wrote:
> > > Hi,
> > > 
> > > We have a Problem with postgresql 7.4.3 and jdbc
> > > ...
> > > Thnx
> > > Woolve73
> > > Toby


Responses

pgsql-jdbc by date

Next:From: mmckenzieDate: 2004-08-20 15:42:05
Subject: Question
Previous:From: Andreas PercherDate: 2004-08-20 15:06:17
Subject: Re: Columns out of range-error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group