[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - ResultSet is automatically closed

[TheCois]

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 at 1651733[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at 3e5dbe handles=1 lastUse=1168289835216 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 1e1c66a context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 1a95a1d xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3999201#3999201

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3999201