[Concern-users] FinderException on TimerLocalHome.findDue(long)

[Justin W. <jus...@sa...>]

Hi,

I am set up on postgres, JBoss.  I am using a build from CVS checkout on 
22/01/2004

I am getting the following exception when the schedular triggers (from 
server.log):

2004-01-24 00:25:31,482 ERROR [STDERR] javax.ejb.FinderException: Find 
failed: java.sql.SQLException: ERROR:  parser: parse error at or near 
"." at character 158
2004-01-24 00:25:31,516 ERROR [STDERR]  at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:238)
2004-01-24 00:25:31,517 ERROR [STDERR]  at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:111)
2004-01-24 00:25:31,517 ERROR [STDERR]  at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:38)
2004-01-24 00:25:31,518 ERROR [STDERR]  at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:579)
2004-01-24 00:25:31,518 ERROR [STDERR]  at 
org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:311)
2004-01-24 00:25:31,518 ERROR [STDERR]  at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:322)
2004-01-24 00:25:31,519 ERROR [STDERR]  at 
org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:613)
2004-01-24 00:25:31,519 ERROR [STDERR]  at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2004-01-24 00:25:31,520 ERROR [STDERR]  at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2004-01-24 00:25:31,520 ERROR [STDERR]  at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2004-01-24 00:25:31,521 ERROR [STDERR]  at 
java.lang.reflect.Method.invoke(Method.java:324)
2004-01-24 00:25:31,521 ERROR [STDERR]  at 
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
2004-01-24 00:25:31,521 ERROR [STDERR]  at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
2004-01-24 00:25:31,522 ERROR [STDERR]  at 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
2004-01-24 00:25:31,523 ERROR [STDERR]  at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
2004-01-24 00:25:31,531 ERROR [STDERR]  at 
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
2004-01-24 00:25:31,532 ERROR [STDERR]  at 
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
2004-01-24 00:25:31,532 ERROR [STDERR]  at 
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
2004-01-24 00:25:31,533 ERROR [STDERR]  at 
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)

The exception is occurring at TimerLocalHome:

   public java.util.Collection findDue(long timeout)
      throws javax.ejb.FinderException;


The generated finder (from the jboss.xml ejb-ql) is:

<ejb-ql><![CDATA[SELECT DISTINCT OBJECT(i) FROM Timer i WHERE i.timeout 
<= ?1]]></ejb-ql>

I don't have any ejb-ql experience - so any help would be appreciated.

Thanks

Justin