Hi All,
My site is using the connection.properties files for connection configuration parameter, like this:
(
rdbms=Oracle
jdbcDriver=oracle.jdbc.driver.OracleDriver
jdbcURL=jdbc:oracle:thin:@localhost:1521:ICN
username=shop
password=v2HsFcW
strPreconnectCount=10
strMaxIdleConnections=10
strMaxConnections=100
)
and the connection is get from this pool.
now my site runs for some times smoothly and suddenly down. when i again restart the
tomcat, it again start working.
my site is in tomcat5, oracle 9i and apache.
while site went down , following error occurs:
ERROR [http-9080-Processor19] 06 Sep 01:12:09 [LiteralService] --> ERROR: invalid arguments in call
java.sql.SQLException: invalid arguments in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:189)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.shopnl.service.jdbc.ConnectionPool.checkOut(ConnectionPool.java:167)
at com.shopnl.service.jdbc.LiteralService.fillLiteralsByAffiliateId(LiteralService.java:275)
at com.shopnl.service.jdbc.LiteralService.getLiteral(LiteralService.java:34)
at com.shopnl.handler.LiteralHandler.getLiteral(LiteralHandler.java:20)
at com.shopnl.tag.LiteralTag.doStartTag(LiteralTag.java:40)
at org.apache.jsp.productdetails_jsp._jspx_meth_shop_literal_0(productdetails_jsp.java:959)
at org.apache.jsp.productdetails_jsp._jspService(productdetails_jsp.java:372)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
could you please help me ASAP!!
lots thanks in Advance!!
Bikash.
