1 Reply Latest reply on Feb 20, 2002 4:49 AM by Thomas Poeschmann

    Scollable/Updateable PreparedStatement Problem in jBoss 2.4.

    Thomas Poeschmann Newbie

      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