Re: [JBoss-user] Invalid end of SQL statement for finder in jaws.xml

[Janardhan B. <jbu...@ai...>]

HI All,

I am having a problem when accessing the finder written for an entitiy 
bean in the jwas.xml
the finder looks like this

      <finder>
        <name>findAllOrdered</name>
        <query></query>
        <order>CREATINGTIME DESC</order>
      </finder>
 and the exception when calling this finder looks like this below

i am using Jboss-3.2.4-Tomcat-4.1.24
jdk 1.4.0
and sapdb database




javax.ejb.FinderException: Find failed: 
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3014] (at 40): 
Invalid end of SQL statement
    at 
org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand.java:118)
    at 
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:200)
    at 
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersistenceManager.java:292)
    at 
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:324)
    at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:323)
    at org.jboss.ejb.EntityContainer.find(EntityContainer.java:660)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at 
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998)
    at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188)
    at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
    at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
    at 
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91)
    at 
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
    at 
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
    at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
    at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:273)
    at 
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
    at 
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
    at 
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
    at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
    at 
org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477)
    at org.jboss.ejb.Container.invoke(Container.java:694)
    at sun.reflect.GeneratedMethodAccessor329.invoke(Unknown Source)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
    at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
    at 
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:83)
    at 
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
    at 
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
    at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
    at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
    at $Proxy677.findAllOrdered(Unknown Source)
    at

please help me out
i ran out od ideas and trials

regards
jani