0 Replies Latest reply on Jan 8, 2007 4:02 PM by François Bonin

    ResultSet is automatically closed

    François Bonin Newbie

      I am connecting to an informix Dynamic Server using the 3.0 JC3 JDBC drivers,
      I open a ResultSet and start reading through it; if the type of the field I am reading does not match my command (rs.getInt(...) for a date field for example)

      I get the following message:
      [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1651733[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@3e5dbe handles=1 lastUse=1168289835216 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1e1c66a context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1a95a1d xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@7ca5b2 txSync=null]
      java.sql.SQLException: System or internal errorjava.lang.NumberFormatException: For input string: "01-03-2007"
      <HERE FOLLOWS THE STACK TRACE OF THE EXCEPTION>


      following this, the ResultSet I am using gets closed (and subsequent data reads fail).

      What am I doing wrong?
      immediately after attempting to read a field.