My mistake in earlier post, I was little confused as all other CMPs in my project does not have getter and those still works!!
Anyway I tried putting getter methods in PK class but still getting same error. The query jboss is generating is missing FROM a expression before FROM. It is generating a query as follow: SELECT FROM SMPPAGENTPROFILE t0_s WHERE (t0_s.smppAgentProfileId > 0) Log: | 2005-05-30 10:31:10,197 DEBUG [] Executing SQL: SELECT FROM SMPPAGENTPROFILE t0_s WHERE (t0_s.smppAgentProfileId > 0) | 2005-05-30 10:31:10,213 DEBUG [] Find failed | java.sql.SQLException: ORA-00936: missing expression | | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) | at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) | at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) | at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) | at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651) | at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117) | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331) | at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422) | at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:314) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:198) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:117) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:38) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:587) | at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:285) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:322) | at org.jboss.ejb.EntityContainer.find(EntityContainer.java:670) | 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:585) | at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1061) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) | at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:204) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) | at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90) | at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) | at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) Any pointers? Let me know if you need more details on my CMP bean. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3879407#3879407 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3879407 ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user