I am trying to port an application in plain Java to J2EE to run on JBOSS. I have a query that runs on ms-sql database server and uses ms-sql function (convert). The query looks like this:
select convert(numeric(20), aDBColumnName) from aTable ...... In this query: aDBColumnName: Database column of type 'varchar' This query is basically doing a type conversion from varchar into a long value. Now the problem is that EJB-QL doesnt provide such a type conversion function. I have also tried to extend this query with JBossQL but no such function is provided by JBossQL. Because of performance reasons, it is not possible to port this logic into Java code while keeping the query simple. I will much appretiate if any one could direct me how to do a type conversion in ejb-ql. thanking in advance Nauman Mir View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842804#3842804 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842804 ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
