Hi,
I am
having some problems with the generated sql from JBoss 3.2.1 on a PostgresSql
7.2, not using indexes.
If I try
to use find by primary key on a CMP bean called Slot (using id 1400), where the
primary key is a Long, the generated look like that:
SELECT
slot_id FROM slot WHERE slot_id=1400
But since Postgres
does not detect any quote around 1400 or 1400 is not cast to a int8 (datatype of
slot_id int eh database), it does not use the existing index on the promary
key.
I am using the
standard type mapping for postgres 7.2, set in
standardjbosscmp-jdbc.xml.
Thank for any
solutions
Regards,
Stephane
