Results 1 to 3 of 3
  1. #1
    AlmostAGuru is offline Member
    Join Date
    Aug 2009
    Posts
    5
    Rep Power
    0

    Default Open Cursors exceeed...question for fellow gurus

    In all our application code which connects to the backend oracle database using DAO patten classes.. we are using JDBC to directly connect to the database (using a connection pool from app server) managing the transactions in the DAO itself. All the methods in the DAO class are written so that connection object is explicitly closed in the finally block. However, I have noticed that in many places were are not closing prepared statements and resultsets which we are instantiating from these connections.

    Ocassionally - we see a max cursors exceeded error in our logs. Could this be due to the statements and resultset objects not being explicitly closed.

    My understanding was that if the connections or statements were not closed correctly in the appln - the app server could crash and open cursors exceeded should not come in any case. Gurus your opinion please.:rolleyes:

  2. #2
    Singing Boyo is offline Senior Member
    Join Date
    Mar 2009
    Posts
    552
    Rep Power
    6

    Default

    You posted something similar in the New to Java forum. Again, as emceenugget said there, create a test application.

    If a moderator could lock this, that'd be great
    If the above doesn't make sense to you, ignore it, but remember it - might be useful!
    And if you just randomly taught yourself to program, well... you're just like me!

  3. #3
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    26

    Default

    Thread locked

    edit: reopened at OP request.
    Last edited by Fubarable; 08-11-2009 at 06:36 PM.

Similar Threads

  1. [SOLVED] Custom Cursors: Thick Lines
    By Paul Richards in forum Advanced Java
    Replies: 4
    Last Post: 06-03-2009, 09:56 AM
  2. Hello gurus' in the house
    By javahsm in forum New To Java
    Replies: 0
    Last Post: 11-29-2008, 06:11 PM
  3. Replies: 0
    Last Post: 09-28-2008, 11:02 AM
  4. hi gurus
    By bhbzorro in forum Introductions
    Replies: 1
    Last Post: 06-26-2007, 10:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •