Vang wrote:
Hello,
I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a
method that does a "insert into" and it throws a "duplicate key
violates unique constraint." I call that method once and then call
another method which does a "select." However, when the select
method gets
Hello,
I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a method
that does a "insert into" and it throws a "duplicate key violates unique
constraint." I call that method once and then call another method which does a
"select." However, when the select method gets called post
Ying Lu wrote:
Greetings,
Through java - JDBC, trying to do "select * from Table" using "lock
table IN SHARE MODE"; Always got this error:
"current transaction is aborted, commands ignored until end of
transaction block"
One of your commands has an error, and the transaction has been aborted
be
Greetings,
Through java - JDBC, trying to do "select * from Table" using "lock
table IN SHARE MODE"; Always got this error:
"current transaction is aborted, commands ignored until end of
transaction block"
Some clues about it?
Thanks a lot!
Emi
---(end of broadcast)-
On 19.04.2005 02:33 Kris Jurka wrote:
Is this a problem with the JDBC interface that I'm using, or is this a
general Postgres problem?
>>>
>
> This is an open todo item for the JDBC driver. It could be done by
> automatically wrapping all statements in savepoints behind the scenes.
>
On Tue, 19 Apr 2005, Thomas Kellerer wrote:
> Joshua D. Drake wrote on 19.04.2005 00:21:
> >> I'm having a bit of trouble with the error message from the subject.
> >> Is there a way to simply go on with my commands if I hit this error?
> >
> > Only if you are using savepoints (nested transact
Joshua D. Drake wrote on 19.04.2005 00:21:
I'm having a bit of trouble with the error message from the subject.
Is there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the JDBC
Thomas Kellerer wrote:
Hello,
I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?
Only if you are using savepoints (nested transactions) otherwise you
must rollback.
Is this a problem with the JDBC interface th
Hello,
I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?
One example would be when I drop a table (and it doesn't exist) I still
want to run the following CREATE TABLE. But due to the error even the
followin
Hi Michael:
Michael Fuhr wrote:
After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of
On Tue, Oct 05, 2004 at 07:54:23AM +0200, ruben wrote:
> After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
> are having intermitent issues with certain online PHP transactions,
> returning this error:
>
> "Warning: pg_exec() query failed: ERROR: current transaction is abort
Hi:
After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block"
Half th
12 matches
Mail list logo