wood burning stoves 2.0*
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

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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(JDBCAbstractQueryCommand.java:245)
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:128)
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:99)
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.invoke(JDBCSelectorBridge.java:70)
12:44:06,015 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:91)
12:44:06,140 INFO [STDOUT] at org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:62)

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

********Deserve Before You Desire********
I agree. Here's the link: http://aspose.com/file-tools
subject: "declared-sql" query problem in jbosscmp-jdbc.xml...