Not sure, but I don't believe Access is designed for transactions in particular.
Regardless,
though, try SAP DB (www.sapdb.org) for Windows 2K - it is a solid, transaction
supporting,
commercial grade free database with a type 4 JDBC driver. My consultancy does ETL and
enterprise
data strategies - lots of people and companies, large and small, like to keep mission
critical
data in Access databases because it is easy to use. It causes more trouble than its
worth in the
long run. So my advice is: use one of the free databases for your development purposes
(And
production, too!). Get a copy of SQL Server if you want to use a MS product that
supports
transactions well.
--- ±èÅÂȯ [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]
I am developing on ORION WIN2k tiny DB (Access2000)
I tested Transactions in Access
(con.setAutoCommit(false);con.commit();con.rollback();.)
Everything went well..
But, Orion Setting makes Problem.
in data-source.xml
data-source class=com.evermind.sql.DriverManagerDataSource
location=jdbc/AccessCoreDS
connection-driver=sun.jdbc.odbc.JdbcOdbcDriver ejb-location=jdbc/AccessDS
xa-location=jdbc/AccessXADS name=Access password=7098 url=jdbc:odbc:oriondb
inactivity-timeout=30 username=neosuper pooled-location=jdbc/AccessPool/
This code works well, but if class attribute is changed to
com.evermind.sql.DriverManagerXADataSource,
Orion will not start with not founded Source Location Errors..
Can't I use Transactions with Access 2000 ?
Please give me some advices.. and solutions
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
