problem doing insert into a table when using XAConnection

------_=_NextPart_001_01C6D6B4.F71FE7A0
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C6D6B4.F71FE7A0"

------_=_NextPart_002_01C6D6B4.F71FE7A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I am using MySql latest server (5.0.24) and the
mysql-connector-java-5.0.3-bin.jar driver.

I am attaching the sample problem I wrote to isolate the bug. When using
the XAConnection

(setting testWithXA=3Dtrue) and doing the insert into the table, the
executeUpdate succeeds and returns 1 but

Nothing gets written to the table.

When using non-XA connection (setting testWithXA=3Dfalse), the entry =
gets
inserted into the table fine.

The output of the program with XA (or non-XA):

URL string is:jdbc:mysql://localhost:3306/test

UserId: root Password: password

XAConnection Successful!

Connection successful!

1 -> uuid:3BADFD00-C692-D46C-193A-E511ED7E9453

2 -> 1158085128

3 -> 0

4 -> 86400000

5 -> 1158085695

num rows written =3D1

Using command line client (when XA):

mysql> select * from SequenceHistory;

Empty set (0.00 sec)

Using command line client (when non XA):

mysql> select * from SequenceHistory;

+-------------------------------------------+--------------- ----+-------
-+------

--------+----------------+-------------------+-------------- --+

| sequenceID | lastMessageNumber | closed
| creat

ionTime | lastAccessTime | inactivityTimeout | expirationTime |

+-------------------------------------------+--------------- ----+-------
-+------

--------+----------------+-------------------+-------------- --+

| uuid:3BADFD00-C692-D46C-193A-E511ED7E9453 | 0 | 0
| 115

8085128 | 1158085695 | 86400000 | 0 |

+-------------------------------------------+--------------- ----+-------
-+------

--------+----------------+-------------------+-------------- --+

1 row in set (0.21 sec)

Can someone please tell me if I am missing some settings when using
XAConnection or this seems like a bug with MySQL?

Thanks very much for any help!

Sadhana

------_=_NextPart_002_01C6D6B4.F71FE7A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

<o:p> </o:p>

I am using MySql latest server (5.0.24) and the =
mysql-connector-java-5.0.3-bin.jar
driver. <o:p></o:p>

<o:p> </o:p>

I am attaching the sample problem I wrote to isolate =
the
bug. When using the XAConnection<o:p></o:p>

(setting testWithXA=3Dtrue) and doing the insert into =
the
table, the executeUpdate succeeds and returns 1 =
but<o:p></o:p>

Nothing gets written to the =
table.<o:p></o:p>

<o:p> </o:p>

When using non-XA connection (setting =
testWithXA=3Dfalse), the
entry gets inserted into the table fine.<o:p></o:p>

<o:p> </o:p>

The output of the program with XA (or =
non-XA):<o:p></o:p>

<o:p> </o:p>

URL string =
is:jdbc:mysql://localhost:3306/test<o:p></o:p>

UserId: root Password: =
password<o:p></o:p>

XAConnection Successful!<o:p></o:p>

Connection successful!<o:p></o:p>

 1 -> =
uuid:3BADFD00-C692-D46C-193A-E511ED7E9453<o:p></o:p>

 2 -> 1158085128<o:p></o:p>

 3 -> 0<o:p></o:p>

 4 -> 86400000<o:p></o:p>

 5 -> 1158085695<o:p></o:p>

num rows written =3D1<o:p></o:p>

<o:p> </o:p>

Using command line client (when =
XA):<o:p></o:p>

mysql> select * from =
SequenceHistory;<o:p></o:p>

Empty set (0.00 sec)<o:p></o:p>

<o:p> </o:p>

Using command line client (when non =
XA):<o:p></o:p>

mysql> select * from =
SequenceHistory;<o:p></o:p>

+---------------------------------------- ---+---------=
----------+--------+------<o:p></o:p>

--------+----------------+--------------- ----+--------=
--------+<o:p></o:p>

|
sequenceID &nb=
sp; &nbs=
p;
| lastMessageNumber | closed | creat<o:p></o:p>

ionTime | lastAccessTime | inactivityTimeout |
expirationTime |<o:p></o:p>

+---------------------------------------- ---+---------=
----------+--------+------<o:p></o:p>

--------+----------------+--------------- ----+--------=
--------+<o:p></o:p>

| uuid:3BADFD00-C692-D46C-193A-E511ED7E9453 | =
 &=
nbsp; 0
| 0 | =
115<o:p></o:p>

8085128 | 1158085695
| 86400000
| =

0 |<o:p></o:p>

+---------------------------------------- ---+---------=
----------+--------+------<o:p></o:p>

--------+----------------+--------------- ----+--------=
--------+<o:p></o:p>

1 row in set (0.21 sec)<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

Can someone please tell me if I am missing some =
settings
when using XAConnection or this seems like a bug with =
MySQL?<o:p></o:p>

<o:p> </o:p>

Thanks very much for any =
help!<o:p></o:p>

Sadhana<o:p></o:p>

