Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Angry Unanswered: java.sql.SQLException: Could not write to a temporary file

    I'm trying to get to randomaly selected record in the result set.
    The only way I found to do so is:

    currRow = (int)(Math.random() * numberOfRows);
    for (int i=0; i<currRow; i++) {
    m_resultset.next();
    }

    sometime I get exception:
    java.sql.SQLException: Could not write to a temporary file.
    at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:349)
    at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav a:3043)
    at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3353)
    at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2254)
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2174)
    at com.informix.jdbc.IfxSqli.executeScrollFetch(IfxSq li.java:5166)
    at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:404 3)
    at com.informix.jdbc.IfxResultSet.next(IfxResultSet.j ava:525)
    at DBConnection.updateRandomElement(DBConnection.java :138)
    at main.main(main.java:27)


    Any idea?

  2. #2
    Join Date
    Aug 2003
    Location
    West
    Posts
    101

    Re: java.sql.SQLException: Could not write to a temporary file

    root dbspace? Do 'tbstat -d' while you're running the
    pgm and see if any chunks get near 0 free ???

Posting Permissions

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