Tomcat 5.0.18 [ODBC Microsoft Access Driver] Too many..

Discussions

General J2EE: Tomcat 5.0.18 [ODBC Microsoft Access Driver] Too many..

  1. Hi all,

    I know this is general java newsgroup, but i try to post this question
    anyway.....

    I have Tomcat 5.0.18 web server on W2K (sp4) workstation and Access 2000
    database.

    When i try to retrive some information from databasde i got the erorr below:

    **********************************************************************
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too many
    client tasks.
     at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
    **********************************************************************

    I think the problem should be in Tomcat configuration, because i have
    checked on my java code to find out some
    database connection still open, but no way.

    Could someone help me?

    Thanks in advance

    Franz.
  2. The problem is with Access. The Access "database" is not a real relational database, and can only handle a very small number of client connections. Odds are good that your application is trying to use more than this limited set of connections (maybe in a connection pool).

    The only solution is to switch to a better database (e.g. SQLServer). You can't use Access for applications that have more than a handful of users. This makes it useless for web applications (which by definitions, are multi-user).
  3. Function sequence error- PLEASE HELP[ Go to top ]

    Hi
    i have a jsp page (registration page) connecting to MS Access database which has 3 SQL queries in it:
    - check's user input's username - SELECT query in members table to check if record with same username exists
    -check's user input's email - SELECT query in members table to check if record with same email exists
    -if no records found (from above queries) INSERT user's input (from HTML form) into table in database.

    On Tomcat 4/Java 1.3 all was fine. When i transferred live onto Tomcat 5.0.19/Java 1.4.2_04 i get FUNCTION SEQUENCE ERROR:

    exception
    javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver]Function sequence error
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800) org.apache.jsp.register_jsp._jspService(register_jsp.java:172) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

    root cause
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Function sequence error sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) sun.jdbc.odbc.JdbcOdbc.SQLParamData(JdbcOdbc.java:4738) sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:225) sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:136) org.apache.jsp.register_jsp._jspService(register_jsp.java:143) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

    Any suggestions please ? What am i doing wrong? is it the Access driver, the jsp code or something else?
    THANKS LOTS
    Rina