You have eliminated the database from your enquiries. I'd lay money that
your application is not passing the insert statement that you think it is.
Try setting sql_trace to true for that session and seeing what the app is
actually passing to the database. If you wish the application to scale
properly you should use bind variables rather than literals as well.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"TSM" <thesuddenmiracle_at_libero.it> wrote in message
news:a5462c31.0310280252.6dccb3f0_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_0002ejspGesti
oneO
> 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 - 05:52:28 CST
