• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3040
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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