prepared statement not working

From: Jürgen Lüters <jlueters(at)intranet-engineering(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: prepared statement not working
Date: 2009-05-11 17:11:15
Message-ID: 1242061875.30715.5.camel@sid.ie-office.test
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
i try to get the follwong statement executed as an prepared statement.
It delivers 0 results.
The same statement, executed as a non prepared statement does return the
correct data.
Any ideas?

select
a.id,a.partnertyp,a.firmakurz,a.partnerstatus,a.adminstatus,a.eklassen,b.ort,b.plz,b.strasse from partner a, adresse b where a.isdeleted=0 and a.id=b.partnerid and a.partnertyp !=6 and a.eklassen like '%20:%' and b.typeid=1 and b.plz in (select c.plz from plz c,baseregion d where c.bundeslandid=d.id and d.id=4 ) order by a.firmakurz;

Kind Regards

Jürgen Lüters

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Joe Kramer 2009-05-12 07:19:32 Unable to access table named "user"
Previous Message Thomas Finneid 2009-05-11 07:08:06 COPY support: plan and progress