This is a long shot but has anybody used Spring JDBC and The RDBMS Operation classes in particular, with the Universe database.
I've developed some classes that work with Oracle. When I try the same classes connecting to Universe, I get :
java.sql.SQLException: The result set is closed
The code has successfully gone into the overridden
protected Object mapRow(ResultSet resultSet, int i) throws SQLException
method but throws an exception somewhere in the execute method of the MappingSqlQuery.
I was wondering if it was closing the connection too soon. I overrode SingleConnectionDataSource to return false in the shouldClose method but it didn't make any difference.
If anybody has any suggestions, I'd be very grateful because I'd much rather use Spring JDBC than any other JDBC framework, such as iBatis.
Thanks in advance