Hi,
We are trying to obtain a ResultSet from an Oracle database. We find
a trouble with Minerva types,
We are using JBoss 2.2, with JDBC 2.0 and Oracle 8.1.7.
We are using MinervaPool driver for the JDBC. In our configuration
files,
- jboss.jcml: We use 'org.jboss.minerva.xa.XADataSourceImpl' in
the Pool configuration
- jboss.properties:
#jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
First, is OraclePool (oracle.jdbc.xa.client.OracleXADataSource) better
than MinervaPool (org.jboss.minerva.xa.XADataSourceImpl) ?
Second, When we try to execute a ResultSet from the EJB it throws:
[noticiasAccesoBD] Exception in
noticiasAccesoBD::obtenerNoticiasBoletin()
[noticiasAccesoBD] java.lang.ClassCastException:
org.opentools.minerva.jdbc.ResultSetInPool
[noticiasAccesoBD] at
es.westlaw.noticiasAccesoBDBean.obtenerNoticiasBoletin(Compiled Code)
The code we use:
l_query = "SELECT noticia FROM noticias";
l_pstmt = l_con.prepareStatement(l_query);
l_rst = l_pstmt.executeQuery();
// which of the next two lines should be here??
// l_rst2 =
((org.jboss.minerva.jdbc.ResultSetInPool)l_rst).getUnderlyingResultSet()
; // JBOSS
l_rst2 =
((org.opentools.minerva.jdbc.ResultSetInPool)l_rst).getUnderlyingResultSet()
; // JBOSS
while (l_rst2.next())
{
l_noticiasCLOB = ((OracleResultSet)l_rst2).getCLOB(1);
}
Any help would be appreciated...
Thanks in advance...
Jose R. & Juan
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user