Kamen writes:
> Hi all,
> recently we found out that mySql doesn't support transactions. We tried to
> check the transaction support for an Access database from an entity bean in
> the ejbStore procedure by invoking 'context.setRollBackOnly()' after
> updating one of the tables. However we got the RollBackException instead of
> a real rollback.
> We used the jdbc:odbc bridge driver for that.
> Generally we need a database server that:
> 1) Supports transactions
> 2) Has a bit operations support
> 3) Is an open source
What, open source like Access? ;-)
Not sure what you mean by 'a bit operations support' but I use
PostgreSQL and it works OK. You gotta take it down every month or so
the vaccuum, but that's life.
Tom
--
Tom Cook - Software Engineer
"We rarely find that people have good sense unless they agree
with us."
- Francois, Duc de la Rochefoucauld
LISAsoft Pty Ltd - www.lisa.com.au
--------------------------------------------------
38 Greenhill Rd. Level 3, 228 Pitt Street
Wayville, SA, 5034 Sydney, NSW, 2000
Phone: +61 8 8272 1555 Phone: +61 2 9283 0877
Fax: +61 8 8271 1199 Fax: +61 2 9283 0866
--------------------------------------------------
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
