>>>>> "Bert" == Bert VdB <[EMAIL PROTECTED]> writes:
Bert> Hi,
Bert> all you have to do use a transaction enabled data-source and use the
Bert> Mm-MysqlDriver
Bert> for your JDBC connections. (http://mmmysql.sourceforge.net/)
Bert> Best is to read the InnoDB documentation carefully (http://www.innodb.com),
Bert> as you cannot choose from a wide
Bert> variety of transaction-levels ... in my experience, most of the detailed
Bert> transaction-handling
Bert> can only be done at mysql-query level.
Bert> To test wether your datasource supports the transactions, do a test and look
Bert> at the InnoDB-logfiles, it should
Bert> indicate some thing like SET AUTOCOMMIT=0 and COMMIT.
Ok, I determined that innodb wasn't being initialized because I didn't have
"innodb_data_file_path" set in "my.ini". I added the following line to
"my.ini" in mysqladmin:
innodb_data_file_path = ibdata1:30M:autoextend
After I restarted the service and created some tables (not adding any rows yet), I
noticed the following files in the data"
subdirectory:
---------------
total 41004
drwxr-xr-x 2 dmkarr None 8192 Jul 1 15:01 mysql/
-rw-r--r-- 1 dmkarr None 2461 Jul 1 14:59 mysql.err
-rw-r--r-- 1 dmkarr None 5242880 Jul 1 14:59 ib_logfile0
-rw-r--r-- 1 dmkarr None 31457280 Jul 1 14:59 ibdata1
drwxr-xr-x 4 dmkarr None 4096 Jul 1 14:59 ./
-rw-r--r-- 1 dmkarr None 25088 Jul 1 14:59 ib_arch_log_0000000000
-rw-r--r-- 1 dmkarr None 5242880 Jul 1 14:59 ib_logfile1
drwxr-xr-x 11 dmkarr None 4096 Jun 29 11:30 ../
drwxr-xr-x 2 dmkarr None 0 Jun 29 11:07 test/
---------------
However, I don't know how to check the log files for those strings, as they
appear to be binary. A simple grep didn't find anything. Is there a special
viewer for mysql log files?
--
===================================================================
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
