very similar results using 1.0.0 final: 04/07/16 14:21:17 java.lang.ClassCastException 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.buildJoinTree(SqlQue ryStatement.java:1559) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.splitCriteria(SqlQue ryStatement.java:1631) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.<init>(SqlQueryState ment.java:130) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.<init>(SqlQueryState ment.java:82) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.sql.SqlSelectStatement.<init>(SqlSelectSta tement.java:50) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.getPreparedSel ectStatement(SqlGeneratorDefaultImpl.java:150) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl .java:276) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.j ava:74) 04/07/16 14:21:17 at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183) 04/07/16 14:21:17 at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIterator FactoryImpl.java:58) 04/07/16 14:21:17 at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Pers istenceBrokerImpl.java:1791) 04/07/16 14:21:17 at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persis tenceBrokerImpl.java:1321) 04/07/16 14:21:17 at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryRe ferenceBroker.java:110) 04/07/16 14:21:17 at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryRe ferenceBroker.java:232) 04/07/16 14:21:17 at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryRe ferenceBroker.java:252) 04/07/16 14:21:17 at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persis tenceBrokerImpl.java:1205) 04/07/16 14:21:17 at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( DelegatingPersistenceBroker.java:332) 04/07/16 14:21:17 at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery( DelegatingPersistenceBroker.java:332) 04/07/16 14:21:17 at com.vaisala.ice.vmdbReport.view.IpmLogDAO.getRecentActivity(IpmLogDAO.java:1 45) 04/07/16 14:21:17 at com.vaisala.ice.vmdbReport.view.IpmReportAction.execute(IpmReportAction.java :48) 04/07/16 14:21:17 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:484) 04/07/16 14:21:17 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) 04/07/16 14:21:17 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) 04/07/16 14:21:17 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) 04/07/16 14:21:17 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 04/07/16 14:21:17 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 04/07/16 14:21:17 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.ja va:65) 04/07/16 14:21:17 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source) 04/07/16 14:21:17 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispa tcher.java:604) 04/07/16 14:21:17 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:317) 04/07/16 14:21:17 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandle r.java:790) 04/07/16 14:21:17 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) 04/07/16 14:21:17 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) 04/07/16 14:21:17 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableRe sourcePooledExecutor.java:192) 04/07/16 14:21:17 at java.lang.Thread.run(Thread.java:536) 04/07/16 14:21:17 Data Access Exception com.vaisala.ice.common.dataAccess.DataAccessException: org.apache.ojb.broker.PersistenceBrokerException
-----Original Message----- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 13:38 To: OJB Users List Subject: Re: newbie: using timestamp in criteria, compound primary key [EMAIL PROTECTED] wrote: >oops, here is the output & exception. Using OJB 1.0rc7 stable > >INFO: adding criteria greater than log_time 2004-07-14 12:26:52.578 >16-Jul-2004 12:26:53 com.vaisala.ice.vmdbReport.view.IpmLogDAO >getRecentActivity INFO: calling getCollectionByQuery 04/07/16 12:26:53 > >java.lang.ClassCastException 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.buildJoinTree(Unkno w >n Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.splitCriteria(Unkno w >n Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.<init>(Unknown >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.<init>(Unknown >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.sql.SqlSelectStatement.<init>(Unknown >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.getPreparedSe l >ectStatement(Unknown Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source) >04/07/16 12:26:53 at >org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) 04/07/16 >12:26:53 at >org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk n >own Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno w >n Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknow n >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknow n >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknow n >Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno w >n Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery ( >Unknown Source) 04/07/16 12:26:53 at >org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery ( >Unknown Source) 04/07/16 12:26:53 at >com.vaisala.ice.vmdbReport.view.IpmLogDAO.getRecentActivity(IpmLogDAO.java: 1 >45) 04/07/16 12:26:53 at >com.vaisala.ice.vmdbReport.view.IpmReportAction.execute(IpmReportAction.jav a >:48) 04/07/16 12:26:53 at >org.apache.struts.action.RequestProcessor.processActionPerform(RequestProce s >sor.java:484) 04/07/16 12:26:53 at >org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274 ) >04/07/16 12:26:53 at >org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) >04/07/16 12:26:53 at >org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) >04/07/16 12:26:53 at >javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 04/07/16 >12:26:53 at >javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 04/07/16 >12:26:53 at >com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.j a >va:65) 04/07/16 12:26:53 at >oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source) 04/07/16 >12:26:53 at >com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDisp a >tcher.java:604) 04/07/16 12:26:53 at >com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRe q >uestDispatcher.java:317) 04/07/16 12:26:53 at >com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandl e >r.java:790) 04/07/16 12:26:53 at >com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270 ) >04/07/16 12:26:53 at >com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112 ) >04/07/16 12:26:53 at >com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableR e >sourcePooledExecutor.java:192) 04/07/16 12:26:53 at >java.lang.Thread.run(Thread.java:536) 04/07/16 12:26:53 Data Access >Exception com.vaisala.ice.common.dataAccess.DataAccessException: >org.apache.ojb.broker.PersistenceBrokerException > Hmm, I'm no expert on the query building but it looks like your timestamp object is expected to be something different somewhere in the query building. Could you try the 1.0 final ? If its not working there either, then you should report a bug (via Scarab on OJB's website) to get it fixed quickly. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
