0 Replies Latest reply on Jun 13, 2003 8:13 AM by Johan Hoogenboezem

    Commit on managed transaction from DataSource other than def

    Johan Hoogenboezem Newbie

      Hi
      I'm doing a direct database update to an Oracle table from a session bean method with "RequiresNew".
      I'm getting the connection from an Oracle DataSource, but the DataSource is not the default one. The default DataSource is for a postgres database.
      The change I make is not committed to the Oracle table - and I cannot call commit directly because it is a Managed transaction.
      Is this because the default DataSource is the Postgres one and JBoss (3.0.7) sees no change there and therefore does not commit?
      I see from the dtd that a DataSource can be specified for an entity bean. Is my only option to create an entity bean for the Oracle table that I'm trying to update?
      Any help is welcome.
      Thanks
      Johan