Re: JDBC and MySQL problem, please help.

2002-01-17 Thread TAKAHASHI, Tomohiro 
  Hi,

Michael Tam wrote:
 
 Hi All,
 
 I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47.  I
 used m.mmysql.2.0.8 JDBC driver with the following config segment in my
 resin.conf:
 
 
 resource-ref
   res-ref-namejdbc/test/res-ref-name
   res-typejavax.sql.XADataSource/res-type
   init-param driver-name="org.gjt.mm.mysql.Driver"/
[snip]

  Do you use MySQL or MySQL-max?
  MySQL-max supports Transaction but MySQL does not support it.

  MySQL-max does not support Distributed Transaction(Two-Phase Commit).
  And "org.gjt.mm.mysql.Driver" is not for XADataSource.
  So "javax.sql.XADataSource" does not work fine.

-- 
TAKAHASHI, Tomohiro

-
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

JDBC and MySQL problem, please help.

2002-01-16 Thread Michael Tam 

Hi All,

I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47.  I
used m.mmysql.2.0.8 JDBC driver with the following config segment in my
resin.conf:


resource-ref
  res-ref-namejdbc/test/res-ref-name
  res-typejavax.sql.XADataSource/res-type
  init-param driver-name=org.gjt.mm.mysql.Driver/
  init-param url=jdbc:mysql://localhost:3306/test_tx/
  init-param user=USER/
  init-param password=PASSWORD/
  init-param relaxAutocommit=false/
/resource-ref


The initialization servlet did create and populate tables into a 'test_tx'
db which I created with 'INNODB' type.

When I run the 'Single Table' servlet example, the page showed the data of
two field of two rows under the same column swapped properly.  However, when
I check on the data in the table. The data never got swapped at all.  That's
it, I receive no exception during the process but no swapping effect on that
two piece of data in the table.

   Would someone kindly show me what's I did wrong or what I have missed??


   Many thanks.

Cheers,
Michael

-
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