Hello to everybody,
I have a problem when using BMP and ORACLE, it seems that jBoss 2.4.4 prevents me from using scrollable or updateable prepared statements. This is my jboss.jmcl:
OracleDB
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@(description=(address=(host=training12)(protocol=tcp)(port=1521))(connect_data=(service_name=ora8test.signsoft)(server=shared)))
1200000
SIGNSOFT_thomas
thomas
5
false
false
false
true
120000
1800000
false
false
1.0
0
I'm opening now a connection on that datasource, I also request a scrollable result set.
This does not work, because org.jboss.pool.jdbc.PreparedStatementFactory.createObject() does not care if I request an updateable or scrollable result set.
My question: is there any workaround beside writing my own MBean around my own XADatasource implementation? The current CVS version has no newer files, and I cannot use jBoss 3.0 since it is alpha software.
Thank you,
Thomas
Is there anybody who can confirm this bug?