5 Replies Latest reply on Mar 3, 2002 2:45 PM by Mike

    scrollable/updateable PreparedStatement bug in jBoss 2.4.4

    Thomas Poeschmann Newbie

      [This is a crossposting from the jBoss database/persistence forum, since I did not get a reply there]

      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

      my url
      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 from within a bean using ds.lookup() for the data source, 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