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

Re: org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Sriram P <sriramkumar1985(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42
Date: 2010-03-28 00:53:13
Message-ID: 4BAEA879.5060403@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 27/03/2010 4:19 PM, Sriram P wrote:
>
> While im using postgresql with jdbc i m getting following error
>
> org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist
> Position: 42

You're using code written for Oracle. You need to fix your SQL so it'll 
run on PostgreSQL.

If you want help with that, you'll have to post the SQL and some other 
basic information. See:
   http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Craig Ringer

In response to

pgsql-jdbc by date

Next:From: abyssDate: 2010-03-30 09:53:02
Subject: SHARE HAPPINESS!
Previous:From: Nookala Satish KumarDate: 2010-03-27 19:20:14
Subject: Glassfish ignoring "ssl" property in connection pool of PostgreSQL

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