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

      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.