JDBC error under RH9 for PG7.4/TOMCAT4.1 but not under WINDOWS - Mailing list pgsql-jdbc
| From | David Gagnon |
|---|---|
| Subject | JDBC error under RH9 for PG7.4/TOMCAT4.1 but not under WINDOWS |
| Date | |
| Msg-id | 422CB275.6030407@siunik.com Whole thread Raw |
| List | pgsql-jdbc |
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)
pgsql-jdbc by date: