Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    25

    Unanswered: An I/O error occured while sending to the backend

    Hey all,

    Does anyone know - or have any ideas why the following error occurs?

    'An I/O error occured while sending to the backend'

    All works well, and no errors are encountered until I cast the resultsetmetadata to PGResultSetMetaData and then try to retrieve the basetable name...

    Any suggestions, advice to resolve this problem will be v much appreciated!

    Thanks in advance

    sub.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    for starters, what application are you using?

    What version of postgreSQL?
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    May 2005
    Posts
    25
    Hi loquin - first want to thank u for the response much appreciated!

    I am using Postgresql 8.1 and Netbeans 5 to develop my application. Other details regarding the app are as follows:

    This is how i cast in the code:
    pgrsmd =(PGResultSetMetaData)rs.getMetaData();

    Then i send the column name and the table name to find the column alias as follows:

    String colName=getColAlias(rsmd.getColumnName(i),pgrsmd.g etBaseTableName(i));

    note:getColAlias is my written function...

    error occurs here due to the pgrsmd.getBaseTableName(i)....which is caused by java.io.IOException: Stream closed...but note i have not closed the connection to the database (if i omit the above line and work with just rs works fine no errors or other problems-although by using getTableName-ResultSetMetaData will return "")...

    Any ideas???

    Thanks for the response anyhow!!!

Posting Permissions

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