It's possible that you got yourself an in-doubt transaction.
If you try it again from the mysql shell (i.e. type in your sql statement
yourself) and it says the same thing, then you may have in-doubt
transaction.
>
> Thanks. If I use MysqlDataSource, there is no problem. But my problem is
> how
Hi,
This "Lock wait timeout exceeded; try restarting transaction" problem
has nothing to do with XA. Basically, an update statement was being
executed. This statement was trying to update a row having a write lock,
e.g. another transaction was updating the same record. In this scenario,
the update
Thanks. If I use MysqlDataSource, there is no problem. But my problem is how to
use MySQL's XA in
tomcat environment. Who has this example? I have done a test to check MySQL
XA's function, but
the result is failed. So I wonder if MySQL has real XA to operate database.
Especial how to fix
"Lock
I have a simple jsp script that can lookup a server-wide datasource. In
the jsp, I don't have to specify the driver or make the connection. I only
need to perform the lookup (the following code in a try/catch block). The
Tranql resource adapter will take the configuration from the database
deplo
I'm very confused about what you are trying to do and why. Can you
back up and explain your overall strategy here?
I may not understand what you are trying to do but the following
comments might be relevant:
- the tomcat configuration files are mostly ignored in the tomcat
geronimo integ
Does MySQL5.0.18 suport XA in Tomcat 5.5 ? I do a XA test in tomcat with only a
jsp file and
necessary jars. The jsp is as:
-
<%
Context ctx = new InitialContext();
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource xads = new
com.mysql.jdbc.jdbc2.optiona
--- lichtner <[EMAIL PROTECTED]>写道:
>
> Anything in any logs? Maybe something is failing and this is a side
> effect?
>
There is no error message in logs. The web application is started normally. But
the
xaDs from "XADataSource xaDs =
(XADataSource)ctx.lookup("java:comp/env/jdbc/myXADB");" i
Anything in any logs? Maybe something is failing and this is a side
effect?
On Thu, 9 Feb 2006, Jack Wang wrote:
> --- lichtner <[EMAIL PROTECTED]>写道:
> >
> > Is it possible that the data source also has to be listed in your web.xml?
> >
>
> Yes, I have resource-ref defined in web.xml. But the X
--- lichtner <[EMAIL PROTECTED]>写道:
>
> Is it possible that the data source also has to be listed in your web.xml?
>
Yes, I have resource-ref defined in web.xml. But the XADataSource is null, why ?
jdbc/myXADB
javax.sql.XADataSource
Container
Shareable
> On Thu, 9 Feb 20
Is it possible that the data source also has to be listed in your web.xml?
On Thu, 9 Feb 2006, Jack Wang wrote:
>
> --- "Christopher G. Stach II" <[EMAIL PROTECTED]>写道:
> > Jack Wang wrote:
> > > I can get connect from Resource configured in tomcat with
> > > type="javax.sql.DataSource". But th
--- "Christopher G. Stach II" <[EMAIL PROTECTED]>写道:
> Jack Wang wrote:
> > I can get connect from Resource configured in tomcat with
> > type="javax.sql.DataSource". But the
> > project needs the XADataSource, so I configure the XADataSource in tomcat's
> > server.xml with
> You need to use mys
user@geronimo.apache.org
cc:
Subject: Re: XA support
[EMAIL PROTECTED] wrote:
> A driver-based connector cannot support XA?
>
The generic driver-based connector uses a java.sql.Driver to get a
java.sql.Connection which only supports local transactions; you c
the reason why you don't support xa for mysql.
Jeremy Boynes <[EMAIL PROTECTED]>
11/28/2005 10:34 PM
Please respond to user
To: user@geronimo.apache.org
cc:
Subject: Re: XA support
[EMAIL PROTECTED] wrote:
> A driver-based
[EMAIL PROTECTED] wrote:
> A driver-based connector cannot support XA?
>
The generic driver-based connector uses a java.sql.Driver to get a
java.sql.Connection which only supports local transactions; you can't
get the necessary XAConnection from a Driver.
The generic connector one fakes out XA s
A driver-based connector cannot support XA?
I don't know know enough about the issue to understand what you mean. I presume that you are
stating that in the context of JCA, but that if I create the xa data source myself then it does (I did, it does.)
Jeremy Boynes <[EMAIL PROTECTED]>
11/28
15 matches
Mail list logo
