Problems with batch using jdbc on postgresql 7.4.2

From: Manuel García H(dot) <mgarciah(at)ife(dot)org(dot)mx>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Problems with batch using jdbc on postgresql 7.4.2
Date: 2004-04-14 21:40:16
Message-ID: 00b201c42269$13453670$4703000a@demian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, somebody can help me?

I using a batch sentence to update some data in distinct tables, one of that tables have a foreing key, then when I execute the batch using jdbc on postgresql 7.4.2 abort the batch and send me the next message:

ERROR: SPI_connect failed
DEBUG: AbortCurrentTransaction
LOG: statement: rollback; begin;

the exactly sentence is a insert into table (,,,) values (,,,), the message was send just after execute the insert. If I removed the foreing key from the table , the batch worked correctly, but can´t drop the foreing key because I don´t want lost the integrity of data

I hope somebody have a solution.

Thanks and sorry by my grammatical style.

many

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message James Robinson 2004-04-15 03:13:22 JBoss and Statement Pooling endgame.
Previous Message ed 2004-04-14 20:53:04 Postgre not able to connect