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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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(ResultSetInPool.java:
> 542)
> at
>
com.earthcars.core.dao.BaseDAO.constructResultFromResultSet(BaseDAO.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
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user