| 2006 03 21
Error met at MMA by Laurent.
My environment is:
* Sun JDK 1.5.0_03
* Apache Tomcat/5.5.12
* Windows 2000 SP4 FR
* Oracle8i Enterprise Edition Release 8.1.7.4.1
* Eptica Server 6.6.p1 (607.2)
The following SQL error appeared when I tried to validate the default login form (which is enabled):
http://sf59366.societe.mma.fr:8080/eptica-integration/dispatch/connection?Screen=login&lang=fr_FR
=> What does this mean? Is there some Oracle configuration problem?
DEBUG:SF59366:DispatchingServlet:03/21/06 10:24:37 AM:Creating new session of type: connection
DEBUG:SF59366:DispatchingServlet:03/21/06 10:24:37 AM: Access to connection handler from 10.200.40.219
DEBUG:SF59366:UserSession:03/21/06 10:24:37 AM:Language's been set to fr_FR charset to ISO-8859-15 for session edfel28lb_5
DEBUG:SF59366:ASTFactory:03/21/06 10:24:37 AM:AST is succesfully built for FormStyleSheetInclude/fr_FR,html
DEBUG:SF59366:ASTFactory:03/21/06 10:24:37 AM:AST is succesfully built for login/fr_FR,html
DEBUG:SF59366:RequestDB:03/21/06 10:26:54 AM:New request #36 is created.
DEBUG:SF59366:RequestPool:03/21/06 10:26:54 AM:Customer identified as new customer:
ID=40,
Salutation=Mr.,
LastName=Peaucelle,
FirstName=Laurent,
EMail=xxx@yyy.zzz
INFO:SF59366:RequestImpl:03/21/06 10:26:54 AM:Request #36 status changed from invalid to open
DEBUG:SF59366:RequestImpl:03/21/06 10:26:54 AM:Request state for request #36 directly set to open
ERROR:SF59366:RequestDB:03/21/06 10:26:55 AM:Unexpected SQL exception (rate=1.0) : SQL State = null, Error Code = 17041, Reason: Missing IN or OUT parameter at index:: 2
:
Exception reason: Missing IN or OUT parameter at index:: 2
Stack Trace: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.driver.OracleStatement.checkBindsInAndOut(OracleStatement.java:1479)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1987)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
at com.eptica.MWC.database.jdbc.MPreparedStatement.executeUpdate(MPreparedStatement.java:114)
at com.eptica.MWC.database.RequestDatabaseImpl.doSaveRequest(RequestDatabaseImpl.java:2158)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.eptica.MWC.database.DatabaseCore.executeWithinTransaction(DatabaseCore.java:3248)
at com.eptica.MWC.database.RequestDatabaseImpl.doSaveRequest(RequestDatabaseImpl.java:2002)
at com.eptica.MWC.database.RequestDatabaseImpl.saveRequest(RequestDatabaseImpl.java:1955)
at com.eptica.MWC.request.RequestPoolImpl.login(RequestPoolImpl.java:275)
at com.eptica.MWC.servlets.ClientHandler.createRequest(ClientHandler.java:1241)
at com.eptica.MWC.servlets.ClientHandler.processWebBoardRequest(ClientHandler.java:599)
at com.eptica.MWC.servlets.ClientHandler.handle(ClientHandler.java:301)
at com.eptica.MWC.servlets.DispatchingServlet.handle(DispatchingServlet.java:390)
at com.eptica.MWC.servlets.DispatchingServlet.doPost(DispatchingServlet.java:184)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
INFO:SF59366:DatabaseCore:03/21/06 10:26:55 AM:Checking connections
ERROR:SF59366:RequestPool:03/21/06 10:26:55 AM:Cannot save the request: #36 to database: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
:
Exception reason: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
Stack Trace: com.eptica.MWC.interfaces.server.DBFailed: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
at com.eptica.MWC.database.DatabaseCore.throwDBFailed(DatabaseCore.java:3394)
at com.eptica.MWC.database.DatabaseCore.throwDBFailed(DatabaseCore.java:3374)
at com.eptica.MWC.database.RequestDatabaseImpl.doSaveRequest(RequestDatabaseImpl.java:2014)
at com.eptica.MWC.database.RequestDatabaseImpl.saveRequest(RequestDatabaseImpl.java:1955)
at com.eptica.MWC.request.RequestPoolImpl.login(RequestPoolImpl.java:275)
at com.eptica.MWC.servlets.ClientHandler.createRequest(ClientHandler.java:1241)
at com.eptica.MWC.servlets.ClientHandler.processWebBoardRequest(ClientHandler.java:599)
at com.eptica.MWC.servlets.ClientHandler.handle(ClientHandler.java:301)
at com.eptica.MWC.servlets.DispatchingServlet.handle(DispatchingServlet.java:390)
at com.eptica.MWC.servlets.DispatchingServlet.doPost(DispatchingServlet.java:184)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
|