I'm not sure Access (and the JDBC-ODBC bridge) support
transactions. This is definitely not a supported database environment for
EJBs. Others have mentioned PostgreSQL and Interbase as good open-source
database candidates.
For the record, Minerva attempts to turn auto-commit off for all
pooled connections, but as you see, it doesn't always work.
Aaron
On Thu, 28 Sep 2000, Kamen wrote:
> Hi ,
> I'm using a BMP Entity bean with jboss and I'm using the connection pool to
> get a connection to an Access database on each method implemented by my bean
> including the ejbStore.
> Here is the pseudocode that I'm using:
> 1) get connection from the pool
> 2) print the connection's autocommit mode on the system.out
> 3) execute an update sql statement
> 4)invoke context.setRollBackOnly()
>
> The ejbStore has a transaction attribute set to REQUIRED.
>
> Now, I get a RollBackException when I try to execute the rollback and to my
> opinion the reason for this is that the autocommit mode of the connection
> that I get from the pool is set to 'true', which means that there is no way
> to roll back what the update sql statement has done and there is even no
> point in executing the rollback since there is no transaction started.
> The problem is that acourding to the sun's documentation regarding the j2ee
> BMP entity beans I cann't change the connection's auto commit mode from
> within the bean.
> My question is - am I doing something wrong or there is a bug in the jboss
> somewhere?
> Regards,
> Kamen
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
