I have Informix database that I access through jboss xa wrapper. I have a serial field that I want the value of when I do an insert. Is there any way to retrieve the value? I know Informix' driver has a method you can call to get the value but there is no way to get to the driver's connection class. Any thoughts?
You can call getUnderlyingConnection() on the jboss connection wrapper to get the (Informix) connection. Be careful: for instance call close() only on the jboss wrapper, closing the informix connection will really close the connection with informix and mess up the pool.