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(Unknow n Source) 04/07/16 12:26:53 at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.splitCriteria(Unknow 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.getPreparedSel 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(Unkn own Source) 04/07/16 12:26:53 at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow n Source) 04/07/16 12:26:53 at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) 04/07/16 12:26:53 at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) 04/07/16 12:26:53 at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) 04/07/16 12:26:53 at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow 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.java :48) 04/07/16 12:26:53 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces 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.ja 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(ServletRequestDispa tcher.java:604) 04/07/16 12:26:53 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:317) 04/07/16 12:26:53 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandle 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(ReleasableRe 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 -----Original Message----- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 13:07 To: OJB Users List Subject: Re: newbie: using timestamp in criteria, compound primary key [EMAIL PROTECTED] wrote: >I am trying to limit a select from a logtable to the last so many days worth >of entries, but I get a class cast exception. Other criteria on same table >work OK, so I'm sure most of the setup is good. Am I missing something >really obvious? Is there an example available for querying by timestamp? > > Can you post the exception ? Also, what version of OJB do you use ? >As a second question, the underlying database table has a compound primary >key across (log_time, ipm_session, command) .. how should that be mapped in >repository.xml? > > I'm not sure, but I think you can define compound primary keys by using the primarykey attribute for each field that is part of the primary key (and similarily in the database). Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
