From: Rick G. <ric...@ea...> - 2001-05-15 22:51:32
|
Bummer, that means it might be my driver. I'm using PostgreSQL. Thanks! | -----Original Message----- | From: jbo...@li... | [mailto:jbo...@li...]On Behalf Of <enter name | here> | Sent: Tuesday, May 15, 2001 6:26 PM | To: jbo...@li... | Subject: Re: [JBoss-user] Minerva and ResultSet MetaData Bug? | | | I just did the following and it worked fine with Minerva Pools and Oracle | | | Connection conn = datasource.getConnection(); | conn.setAutoCommit( true ); | PreparedStatement pstmt = conn.prepareStatement( query ); | ResultSet rs = pstmt.executeQuery(); | | boolean anyresults = false; | System.out.println( rs.getClass() ); | ResultSetMetaData md = rs.getMetaData(); | System.out.println( "COL COUNT=" + md.getColumnCount() ); | ... blah... | | and get: | | [AVR] class org.opentools.minerva.jdbc.ResultSetInPool | [AVR] COL COUNT=2 | | | not sure what might cause that problem (one of the few I have not run into | ;) | | sorry | scott | | | ----- Original Message ----- | From: "Rick Gibbs" <ri...@ea...> | To: <jbo...@li...> | Sent: Tuesday, May 15, 2001 3:00 PM | Subject: [JBoss-user] Minerva and ResultSet MetaData Bug? | | | > | > We are getting the following exception when we try to access the | ResultSet's | > metadata: | > | > ResultSetMetaData md = rs.getMetaData(); | > int columnCount = md.getColumnCount(); | > | > Stack Trace: java.sql.SQLException: ResultSet has been closed! | > at | > | org.opentools.minerva.jdbc.ResultSetInPool.getMetaData(ResultSetIn | Pool.java: | > 542) | > at | > | com.earthcars.core.dao.BaseDAO.constructResultFromResultSet(BaseDA | O.java:131 | > ) | > at com.earthcars.core.dao.BaseDAO.execute(BaseDAO.java:113) | > | > We aren't closing the ResultSet until after this piece of code but it | seems | > that Minerva is doing that before we get a chance to get the metadata. | Has | > anyone else seen this or expirenced problems with Minerva and metadata? | > | > Thanks, | > | > | > Rick | > | > | > _______________________________________________ | > JBoss-user mailing list | > JBo...@li... | > http://lists.sourceforge.net/lists/listinfo/jboss-user | | | _______________________________________________ | JBoss-user mailing list | JBo...@li... | http://lists.sourceforge.net/lists/listinfo/jboss-user | |