David Rayroud
|
| Posted: 12/02/2002, 7:50 AM |
|
Hi,
I work with CodeCharge Studio 1.0.7.0 and I try to make a JSP site.
I work with an Informix IDS Server, Tomcat4, running on Linux SME Server.
I have a little table with 3 fields :
uid : autoincremented field, primary key and index
v_date : date field, format : mm-dd-yyyy
txt : char(50) field
With CodeCharge Studio, I can have the date, but when I will make an UPDATE or an INSERT, I have this error :
#############################################################################
#############################################################################
Can't execute SqlCommand
SQLCommand sql='INSERT INTO test_10 ( v_date, txt ) VALUES ( ?, ? )'
startPos='0'
fetchSize='0'
connection='Connection1'
Parameters:
param1 : Sun Dec 31 00:00:00 CET 2006 type: java.util.Date
param2 : BABABA type: java.lang.String
=== SQLException ====
java.sql.SQLException: System or internal error java.lang.reflect.InvocationTargetException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:423)
at com.informix.jdbc.IfxObject.fromObject(IfxObject.java:216)
at com.informix.jdbc.IfxValue.makeInstance(IfxValue.java:518)
at com.informix.jdbc.IfxValue.makeInstance(IfxValue.java:432)
at com.informix.jdbc.IfxPreparedStatement.setObject(IfxPreparedStatement.java:2209)
at com.codecharge.db.SqlCommand.prepareCommand(SqlCommand.java:252)
at com.codecharge.db.SqlCommand.executeUpdate(SqlCommand.java:137)
at com.codecharge.PageController.insert(PageController.java:463)
at com.codecharge.PageController.processButton(PageController.java:699)
at com.codecharge.PageController.processRecord(PageController.java:794)
at com.codecharge.PageController.process(PageController.java:246)
at org.apache.jsp.test_10_maint_jsp._jspService(test_10_maint_jsp.java:123)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
#############################################################################
#############################################################################
I see that on the seven row the format of the date is :
param1 : Sun Dec 31 00:00:00 CET 2006 type: java.util.Date
and it will be :
"31.12.2006"
I put the right format on CodeCharge field date (server using mm/dd/yyyy format).
Can anyone help me?
Thank your
David Rayroud
|
|
|
 |
Dandavat
|
| Posted: 12/03/2002, 12:48 AM |
|
Hi David!
What is the data base type of the date field? If it is Date make sure your db format property for date is empty, both for site and field. Because when you use db format, CCS tries to convert Date to String when inserting and updating. Conversion from String was made right, as you can see in param1 the date is already in java.util.Date type (not String).
Pranams,
Dandavat.
|
|
|
|
|
