Return-Path: 
 <user-return-12450-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 62893 invoked from network); 20 Jan 2009 00:00:37 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Jan 2009 00:00:37 -0000
Received: (qmail 37564 invoked by uid 500); 20 Jan 2009 00:00:36 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 37060 invoked by uid 500); 20 Jan 2009 00:00:36 -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 37051 invoked by uid 99); 20 Jan 2009 00:00:36 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Jan 2009 16:00:36 -0800
X-ASF-Spam-Status: No, hits=4.1 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WEIRD_PORT,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.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; Tue, 20 Jan 2009 00:00:26 +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 1LP42H-0007xU-RP
	for user@geronimo.apache.org; Mon, 19 Jan 2009 16:00:05 -0800
Message-ID: <21554366.post@talk.nabble.com>
Date: Mon, 19 Jan 2009 16:00:05 -0800 (PST)
From: bongosdude <bongosdude@gmail.com>
To: user@geronimo.apache.org
Subject: Re: deployment for MySQL XA.
In-Reply-To: <21552390.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>
X-Virus-Checked: Checked by ClamAV on apache.org


Hi

I added this MS SQL resourceadapter into my datasource plan

<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">xxxxxx</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=dtalk</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> 

When I tried to deploy my plugin to geronimo, it complaints that I did see
MS SQL driver: com.microsoft.sqlserver.jdbc.SQLServerDriver. I have
installed MS SQL jar file to geronimo repostitory. What setting should I put
in plan.xml to tell the deployer get the driver from geronimo repository?

Thanks
-B

Caused by: org.apache.geronimo.gbean.InvalidConfigurationException:
Configuration
com.myvoip.ipservices/callingcard-datasource/0.0.1-SNAPSHOT/car failed to
start due to the following reasons:
  The service
J2EEApplication=null,JCAConnectionFactory=mynuvoip,JCAResource=com.myvoip.ipservices/callingcard-datasource/0.0.1-SNAPSHOT/car,ResourceAdapter=com.myvoip.ipservices/callingcard-datasource/0.0.1-SNAPSHOT/car,ResourceAdapterModule=com.myvoip.ipservices/callingcard-datasource/0.0.1-SNAPSHOT/car,j2eeType=JCAManagedConnectionFactory,name=mynuvoip
did not start because Unable to load driver class:
com.microsoft.sqlserver.jdbc.SQLServerDriver



-B


bongosdude wrote:
> 
> I have put your suggestions into my plan.xml. but maven still complains?
> 
> <?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:moduleId>
>             <dep:groupId>console.dbpool</dep:groupId>
>             <dep:artifactId>my_users</dep:artifactId>
>             <dep:version>1.0</dep:version>
>             <dep:type>rar</dep:type>
>         </dep:moduleId>
>         <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:dependencies>
>     </dep:environment>
>     
>     <resourceadapter>
>         <outbound-resourceadapter>
>             <connection-definition>
>                
> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>                 <connectiondefinition-instance>
>                     <name>callingcard_users</name>
>                     <config-property-setting
> name="Password">josso123$</config-property-setting>
>                     <config-property-setting
> name="connectionURL">http://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>
> 
> 1. Maven complains that the attribute DatabaseName is not valid, I have to
> change to connectionURL
> 2. Where does it look to find out if the driver is XA or not?
> 3. I tried to put in the node <ext-module>, maven erred out with message,
> <ext-module> is not valid node 
> 
> Thanks
> -B
> 
> 
> bongosdude wrote:
>> 
>> David,
>> 
>> I could not figure out how to copy the plan out of the dbpool wizard. Can
>> you show me the steps?
>> 
>> -B
>> 
>> 
>> djencks wrote:
>>> 
>>> The easiest way is to use the admin console database wizard.  You can  
>>> copy the plan out of the wizard to put into your plan.xml source.  You  
>>> can duplicate the xa pool and change the tx element to <no- 
>>> transaction> for the non-jta datasource
>>> 
>>> thanks
>>> david jencks
>>> 
>>> On Jan 18, 2009, at 6:47 PM, bongosdude wrote:
>>> 
>>>>
>>>> Can someone show me how to create deployment plan for MySQL XA  
>>>> datasource?
>>>> How is about MS SQL (local transaction)
>>>>
>>>> Thanks
>>>> -B
>>>>
>>>> -----
>>>> B Amigo:super:
>>>> -- 
>>>> View this message in context:
>>>> http://www.nabble.com/deployment-for-MySQL-XA.-tp21536125s134p21536125.html
>>>> Sent from the Apache Geronimo - Users mailing list archive at  
>>>> Nabble.com.
>>>>
>>> 
>>> 
>>> 
>> 
>> 
> 
> 


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