Not a valid month, please HELP!!

From: TSM <thesuddenmiracle_at_libero.it>
Date: 28 Oct 2003 02:54:58 -0800
Message-ID: <a5462c31.0310280254.bb6283f_at_posting.google.com>

Hello, I'm writing a JSP application with an underlying Oracle Database. I have the following problem: the same SQL statement works fine in the SQL+ console and in SQL Navigator, but it fails in the application.

The statement is this:
INSERT INTO operatori (id_operatore, matr_operatore, cognome, nome, rif_utente, data_aggiornamento) VALUES( 'XXX', 'XXX', 'XXX', 'XXX', 'XXX', TO_DATE('28/10/2003 11:47:25', 'DD/MM/YYYY hh24:mi:ss') )

It gives this result:

java.lang.Exception: java.sql.SQLException: ORA-01843: mese non valido

        at braccialetto.GestioneLog.insertLogApplication(GestioneLog.java:44)
        at braccialetto.operatore.Esecuzione.insertOperatore(Esecuzione.java:160


)

        at operatore._0002foperatore_0002fGestioneOperatore_0002ejspGestioneOper

atore_jsp_0._jspService(_0002foperatore_0002fGestioneOperatore_0002ejspGestioneO peratore_jsp_0.java:213)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspSer
vlet.java:130)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer
vlet.java:282)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:4
29)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:4
05)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372


)

        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.
java:797)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743


)

        at org.apache.tomcat.service.http.HttpConnectionHandler.processConnectio
n(HttpConnectionHandler.java:213)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
416)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java
:501)
        at java.lang.Thread.run(Thread.java:484)

HEEEEEEEELP!! TSM (Carmine) Received on Tue Oct 28 2003 - 11:54:58 CET