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.
