Mailing-List: contact kandula-dev-help@ws.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (asf.osuosl.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=NYmZ3mPkkUWgsIu7F+mSP2CnpnXAW7p9/FSCuVRnCQZ9csctAtWE5q+Y4tQzIX6r1WVYFSmHnHeWr7TjWVBWYblBwB/SwylpgZ+EGKuNr1SewOs0SjlCTJsGRvob5wi5nX0VGRR12dioHAIvGmZPc1k20t8ug/IbWfGe396DnpA=
  ;
Message-ID: <20060209021151.14756.qmail@web15403.mail.cnb.yahoo.com>
Date: Thu, 9 Feb 2006 10:11:51 +0800 (CST)
From: Jack Wang <pipashu@yahoo.com>
Subject: Re: XADataSource error in tomcat 5.5 with MySQL 5.1
To: user@geronimo.apache.org
Cc: kandula-dev@ws.apache.org
In-Reply-To: <Pine.BSO.4.58.0602080823070.11@ida.bway.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=gb2312
Content-Transfer-Encoding: 8bit

--- lichtner <lichtner@bway.net>д��:
> 
> Does this version of Connector/J actually support XA? A few months ago I
> remember that it was in alpha, and it was broken. Does the latest release
> of the driver support XA?

--- "Christopher G. Stach II" <cgs@ldsys.net>д��:
> 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 mysql-connector-java-5.0.0-beta's
> com.mysql.jdbc.jdbc2.optional.MysqlXADataSource with a MySQL 5.0 server,
> or the far less desirable XAPool for fake XA.
> 

I have used mysql-connector-java-5.0.0-beta, but I still have the null XADataSource xaDs from the
java action.
Here is the server.xml in tomcat:

-------------------------------------------------
<Resource name="jdbc/myXADB" auth="Container" 
  type="javax.sql.XADataSource"
  factory="com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory"
  driverClassName="com.mysql.jdbc.Driver"
  user="root"
  password="password"
  url="jdbc:mysql://localhost/test?useUnicode=true&amp;characterEncoding=gbk"
/>
-------------------------------------------------

And the is my action:

-------------------------------------------------
Context ctx = new InitialContext();
XADataSource xaDs = (XADataSource)ctx.lookup("java:comp/env/jdbc/myXADB");
// Here get the null xaDs, Oops !!
-------------------------------------------------

My environment is :
 JDK 1.5
 Tomcat 5.5
 MySQL: 5.0.18-win32
 Connector/J 5.0 beta

I have checked mysql-connector-java-5.0.0-beta changes. The 11-04-05 - Version 5.0.0-beta
- XADataSource implemented (ported from 3.2 branch which won't be 
  released as a product). 
  Use "com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" as your datasource
  class name in your application server to utilize XA transactions
  in MySQL-5.0.10 and newer.

So, what's the wrong ? Please help. Thanks.


Wang Jun


___________________________________________________________ 
�Ż�1G�������ٷְٷ������� 
http://cn.mail.yahoo.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: kandula-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: kandula-dev-help@ws.apache.org