[EMAIL PROTECTED] wrote:
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.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
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]