1 Reply Latest reply on Dec 19, 2012 5:34 PM by Cory Dahlstrom

    JBoss 7.1.1 Final with EJB 2.1 - jboss-ql issue

    Cory Dahlstrom Novice

      I'm having an issue porting an EJB 2.1 entity been that has some jboss-ql in it that looks like this:


      select object(o) from SomeBean o where o.isThisIt = true


      This jboss-ql is transforming into this sql statement:


      SELECT t0_o.ID FROM SOME_TABLE t0_o WHERE (t0_o.IS_THIS_IT = (1=1))


      The way this used to work with JBoss 4 was you defined a <type-mapping> in  your datasource something like "Oracle9i".  This then mapped back to a cmp configuration in standardjbosscmp-jdbc.xml.  In there, for the "Oracle9i" configuration, the <true-mapping> is defined as 1 so the query which is generated looks like this:


      SELECT t0_o.ID FROM SOME_TABLE t0_o WHERE (t0_o.IS_THIS_IT = 1)


      The query that JBoss 7 is generating doesn't work.


      I tried adding a <type-mapping> to my datasource configuration in the standalone-full.xml file, but it doesn't parse.  I tried also putting that under a <metadata> tag as well, but that doesn't parse either.


      If I crack open the cmp module jar file "jboss-as-cmp-7.1.1.Final.jar" I can see the standardjbosscmp-jdbc.xml file is there, but it doesn't seem to use it?


      Any ideas?