Return-Path: 
 <user-return-61-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 36285 invoked from network); 30 Aug 2004 08:15:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 30 Aug 2004 08:15:03 -0000
Received: (qmail 60984 invoked by uid 500); 30 Aug 2004 08:15:02 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 60970 invoked by uid 500); 30 Aug 2004 08:15:01 -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
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 60955 invoked by uid 99); 30 Aug 2004 08:15:01 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of sai.arunachalam@gmail.com
 designates 64.233.170.206 as permitted sender)
Received: from [64.233.170.206] (HELO mproxy.gmail.com) (64.233.170.206)
  by apache.org (qpsmtpd/0.27.1) with ESMTP; Mon, 30 Aug 2004 01:14:59 -0700
Received: by mproxy.gmail.com with SMTP id 77so64902rnl
        for <user@geronimo.apache.org>; Mon, 30 Aug 2004 01:14:57 -0700 (PDT)
Received: by 10.38.3.57 with SMTP id 57mr843790rnc;
        Mon, 30 Aug 2004 01:14:57 -0700 (PDT)
Received: by 10.38.171.45 with HTTP; Mon, 30 Aug 2004 01:14:57 -0700 (PDT)
Message-ID: <645d1db104083001144129ad18@mail.gmail.com>
Date: Mon, 30 Aug 2004 13:44:57 +0530
From: Sai Arunachalam <sai.arunachalam@gmail.com>
Reply-To: Sai Arunachalam <sai.arunachalam@gmail.com>
To: user@geronimo.apache.org
Subject: Re: JDBCDataSource in Geronimo
In-Reply-To: <412FB178.3060506@optusnet.com.au>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <645d1db104082711427a7da5fc@mail.gmail.com>
 <412FB178.3060506@optusnet.com.au>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Gianny (and all), 
      I am having a problem in making cloudscape work. I think it's
rather my configuration with geronimo-ra.xml that is playing the
mischief. (Recap: I am trying to port the PetStore that was there on
WebLogic6.1 to Geronimo. WebLogic6.1 has it's own config.xml that has
a few tags and attributes that I have to communicate using the
geronimo-ra.xml). The scenario is as follows:

The weblogic petstore app has a number of ejbs with each one having a
weblogic-ejb-jar.xml like the following (this one corresponds to
openejb-jar.xml on Geronimo).
...
<reference-descriptor>
      <reference-description>
             <res-ref-name>jdbc/EstoreDataSource</res-ref-name>
                   <jndi-name>jdbc.EstoreDB</jndi-name>
      </reference-description>
</reference-descriptor>
.... 
That is the case for a number of EJBs there.

Then there is a config.xml file that has the following properties:
...
<JDBCConnectionPool CapacityIncrement="1"
DriverName="COM.cloudscape.core.JDBCDriver" InitialCapacity="1"
MaxCapacity="1" Name="petstorepool" Properties="user=none;
password=none;server=none" Targets="petStoreServer"
URL="jdbc:cloudscape:petStore"/>
...
<JDBCDataSource JNDIName="jdbc.SignOnDB" Name="SignOnDB"
PoolName="petStorePool" Targets="petStoreServer"/>
<Realm FileRealm="myFileRealm" Name="myRealm"/>
<JDBCDataSource JNDIName="jdbc.InventoryDB" Name="InventoryDB"
PoolName="petStorePool" Targets="petStoreServer"/>
<JDBCDataSource JNDIName="jdbc.EstoreDB" Name="EstoreDB"
PoolName="petStorePool" Targets="petStoreServer"/>
...

Now I wanted to make this app run with Cloudscape. So I did the following:
I took the cloudscape jars (cloudscape.jar, tools.jar, client.jar and
four more...)
I checked out the latest version of TranQL from
http://cvs.tranql.codehaus.org/connector, built it to get the rar
file. Opened the rar file, removed the axion jars, put the cloudscape
jars there. Then I made the following changes to
META-INF/geronimo-ra.xml

1. configId="org/tranql/connector/axion" ->
configId="org/tranql/connector/cloudscape"
2. Then I changed the following:
     <connectiondefinition-instance>
               <name>DefaultDatasource</name>
      ....

to
     <connectiondefinition-instance>
               <name>jdbc.EstoreDB</name>
      ....
3.  <config-property-setting
name="JdbcDriver">org.axiondb.jdbc.AxionDriver</config-setting-name>
to
    <config-property-setting
name="JdbcDriver">COM.cloudscape.core.JDBCDriver</config-property-setting>

4. <config-property-setting
name="JdbcUrl">jdbc:axiondb:DefaultDatabase</config-property-setting>
to
   <config-property-setting
name="JdbcUrl">jdbc:cloudscape:EstoreDB</config-property-setting>
    
   [In some of the geronimo-ra.xml's that I saw, the attribute name
inside here was ConnectionURL instead of JdbcUrl. Does this matter?
Besides, how do I specify the other two DBs namely InventoryDB and
SignOnDB? Should I simply replicate the tags in the same fle or is
there a different way to do it? ]

Rest of the properties, I left as they were in geronimo-ra.xml.

Now I tried deploying this rar file on geronimo and it got deployed
without any errors. When I ran petstore this time alongwith the
configId of both the things (petstore and tranql rar), it gave me a
long error. So I put the rar file inside the petstore.ear file and
redployed it and ran it this time. This time I gave only petstore's
configId on starting the server. It got started and I saw the first
page (index.html that has a link saying "enter the store"). When I
tried going to the next page by pressing the link, it says "Unable to
connect to database. Connection not open. Make sure the connection is
open").

I don't know where the error is... Just then I found the following
file in weblogic's petstore directory called estore_runtimeejb.xml
that has portions like the following for each of the ejbs..

<j2ee-ri-specific-information>
  <server-name></server-name>
  <rolemapping />

  <enterprise-beans>
    <ejb>
      <ejb-name>TheOrder</ejb-name>
      <jndi-name>estore/order</jndi-name>
      <resource-ref>
        <res-ref-name>jdbc/EstoreDataSource</res-ref-name>
        <jndi-name>jdbc/Cloudscape</jndi-name>
        <default-resource-principal>
          <name>estoreuser</name>
          <password>estore</password>
        </default-resource-principal>
      </resource-ref>
      <ejb-ref>
        <ejb-ref-name>ejb/account/Account</ejb-ref-name>
        <jndi-name>estore/account</jndi-name>
      </ejb-ref>
    </ejb>

.....

Does this have something to do with the problem?

There are two more things I wanna know related to this problem. When I
looked up the index.properties inside config-store for the already
deployed axion database, the configId is given as
org/apache/geronimo/DefaultDatabase whereas the geronimo-ra.xml gives
the configId as org/openejb/connector/axion. How is this?

And then, how exactly do I deploy a stand-alone geronimo-ra.xml?

Thanks a lot for your help. 

Thanks and regards,
Sai