</div>

</body>

</html>

------_=_NextPart_002_01C6D6B4.F71FE7A0--

------_=_NextPart_001_01C6D6B4.F71FE7A0
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org
------_=_NextPart_001_01C6D6B4.F71FE7A0--

Sadhana Jain wrote:
> Hi,
>
>
>
> I am using MySql latest server (5.0.24) and the
> mysql-connector-java-5.0.3-bin.jar driver.
>
>
>
> I am attaching the sample problem I wrote to isolate the bug. When using
> the XAConnection
>
> (setting testWithXA=true) and doing the insert into the table, the
> executeUpdate succeeds and returns 1 but
>
> Nothing gets written to the table.
>
>
>
> When using non-XA connection (setting testWithXA=false), the entry gets
> inserted into the table fine.
>
>
>
> The output of the program with XA (or non-XA):
>
>
>
> URL string is:jdbc:mysql://localhost:3306/test
>
> UserId: root Password: password
>
> XAConnection Successful!
>
> Connection successful!
>
> 1 -> uuid:3BADFD00-C692-D46C-193A-E511ED7E9453
>
> 2 -> 1158085128
>
> 3 -> 0
>
> 4 -> 86400000
>
> 5 -> 1158085695
>
> num rows written =1
>
>
>
> Using command line client (when XA):
>
> mysql> select * from SequenceHistory;
>
> Empty set (0.00 sec)
>
>
>
> Using command line client (when non XA):
>
> mysql> select * from SequenceHistory;
>
> +-------------------------------------------+--------------- ----+--------+------
>
> --------+----------------+-------------------+-------------- --+
>
> | sequenceID | lastMessageNumber | closed
> | creat
>
> ionTime | lastAccessTime | inactivityTimeout | expirationTime |
>
> +-------------------------------------------+--------------- ----+--------+------
>
> --------+----------------+-------------------+-------------- --+
>
> | uuid:3BADFD00-C692-D46C-193A-E511ED7E9453 | 0 | 0
> | 115
>
> 8085128 | 1158085695 | 86400000 | 0 |
>
> +-------------------------------------------+--------------- ----+--------+------
>
> --------+----------------+-------------------+-------------- --+
>
> 1 row in set (0.21 sec)
>
>
>
>
>
> Can someone please tell me if I am missing some settings when using
> XAConnection or this seems like a bug with MySQL?
>
>
>
> Thanks very much for any help!
>
> Sadhana
>
>
> ------------------------------------------------------------ ------------
>
>

Hi Sadhana.

Can you please provide small but complete java test case demonstrating
this problem? I would also like to know more of your environment.

--
Tonci Grgin, Support Engineer
MySQL AB, Croatia, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org

Hi Tonci,

I later found that it's not a bug in MySql. The problem I was seeing
(for the case when I am not using global transaction) was due to the
fact that auto commit was set to false because I was using XAConnection
to get the Connection object but I didn't have to use XAConnection in
this case (when not in global transaction).

A. Works.

DataSource ds =3D (DataSource) createXADataSource();
Connection conn =3D ds.getConnection();
System.out.println("auto commit value =3D"+conn.getAutoCommit());

The auto commit value is set to true in this case and the insert into
the table worked fine after this.

However, if I was using:
B. Doesn't work.

XADataSource xds =3D createXADataSource();
XAConnection xconn =3D xds.getXAConnection();
Connection conn =3D xconn.getConnection();
System.out.println("auto commit value =3D"+conn.getAutoCommit());

The auto commit value is set to false. And the insert into the table
didn't happen.

I am using Case A now and it works fine.
Thanks for your reply.

Hope this helps.
Sadhana

-----Original Message-----
From: Tonci Grgin [mailto:tonci [at] mysql.com]
Sent: Friday, September 15, 2006 2:46 AM
To: Sadhana Jain
Cc: bugs [at] lists.mysql.com
Subject: Re: problem doing insert into a table when using XAConnection

