boolean, CMP and EJB-QL

[rvigniel]

Hi all

I got problems with my boolean cmp fields with FireBird DB (though it works well with PostgreSQL 7.2)

jboss tries to store values 'true' and 'false' in its sql requests, but the db does not support booleans (boolean are mapped to smallint in standardjaws.xml)
so i get an error:
GDSExcepton in PreparedStatement constructor
org.firebird.gds.GDSException: Dynamic SQL error
SQL Error code = -206
Column unknown
TRUE
...
in my EJB-QL queries, the "true"/"false" constant in not translated into 1/0 so i get the same error.

everything works fine with PostgreSQL, which support boolean sql type and values "true"/"false"

isn't jboss supposed to handle the mapping of values from boolean to smallint ?
whould we avoid to use boolean cmp fields with jboss ?

[dsundstrom]

This has been fixed in Branch_3_0 and HEAD. True and false mappings are now specified on a per type-mapping basis.

BTW, what is the correct mapping for FireBird?

TRUE=? FALSE=?

[rvigniel]

okay thanks

for FireBird, booleans are mapped to SMALLINT, so i suppose true=1, false=0

[dsundstrom]

Can you check? I need a definite answer.

[rvigniel]

for FireBird, TRUE=1 and FALSE=0
for PostgreSQL 7.2, TRUE=true and FALSE=false (i saw it was set to 1/0 in standard mappings)

[rvigniel]

for FireBird: TRUE=1, FALSE=0
for PostgreSQL 7.2! TRUE=true, FALSE=false (i saw it was 1/0 in standard mappings)

[dsundstrom]

I changed PostgreSQL 7.2 true-mapping to TRUE and false-mapping to FALSE in HEAD and Branch_3_0, but the Interbase mapping was already true=1 and false=0.

[frechdachs]

Hi,
I have the same problem with an Oracle database.
Can you tell me where to configure this?
Can this mapping be defined per ejb-jar file?
(This may sound stupid, but I am new to JBoss. In the config files provided by the installation I could not find a place to configure this.)

Thanks for you help.
Greetings, Andrea

[dsundstrom]

This is only in the cvs source. You can either check out the source and build, or you can with for the 3.0.1 release later this week.