-
1. Re: EJB-QL: Wrong SQL query generated for TRUE on MySQL usin
vashistvishal Jul 13, 2003 12:19 AM (in response to mrauch)Now, For one parameter u are passing argument through the method which will implemt this query that is "?1" but for another you are assigning value in query "true", why dont u pass the arguement same as argument one as
"?2" and see what happens.
I cant see anything wrong in the query.
Another point to make is if you are using MySql, then what i understand is you have to cretae a another file similar to standardjbosscmp-jdbc.xml with a different name of course and then do ur customized changes for MySql in that file, rather then changing yr default file.
I hope this helps. -
2. Re: EJB-QL: Wrong SQL query generated for TRUE on MySQL usin
mrauch Jul 13, 2003 9:33 AM (in response to mrauch)I wasn't passing the boolean value in as parameter because I'm only interested in the objects that have this flag set to true, I don't have a use-case that needs the objects with the flag set to false.
I followed your suggestion to pass in this value as parameter ?2 and it worked! It seems that the conversion from Boolean objects to SQL query works, but not the parsing of the TRUE literal in the query itself. Now I get the objects back I'm interested in. The modifications of standardjbosscmp-jdbc.xml I posted aren't necessary to get it working. Thanks for the hint!!