Sadhana Jain wrote:
> Hi,
>
>
>
> I am using MySql latest server (5.0.24) and the
> mysql-connector-java-5.0.3-bin.jar driver.
>
>
>
> I am attaching the sample problem I wrote to isolate the bug. When
using
> the XAConnection
>
> (setting testWithXA=3Dtrue) and doing the insert into the table, the
> executeUpdate succeeds and returns 1 but
>
> Nothing gets written to the table.
>
>
>
> When using non-XA connection (setting testWithXA=3Dfalse), the entry
gets
> inserted into the table fine.
>
>
>
> The output of the program with XA (or non-XA):
>
>
>
> URL string is:jdbc:mysql://localhost:3306/test
>
> UserId: root Password: password
>
> XAConnection Successful!
>
> Connection successful!
>
> 1 -> uuid:3BADFD00-C692-D46C-193A-E511ED7E9453
>
> 2 -> 1158085128
>
> 3 -> 0
>
> 4 -> 86400000
>
> 5 -> 1158085695
>
> num rows written =3D1
>
>
>
> Using command line client (when XA):
>
> mysql> select * from SequenceHistory;
>
> Empty set (0.00 sec)
>
>
>
> Using command line client (when non XA):
>
> mysql> select * from SequenceHistory;
>
>
+-------------------------------------------+--------------- ----+-------
-+------
>
> --------+----------------+-------------------+-------------- --+
>
> | sequenceID | lastMessageNumber |
closed
> | creat
>
> ionTime | lastAccessTime | inactivityTimeout | expirationTime |
>
>
+-------------------------------------------+--------------- ----+-------
-+------
>
> --------+----------------+-------------------+-------------- --+
>
> | uuid:3BADFD00-C692-D46C-193A-E511ED7E9453 | 0 |
0
> | 115
>
> 8085128 | 1158085695 | 86400000 | 0 |
>
>
+-------------------------------------------+--------------- ----+-------
-+------
>
> --------+----------------+-------------------+-------------- --+
>
> 1 row in set (0.21 sec)
>
>
>
>
>
> Can someone please tell me if I am missing some settings when using
> XAConnection or this seems like a bug with MySQL?
>
>
>
> Thanks very much for any help!
>
> Sadhana
>
>
>
------------------------------------------------------------ ------------
>
>

Hi Sadhana.

Can you please provide small but complete java test case demonstrating
this problem? I would also like to know more of your environment.

--
Tonci Grgin, Support Engineer
MySQL AB, Croatia, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sadhana Jain wrote:
> Hi Tonci,
>
> I later found that it's not a bug in MySql. The problem I was seeing
> (for the case when I am not using global transaction) was due to the
> fact that auto commit was set to false because I was using XAConnection
> to get the Connection object but I didn't have to use XAConnection in
> this case (when not in global transaction).
>
> A. Works.
>
> DataSource ds = (DataSource) createXADataSource();
> Connection conn = ds.getConnection();
> System.out.println("auto commit value ="+conn.getAutoCommit());
>
> The auto commit value is set to true in this case and the insert into
> the table worked fine after this.
>
> However, if I was using:
> B. Doesn't work.
>
> XADataSource xds = createXADataSource();
> XAConnection xconn = xds.getXAConnection();
> Connection conn = xconn.getConnection();
> System.out.println("auto commit value ="+conn.getAutoCommit());
>
> The auto commit value is set to false. And the insert into the table
> didn't happen.
>
> I am using Case A now and it works fine.
> Thanks for your reply.
>
> Hope this helps.
> Sadhana

Hi Sadhana,

Just a clarification that auto-commit being disabled on an XAConnection
is by design (and is required by the JDBC specification).

-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFCucrtvXNTca6JD8RAn4kAKCzSYs/SVFT4SrhQLuDDpSj3h1SOgCg iQ2e
DBofwmwH4IvvQYWH/R1gV04=
=n3mz
-----END PGP SIGNATURE-----

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org

-----Original Message-----
From: Mark Matthews [mailto:mark [at] mysql.com]
Sent: Friday, September 15, 2006 10:47 AM
To: Sadhana Jain
Cc: tonci [at] mysql.com; bugs [at] lists.mysql.com
Subject: Re: problem doing insert into a table when using XAConnection

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sadhana Jain wrote:
> Hi Tonci,
>
> I later found that it's not a bug in MySql. The problem I was seeing
> (for the case when I am not using global transaction) was due to the
> fact that auto commit was set to false because I was using
XAConnection
> to get the Connection object but I didn't have to use XAConnection in
> this case (when not in global transaction).
>
> A. Works.
>
> DataSource ds =3D (DataSource) createXADataSource();
> Connection conn =3D ds.getConnection();
> System.out.println("auto commit value =3D"+conn.getAutoCommit());
>
> The auto commit value is set to true in this case and the insert into
> the table worked fine after this.
>
> However, if I was using:
> B. Doesn't work.
>
> XADataSource xds =3D createXADataSource();
> XAConnection xconn =3D xds.getXAConnection();
> Connection conn =3D xconn.getConnection();
> System.out.println("auto commit value =3D"+conn.getAutoCommit());
>
> The auto commit value is set to false. And the insert into the table
> didn't happen.
>
> I am using Case A now and it works fine.
> Thanks for your reply.
>
> Hope this helps.
> Sadhana

Hi Sadhana,

Just a clarification that auto-commit being disabled on an XAConnection
is by design (and is required by the JDBC specification).

-Mark
True. I realized that too that case B also works as expected (per the
spec) but didn't work in my situation.
Thanks,
Sadhana

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFCucrtvXNTca6JD8RAn4kAKCzSYs/SVFT4SrhQLuDDpSj3h1SOgCg iQ2e
DBofwmwH4IvvQYWH/R1gV04=3D
=3Dn3mz
-----END PGP SIGNATURE-----

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org

problem doing insert into a table when using XAConnection

Re: problem doing insert into a table when using XAConnection

RE: problem doing insert into a table when using XAConnection

Re: problem doing insert into a table when using XAConnection

RE: problem doing insert into a table when using XAConnection