File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connectionpoll , unable to connect to database and site went sudenly, help me ASAP!!

 
bikash kc
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

My site is using the connection.properties files for connection configuration parameter, like this:

(
rdbms=Oracle
jdbcDriver=oracle.jdbc.driver.OracleDriver
jdbcURL=jdbcracle: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.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

invalid arguments in call

Looks like your call to logon to the database contains some unrecognised parameters. What are:
  • strPreconnectCount=10
  • strMaxIdleConnections=10
  • strMaxConnections=100

  • I don't see them listed in the docs as properties the thin driver supports.
     
    I agree. Here's the link: http://aspose.com/file-tools
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic