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

Re: Fw: postgresql experts please help

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Andrei Ilitchev <andrei(dot)ilitchev(at)oracle(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, Marina Vatkina <Marina(dot)Vatkina(at)Sun(dot)COM>
Subject: Re: Fw: postgresql experts please help
Date: 2007-10-18 17:34:17
Message-ID: 1192728857.6447.82.camel@archimedes (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Thu, 2007-10-18 at 09:17 -0400, Andrei Ilitchev wrote:
> Dear PostgreSQL jdbc experts,
> 
> I created a table with identity:
> CREATE TABLE MAN (ID  SERIAL, NAME VARCHAR(40), PRIMARY KEY (ID))
> then through jdbc connection inserted a row into the table,
> then attempted to select pk value back through the same jdbc connection 
> using currval - that failed with "not yet defined in this session" 
> exception.
> 
> What's wrong here?

You haven't disabled JDBC autocommit for this connection.  That means
that each statement gets executed in a separate transaction.

Since currval is only valid within the scope of a single transaction,
and you're executing your "select currval" from a separate transaction,
that's why you can't see it.

-- Mark Lewis

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-10-18 17:41:43
Subject: Re: Fw: postgresql experts please help
Previous:From: Michael PaesoldDate: 2007-10-18 16:31:47
Subject: Re: Unable to prepare a statement when the object names contain more than one $ symbol

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