Skip site navigation (1) Skip section navigation (2)

JDBC error under RH9 for PG7.4/TOMCAT4.1 but not under WINDOWS

From: David Gagnon <dgagnon(at)siunik(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC error under RH9 for PG7.4/TOMCAT4.1 but not under WINDOWS
Date: 2005-03-07 19:58:45
Message-ID: 422CB275.6030407@siunik.com (view raw or flat)
Thread:
Lists: 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 to buildSqlMap()]'. Check the Result Map.  Check the 'timestamp' property. Cause: Bad Timestamp Format at 23 in 2005-03-07 14: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-07 14: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

Next:From: Mican BicanDate: 2005-03-07 20:01:26
Subject: Convert java.sql.Date to java.util.Date
Previous:From: PrasanthDate: 2005-03-07 19:20:49
Subject: Re: java.sql.date insert as null

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group