File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark ""declared-sql" query problem in jbosscmp-jdbc.xml..." Watch ""declared-sql" query problem in jbosscmp-jdbc.xml..." New topic

"declared-sql" query problem in jbosscmp-jdbc.xml...

Pras Tiwari
Ranch Hand

Joined: Nov 07, 2005
Posts: 186
I got stuck with My application based on EJB2.1 using CMP2.0 spec. due to following "declared-sql" in my jboss-cmp:-

<where><![CDATA[orderid like '%%' GROUP BY orderno]]> </where>
now I am able to deploy it successfully to JBOSS4.0.3 server. But when I am accessing this query in my application, I am getting fllowing error.
12:44:06,015 INFO [STDOUT] javax.ejb.FinderException: Find failed: java.sql.SQLException: ERROR: function ordernocount(character varying) does not exist
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.invoke(
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(
12:44:06,140 INFO [STDOUT] at org.jboss.proxy.compiler.Runtime.invoke(

PLease help me.
Whay I am getting this error?
Thank you.

********Deserve Before You Desire********
I agree. Here's the link:
subject: "declared-sql" query problem in jbosscmp-jdbc.xml...
It's not a secret anymore!