[JBoss-user] [Persistence & CMP/JBoss] - Jboss-QL function mapping?

2004-08-18 Thread jbeyer
Examining 'standardjbosscmp-jdbc.xml', I see numerous jboss-ql function -> SQL function mappings such as | | locate | locate(?1,?2) | | Is it possible to extend jboss-ql by adding new entries? Such as: | | month

[JBoss-user] [Nukes User] - Re: bug in EJBQLToSQL92Compiler

2004-08-11 Thread jbeyer
Sorry, ignore post. I meant to be in Jboss User forum. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844837#3844837 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844837 -

[JBoss-user] [Persistence & CMP/JBoss] - bug in EJBQLToSQL92Compiler

2004-08-11 Thread jbeyer
Bug appears in JBoss 3.2.5: When I create a dynamic query, using EJBQLToSQL92Compiler as the QL copmiler, the LIMIT part of my clause is ignored. The same query works fine with JDBCEJBQLCompiler. Query is as follows: SELECT OBJECT(c) FROM BusinessType AS bt, IN( bt.customers ) AS c WHERE bt.

[JBoss-user] [Nukes User] - bug in EJBQLToSQL92Compiler

2004-08-11 Thread jbeyer
Bug appears in JBoss 3.2.5: When I create a dynamic query, using EJBQLToSQL92Compiler as the QL copmiler, the LIMIT part of my clause is ignored. The same query works fine with JDBCEJBQLCompiler. Query is as follows: | SELECT OBJECT(c) FROM BusinessType AS bt, IN( bt.customers ) AS c WHERE