Postgres Pro
Downloads
Home   >   mailing lists

Problems with batch using jdbc on postgresql 7.4.2 - Mailing list pgsql-jdbc

From Manuel García H.
Subject Problems with batch using jdbc on postgresql 7.4.2
Date
Msg-id 00b201c42269$13453670$4703000a@demian
Whole thread Raw
Responses Re: Problems with batch using jdbc on postgresql 7.4.2
Re: Problems with batch using jdbc on postgresql 7.4.2
List pgsql-jdbc
Tree view
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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: patch: fix TimeTest in timezones ahead of GMT
Next
From: James Robinson
Date:
Subject: JBoss and Statement Pooling endgame.