• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3077
  • Last Modified:

java.sql.SQLException: -1011, [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

>OS - Windows Server 2k3 SP2 (12 Gigs of available HD space/2 Gigs of RAM/Intel Xeon Processor)
>Product with the error - actiTime 1.45  - Time tracking software (http://www.actitime.com/overview.html)
>Java programming language used (with Microsoft Access as the supported DB platform)

The FAQ page of this application indicates there is an unlimited number of customers/projects/tasks that you can create.  Which is true.  However, there is a limited number of active tasks you can assign to users which is where our error occurs.  When I attempt to attach the 510th task to the user I get the follow error.  Below is a copy of the error:

System Information
          actiTIME version:       1.45
        Operating system:       Windows 2003 5.2 for x86
        Java:       1.4.2_09-b05
        Servlet container:       Jetty/5.1.4
        Servlet API version: 2.4
        Database:       ACCESS 04.00.0000
        Driver: JDBC-ODBC Bridge (odbcjt32.dll) 2.0001 (04.00.6305)

Error details
java.sql.SQLException: -1011, [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
      at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
      at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
      at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150)
      at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214)
      at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:89)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at com.actimind.actitime.resources.TaskResource.getTasks(Unknown Source)
      at com.actimind.actitime.user.SubmitTTAction.setTimeTrackTasks(Unknown Source)
      at com.actimind.actitime.user.SubmitTTAction.loadTasks(Unknown Source)
      at com.actimind.actitime.user.SubmitTTAction.processLoadFormRequest(Unknown Source)
      at com.actimind.actitime.ATAction.execute(Unknown Source)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
      at com.actimind.actitime.ATServlet.doGet(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
      at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:832)
      at com.actimind.actitime.SystemSettingsFilter.doFilter(Unknown Source)
      at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
      at com.actimind.actitime.CustomerProjectFilter.doFilter(Unknown Source)
      at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
      at com.actimind.actitime.UserInfoFilter.doFilter(Unknown Source)
      at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
      at com.actimind.actitime.CompressionFilter.doFilter(Unknown Source)
      at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
      at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
      at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
      at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635)
      at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
      at org.mortbay.http.HttpServer.service(HttpServer.java:954)
      at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
      at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
      at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
      at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
      at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
      at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

Not quite sure why the error actually occurs but any help would be appreciated.  If I'm in the wrong Zone please let me know.  I'll be glad to submit to a different Zone.
0
birdn
Asked:
birdn
  • 4
  • 3
1 Solution
 
CEHJCommented:
Close all db resources - connections, statements, as soon as you've finished with them
0
 
birdnAuthor Commented:
Ok.  For example, let's say I have 530 tasks that are listed in a second browser window.  All these task items have "tick" boxes next to them (indicating that I want this task selected for this user).  Are you saying that I need to select one tick box at a time, then save it (which essentially closes the browser window), then do the same for the next task?  Basically, doing this task one at a time?

thx.
0
 
CEHJCommented:
I'm not making any comment at all about your gui, i'm just telling you what needs to be happening programatically, i.e. in your code, to stop your error
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
birdnAuthor Commented:
Sorry.  I'm more of a front-end user/Systems Admin.  What could I do myself to stop the error?  My apologies, I should have made that clear at the begining.
thx.
0
 
CEHJCommented:
Unlikely that anything can be done without intervention in the code unfortunately
0
 
birdnAuthor Commented:
Very good.  Thanks for the help.
0
 
CEHJCommented:
:-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now