From: | mljv(at)planwerk6(dot)de |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | bug with prepared statements and sql comments in 8.1-408.jdbc3 |
Date: | 2007-06-05 11:02:57 |
Message-ID: | 200706051302.57899.mljv@planwerk6.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
i am using hibernate3, postgresql 8.1 and pg-jdbc 8.1-408.jdbc3
when is set hibernate.use_sql_comments to true, hibernate sends sql comments
to the postgresql driver to ease debugging.
But the driver does not recognise the comment in respect of parameters:
Caused by: org.postgresql.util.PSQLException: Für den Parameter 2 wurde kein
Wert angegeben.
["No value for parameter 2 was specified"]
Hibernate send the following string to the driver:
/*
from
customers As cu
where
cu.name = ? */ select
[...]
from
Customer customer0_
where
customer0_.customer0_name=?
the driver doesnt see that the first "?" is inside a comment. That's my guess
from reading a very similar bug report:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-521
this one was tracked down in the oracle driver, so i guess postgresql has got
the same kind of bug.
if i can help to track down this bug, please contact me via PM.
--
kind regards,
janning
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-06-05 14:09:54 | Re: Connection Pool |
Previous Message | Andreas Joseph Krogh | 2007-06-05 07:38:57 | Re: Array paramiters |