Return-Path: 
 <user-return-12482-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 46861 invoked from network); 22 Jan 2009 01:05:15 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 22 Jan 2009 01:05:15 -0000
Received: (qmail 66882 invoked by uid 500); 22 Jan 2009 01:05:13 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 66863 invoked by uid 500); 22 Jan 2009 01:05:13 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 66850 invoked by uid 99); 22 Jan 2009 01:05:13 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jan 2009 17:05:13 -0800
X-ASF-Spam-Status: No, hits=2.6 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Jan 2009 01:05:05 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1LPnzv-0004J9-Vb
	for user@geronimo.apache.org; Wed, 21 Jan 2009 17:04:43 -0800
Message-ID: <21593721.post@talk.nabble.com>
Date: Wed, 21 Jan 2009 17:04:43 -0800 (PST)
From: bongosdude <bongosdude@gmail.com>
To: user@geronimo.apache.org
Subject: Re: deployment for MySQL XA.
In-Reply-To: <21576868.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: bongosdude@gmail.com
References: <21536125.post@talk.nabble.com>
 <D4C0B92D-24F8-4D35-98D2-FB8F221BF1EB@yahoo.com>
 <21550948.post@talk.nabble.com> <21552390.post@talk.nabble.com>
 <21554366.post@talk.nabble.com>
 <432b67430901191912j6671d50dnd7902e2b1eb8afb6@mail.gmail.com>
 <21575677.post@talk.nabble.com> <21576238.post@talk.nabble.com>
 <21576868.post@talk.nabble.com>
X-Virus-Checked: Checked by ClamAV on apache.org


Today I tried the embeded but when I build the datasource using maven, I got
this error:

You are requesting xa transaction support for a connector that supports only
local transactions: named: my_users_xads

Below is my Pom:

<?xml version="1.0"?>
<!--
    Licensed to the Apache Software Foundation (ASF) under one
    or more contributor license agreements.  See the NOTICE file
    distributed with this work for additional information
    regarding copyright ownership.  The ASF licenses this file
    to you under the Apache License, Version 2.0 (the
    "License"); you may not use this file except in compliance
    with the License.  You may obtain a copy of the License at
    
     http://www.apache.org/licenses/LICENSE-2.0
    
    Unless required by applicable law or agreed to in writing,
    software distributed under the License is distributed on an
    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
    KIND, either express or implied.  See the License for the
    specific language governing permissions and limitations
    under the License.
-->
<!-- $Rev: 696424 $ $Date: 2008-09-17 16:05:05 -0400 (Wed, 17 Sep 2008) $
-->

<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
http://maven.apache.org/maven-v4_0_0.xsd">

    <modelVersion>4.0.0</modelVersion>
    
    <parent>
   		<groupId>com.abc.ipservices</groupId>
        <artifactId>myipservices</artifactId>
        <version>0.0.1-SNAPSHOT</version>
    </parent>

    <artifactId>abc-datasource</artifactId>
    <name>datasource</name>
    <packaging>car</packaging>

    <description>datasource plan</description>

    <dependencies>
        <dependency>
            <groupId>org.tranql</groupId>
            <artifactId>tranql-connector-mysql-xa</artifactId>
            <type>rar</type>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.tranql</groupId>
            <artifactId>tranql-connector-mysql-local</artifactId>
            <type>rar</type>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.tranql</groupId>
            <artifactId>tranql-connector-ra</artifactId>
            <type>rar</type>
            <scope>provided</scope>
        </dependency>

        
        <dependency>
            <groupId>org.apache.geronimo.framework</groupId>
            <artifactId>geronimo-gbean-deployer</artifactId>
            <type>car</type>
            <version>${geronimoVersion}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.geronimo.configs</groupId>
            <artifactId>j2ee-deployer</artifactId>
            <type>car</type>
            <version>${geronimoVersion}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.geronimo.configs</groupId>
            <artifactId>connector-deployer</artifactId>
            <type>car</type>
            <version>${geronimoVersion}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.geronimo.configs</groupId>
            <artifactId>system-database</artifactId>
            <type>car</type>
            <version>${geronimoVersion}</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.geronimo.buildsupport</groupId>
                <artifactId>car-maven-plugin</artifactId>
                <configuration>
                    <deploymentConfigs>
                       
<deploymentConfig>${gbeanDeployer}</deploymentConfig>
                        <deploymentConfig>${j2eeDeployer}</deploymentConfig>
                       
<deploymentConfig>${connectorDeployer}</deploymentConfig>
                    </deploymentConfigs>
                    
                    <module>
                        <groupId>org.tranql</groupId>
                        <artifactId>tranql-connector-mysql-xa</artifactId>
                        <type>rar</type>
                    </module>
                    
                    <module>
                        <groupId>org.tranql</groupId>
                       
<artifactId>tranql-connector-mysql-local</artifactId>
                        <type>rar</type>
                    </module>
                    
                    
                    <module>
                        <groupId>org.tranql</groupId>
                        <artifactId>tranql-connector-ra</artifactId>
                        <type>rar</type>
                    </module>

                     
                    <useMavenDependencies>
                        <value>true</value>
                        <includeVersion>true</includeVersion>
                    </useMavenDependencies>
                    <category>Sample</category>
                    <instance>
                        <plugin-artifact>
                        </plugin-artifact>
                    </instance>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

and this is my plan.xml

<?xml version="1.0" encoding="UTF-8"?>

<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">


    <dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">

        <dep:dependencies>
            <dep:dependency>
                <dep:groupId>mysql</dep:groupId>
                <dep:artifactId>mysql-connector-java</dep:artifactId>
                <dep:version>5.1.7</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
                        
            <dep:dependency>
                <dep:groupId>com.microsoft</dep:groupId>
                <dep:artifactId>mssql2005</dep:artifactId>
                <dep:version>1.2</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>            
            
        </dep:dependencies>
    </dep:environment> 

    
	<resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
               
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>mynuvoip</name>
                    <config-property-setting
name="UserName">sa</config-property-setting>
                    <config-property-setting
name="Password">vppd123$</config-property-setting>
                    <config-property-setting
name="Driver">com.microsoft.sqlserver.jdbc.SQLServerDriver</config-property-setting>
                    <config-property-setting
name="ConnectionURL">jdbc:sqlserver://localhost:1433;databaseName=dgtalk</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>5</max-size>
                            <min-size>0</min-size>
                           
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                            <idle-timeout-minutes>15</idle-timeout-minutes>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>    
    
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
               
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>callingcard_users_notx</name>
                    <config-property-setting
name="Password">josso123$</config-property-setting>
                    <config-property-setting
name="connectionURL">jdbc:mysql://localhost:3306/my_users</config-property-setting>
                    <config-property-setting
name="UserName">josso</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>

    
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
               
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>callingcard_users_xads</name>
                    
                    <config-property-setting
name="Password">josso123$</config-property-setting>
                    <config-property-setting
name="connectionURL">jdbc:mysql://localhost:3306/my_users</config-property-setting>
                    <config-property-setting
name="UserName">josso</config-property-setting>                   
                    
                    <connectionmanager>
                        <xa-transaction>
                            <transaction-caching/>
                        </xa-transaction>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>    
    

</connector>



Forrest_Xia wrote:
> 
> Seems you have a wrong DNS setting, you can try as follows:
> 1. Check your /etc/hosts to see what ip is mapped to your localhost
> 2. Try ping localhost
> 


-----
B Amigo:super:
-- 
View this message in context: http://www.nabble.com/deployment-for-MySQL-XA.-tp21536125s134p21593721.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.