Hi all,
To make a short story. I have 2 Tomcat 4.1.24 with jdbc3.215.jar
intalled. The 1st runs on RedHat 9 (collocated with the Postgresql DB);
The second one runs under Windows.
I get Bad Timestamp Format exception when accessing from Tomcat under
Red Hat ?!
Any idea where is the problem. Both Environment are identical in term
of db/libs/webApp/JDBCDriver ... Any Idea where I mist something?
Thanks for your help.
By the way I found a Thread on Bad Timcestamp Format exception on the
list and tried without success the JDBC at
http://www.ejurka.com/pgsql/jars/OliverSiegmar/
DEBUG [Thread-5] (MappedStatement.java:830) 2005-03-07 14:13:30,338 : executeQueryForObject: company.get
DEBUG [Thread-5] (?:?) 2005-03-07 14:13:30,339 : {conn-101278} Connection
DEBUG [Thread-5] (?:?) 2005-03-07 14:13:30,344 : {pstm-101279} PreparedStatement: SELECT YPNUM, YPRAISON, YPRUE, YPCP,
YPVILLE, YPAPNUM, YPAYNUM, YPTEL, YPFAX, YPTELSEC, YPFAXSEC, YPTEL800, YPEMAIL, YPWEB,
YPNOTE, YPTPS, YPTVQ, YPDTDEB, ts FROM YP WHERE YPNUM = ? ORDER BY YPNUM
DEBUG [Thread-5] (?:?) 2005-03-07 14:13:30,345 : {pstm-101279} Parameters: [-]
DEBUG [Thread-5] (?:?) 2005-03-07 14:13:30,346 : {pstm-101279} Types: [java.lang.String]
DEBUG [Thread-5] (?:?) 2005-03-07 14:13:30,349 : {rset-101280} ResultSet
ERROR [Thread-5] (MappedStatement.java:869) 2005-03-07 14:13:30,357 : Error executing 'company.get' in '[Reader passed
tobuildSqlMap()]'. Check the Result Map. Check the 'timestamp' property. Cause: Bad Timestamp Format at 23 in
2005-03-0714:12:30.979331
Bad Timestamp Format at 23 in 2005-03-07 14:12:30.979331
at com.ibatis.db.sqlmap.MappedStatement.runQueryForObject(MappedStatement.java:869)
at com.ibatis.db.sqlmap.MappedStatement.executeQueryForObject(MappedStatement.java:803)
at com.ibatis.db.sqlmap.MappedStatement.executeQueryForObject(MappedStatement.java:783)
at com.davecorp.webos.dao.DaoSupport.getObject(DaoSupport.java:196)
at com.davecorp.webos.dao.DaoSupport.getObject(DaoSupport.java:169)
at com.davecorp.webos.dao.CompanyDaoImpl.getCompany(CompanyDaoImpl.java:38)
at com.davecorp.webos.dao.CompanyDaoCachedImpl.getCompany(CompanyDaoCachedImpl.java:67)
at WEB_0002dINF.pages.system.wcLoginLayout_jsp._jspService(wcLoginLayout_jsp.java:109)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationDispatcher.invoke(Unknown Source)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(Unknown Source)
at org.apache.catalina.core.ApplicationDispatcher.include(Unknown Source)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(Unknown Source)
at org.apache.jasper.runtime.PageContextImpl.include(Unknown Source)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:136)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:176)
at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:745)
at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:870)
at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:462)
at publicPages.loginError_jsp._jspx_meth_tiles_insert_0(loginError_jsp.java:81)
at publicPages.loginError_jsp._jspService(loginError_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
ERROR [Thread-5] (DaoSupport.java:206) 2005-03-07 14:13:30,360 : Error during sql: Bad Timestamp Format at 23 in
2005-03-0714:12:30.979331
Bad Timestamp Format at 23 in 2005-03-07 14:12:30.979331
at com.ibatis.db.sqlmap.MappedStatement.runQueryForObject(MappedStatement.java:869)
at com.ibatis.db.sqlmap.MappedStatement.executeQueryForObject(MappedStatement.java:803)
at com.ibatis.db.sqlmap.MappedStatement.executeQueryForObject(MappedStatement.java:783)
at com.davecorp.webos.dao.DaoSupport.getObject(DaoSupport.java:196)
at com.davecorp.webos.dao.DaoSupport.getObject(DaoSupport.java:169)
at com.davecorp.webos.dao.CompanyDaoImpl.getCompany(CompanyDaoImpl.java:38)
at com.davecorp.webos.dao.CompanyDaoCachedImpl.getCompany(CompanyDaoCachedImpl.java:67)
at WEB_0002dINF.pages.system.wcLoginLayout_jsp._jspService(wcLoginLayout_jsp.java:109)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationDispatcher.invoke(Unknown Source)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(Unknown Source)
at org.apache.catalina.core.ApplicationDispatcher.include(Unknown Source)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(Unknown Source)
at org.apache.jasper.runtime.PageContextImpl.include(Unknown Source)
at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:136)
at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:176)
at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:745)
at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:870)
at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:462)
at publicPages.loginError_jsp._jspx_meth_tiles_insert_0(loginError_jsp.java:81)
at publicPages.loginError_jsp._jspService(loginError_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
