Hi, all you have to do use a transaction enabled data-source and use the Mm-MysqlDriver for your JDBC connections. (http://mmmysql.sourceforge.net/)
Best is to read the InnoDB documentation carefully (http://www.innodb.com), as you cannot choose from a wide variety of transaction-levels ... in my experience, most of the detailed transaction-handling can only be done at mysql-query level. To test wether your datasource supports the transactions, do a test and look at the InnoDB-logfiles, it should indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Greetz, CB. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 22:33 To: [EMAIL PROTECTED] Subject: high level: enabling transactions in mysql-max with WebLogic TX datasource? One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- =================================================================== David M. Karr ; Java/J2EE/XML/Unix/C++ [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
