Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Posts
    8

    Unanswered: SQLState for No more data available to read.

    Environment: Oracle 9i
    JDK : 1.4

    I am maintaining a JDBC connection pool. At times I get an error saying "No more data available to read ". As far as I know (correct me if I am wrong) this error is due to a stale connection. I wanted to know what SQLstate code would identify this error so that I can check for it when the exception is thrown and re-initialize the pool.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle errors always include error number.
    If it exists please post it.
    Otherwise consider that posted error does NOT originate from Oracle

    Error message: No more data available to read.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2009
    Posts
    8

    Go it!

    Thanks for the reply.

    The log file I got didn't have any error codes associated with the message. I could reproduce the issue and found the associated SQLstate code as 08006.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >SQLstate code as 08006.
    "SQLstate" is not from Oracle, as far as I know.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by anacedent View Post
    "SQLstate" is not from Oracle, as far as I know.
    From the manual
    Quote Originally Posted by The Manual
    Unlike SQLCODE, SQLSTATE stores error and warning codes and uses a standardized coding scheme. After executing a SQL statement, the Oracle server returns a status code to the SQLSTATE variable currently in scope. The status code indicates whether a SQL statement executed successfully or raised an exception (error or warning condition). To promote interoperability (the ability of systems to exchange information easily), SQL92 predefines all the common SQL exceptions.
    The possible values are listed in the manual as well: http://download.oracle.com/docs/cd/B...htm#sthref1312

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    WOW! learned something new today

    >08006 connection failure
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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