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(Gest ioneLog.java:44)
at braccialetto.operatore.Esecuzione.insertOperatore( Esecuzione.java:160
)
at operatore._0002foperatore_0002fGestioneOperatore_0 002ejspGestioneOper
atore_jsp_0._jspService(_0002foperatore_0002fGesti oneOperatore_0002ejspGestioneO
peratore_jsp_0.java:213)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedSer vlet.service(JspSer
vlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWra pper.service(JspSer
vlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:4
29)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.tomcat.core.ServletWrapper.doService(Se rvletWrapper.java:4
05)
at org.apache.tomcat.core.Handler.service(Handler.jav a:287)
at org.apache.tomcat.core.ServletWrapper.service(Serv letWrapper.java:372
)
at org.apache.tomcat.core.ContextManager.internalServ ice(ContextManager.
java:797)
at org.apache.tomcat.core.ContextManager.service(Cont extManager.java:743
)
at org.apache.tomcat.service.http.HttpConnectionHandl er.processConnectio
n(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(Po olTcpEndpoint.java:
416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable. run(ThreadPool.java
:501)
at java.lang.Thread.run(Thread.java:484)
HEEEEEEEELP!!
TSM (Carmine)