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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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