[Pljava-dev] uuid datatypes and prepared statements

From: lucas at mcsnw(dot)com (Lucas Madar)
To:
Subject: [Pljava-dev] uuid datatypes and prepared statements
Date: 2009-06-24 03:00:44
Message-ID: 4A4196DC.5020303@mcsnw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

I'm running into a weird error when using prepared statements within
pl/java:

ERROR: operator does not exist: uuid = text

This is from a very basic query of "SELECT xxx FROM table WHERE uuid=?".
The table's column type is uuid and the java native type is String. It
works fine via plain JDBC and also works via pl/java if I use a ::uuid
after the query. However, this makes maintaining these queries a mess.
I'm running postgres 8.3.7.

Has anyone else experienced this?

Thanks,
Lucas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20090623/441c423b/attachment.html>

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Lucas Madar 2009-06-24 06:49:41 [Pljava-dev] uuid datatypes and prepared statements
Previous Message Kris Jurka 2009-06-18 17:52:14 [Pljava-dev] How to read LargeObject with pljava?