You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Lalita P <lp...@india.coas.com> on 2002/03/14 13:02:38 UTC
Problem while constructing sql select statement in org.apache.torque.util.BasePeer.java
Hi,
We have got a problem running scarab with Oracle as database
using village API. Could anyone help us out in solving the problem ?
We are getting the exception mentioned below when we try to login
to scarab.
java.lang.reflect.InvocationTargetException:
java.sql.SQLException: ORA-
01841: (full) year must be between -4713 and +9999, and not be 0
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery
(OracleStatement.java:1608)
at oracle.jdbc.driver.OracleStatement.doExecute
(OracleStatement.java:1758)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1805)
at oracle.jdbc.driver.OracleStatement.executeQuery
(OracleStatement.java:410)
at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1372)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1334)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1285)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1215)
at org.tigris.scarab.om.BaseUserPreferencePeer.doSelectVillageRecords
(BaseUserPreferencePeer.java:261)
at org.tigris.scarab.om.BaseUserPreferencePeer.doSelectVillageRecords
(BaseUserPreferencePeer.java:231)
at org.tigris.scarab.om.BaseUserPreferencePeer.doSelect
(BaseUserPreferencePeer.java:209)
at org.tigris.scarab.om.ScarabUserImpl.isPasswordExpired
(ScarabUserImpl.java:596)
at org.tigris.scarab.actions.Login.checkUser(Login.java:141)
at org.tigris.scarab.actions.Login.doLogin(Login.java:88)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.turbine.modules.actions.TemplateAction.executeEvents
(TemplateAction.java:171)
at org.apache.turbine.modules.actions.TemplateAction.perform
(TemplateAction.java:115)
at org.apache.turbine.modules.ActionEvent.execute(ActionEvent.java:152)
at org.apache.turbine.pipeline.DefaultLoginValve.process
(DefaultLoginValve.java:164)
at org.apache.turbine.pipeline.DefaultLoginValve.invoke
(DefaultLoginValve.java:106)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.DefaultSessionTimeoutValve.invoke
(DefaultSessionTimeoutValve.java:122)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.DetermineTargetValve.invoke
(DetermineTargetValve.java:114)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.DetermineActionValve.invoke
(DetermineActionValve.java:108)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.TurbinePipeline.invoke
(TurbinePipeline.java:211)
at org.apache.turbine.Turbine.doGet(Turbine.java:282)
at org.apache.turbine.Turbine.doPost(Turbine.java:329)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.connector.http.HttpProcessor.process
(HttpProcessor.java)
at org.apache.catalina.connector.http.HttpProcessor.run
(HttpProcessor.java)
at java.lang.Thread.run(Thread.java:484)
rethrown as org.apache.turbine.TurbineException
at org.apache.turbine.pipeline.DefaultLoginValve.invoke
(DefaultLoginValve.java:110)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.DefaultSessionTimeoutValve.invoke
(DefaultSessionTimeoutValve.java:122)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.DetermineTargetValve.invoke
(DetermineTargetValve.java:114)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.DetermineActionValve.invoke
(DetermineActionValve.java:108)
at org.apache.turbine.pipeline.TurbinePipeline.invokeNext
(TurbinePipeline.java:229)
at org.apache.turbine.pipeline.TurbinePipeline.invoke
(TurbinePipeline.java:211)
at org.apache.turbine.Turbine.doGet(Turbine.java:282)
at org.apache.turbine.Turbine.doPost(Turbine.java:329)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java)
at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java)
at org.apache.catalina.connector.http.HttpProcessor.process
(HttpProcessor.java)
at org.apache.catalina.connector.http.HttpProcessor.run
(HttpProcessor.java)
at java.lang.Thread.run(Thread.java:484)
We found the statement below logged in torque.log file.
2002-03-14 15:55:24,360 [HttpProcessor[8000][4]] DEBUG org.apache.torque.util.BasePeer - SELECT SCARAB_USER_PREFERENCE.USER_ID, SCARAB_USER_PREFERENCE.PASSWORD_EXPIRE FROM SCARAB_USER_PREFERENCE WHERE (SCARAB_USER_PREFERE
NCE.USER_ID=200) AND (SCARAB_USER_PREFERENCE.PASSWORD_EXPIRE<TO_DATE('Thu Mar 14 15:55:24 GMT+05:30 2002', 'yyyy-mm-dd hh24:mi:ss..' ))
We tried to execute this select statement in sql* plus and are
getting the same error.
The date format given in the query above does not match with the
date mentioned. What could be done to overcome this problem?
It seems to be some problem while constructing sql select
statement mentioned above in org.apache.torque.util.BasePeer.java
With Regards
Lalita
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>