> I'm using a data-source (Oracle) from a stateless session bean.
> The session bean uses bean managed transactions (User transactions).
> Reading and writing data to the Oracle database works fine.
>
> The only problem is that when the ejb-transaction gets rolled back the
> database transaction does not roll back.
>
> Simplified example:
>
> <i>
> // Get the connection
> Context context = new InitialContext();
> ds = (DataSource)context.lookup("jdbc/MyDSCore");
> Connection conn = ds.getConnection();
> conn.setAutoCinnit(false);
>
>
> try
> {
> sessionContext.getUserTransaction().begin();
>
> conn.createStatement(.....);
> conn.executeUpdate();
>
> // If a rollback occurs here the data still gets updated
>
> ...
> sessionContext.getUserTransaction().commit();
> }
> catch(Exception e)
> {
> e.printStackTrace();
> sessionContext.getUserTransaction().rollback();
> }
> </i>
>
> My <b>data-sources.xml</b> looks like this:
>
> <i>
> <data-source
> class="com.evermind.sql.DriverManagerDataSource"
> name="MyDS"
> connection-driver="oracle.jdbc.driver.OracleDriver"
> location="jdbc/MyDSCore"
> username="scott"
> password="tiger"
> url="jdbc:oracle:thin:@SERVER:PORT:SID"
> />
> </i>
>
> Does anyone have any idea of why the transactions are not working
> properly???
