This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes connectionpoll , unable to connect to database and site went sudenly, help me ASAP!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connectionpoll , unable to connect to database and site went sudenly, help me ASAP!!" Watch "connectionpoll , unable to connect to database and site went sudenly, help me ASAP!!" New topic
Author

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

bikash kc
Greenhorn

Joined: Sep 05, 2007
Posts: 1
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

Joined: Apr 14, 2004
Posts: 10336


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.


    JavaRanch FAQ HowToAskQuestionsOnJavaRanch
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: connectionpoll , unable to connect to database and site went sudenly, help me ASAP!!