Auto-reply: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2

[ORAPOST]

Bonjour, En cas d'urgence, vous pouvez contacter mon assistante St�phanie Vikar. T�l: 01.47.62.23.24 - e-mail: st�[EMAIL PROTECTED] Cordialement, -- Philippe ELINCK Oracle +33 1 47 62 29 28 +33 6 07 34 06 08 [EMAIL PROTECTED] Votre acc�s privil�gi� � l'information technologique d'Oracle Your definitive source for Oracle technical information Oracle Technology Network http://technet.oracle.com/

---

I'm trying to get the Java Pet Store 1.1.2 working with Cloudscape in Orion
1.5.2, and it is failing to get a connection from the datasource in
PopulateServlet. I have managed to obtain a connection using the
DriverManager, after modifying PopulateServlet.

This is the exception which I captured from getDBConnection on
datasource.getConnection():

2001-Aug-21 18:31:05 31145 ERROR  [ApplicationServerThread]
com.sun.j2ee.bluepri
nts.tools.populate.web.PopulateServlet  -
java.sql.SQLException: The database driver
(COM.cloudscape.core.RmiJdbcDriver@31
36e5) returned refusing to connect to the URL
jdbc:rmi://localhost:1099/jdbc:clo
udscape:CloudscapeDB;create=true
        at com.evermind.sql.DriverManagerDataSource.getConnection(Unknown
Source
)
        at
com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.getDBConne
ction(PopulateServlet.java:380)
        at
com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.checkConne
ction(PopulateServlet.java:192)
        at
com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.doGet(Popu
lateServlet.java:138)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:195)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
        at com.evermind._cxb._abe(Unknown Source)
        at com.evermind._cxb._uec(Unknown Source)
        at com.evermind._io._twc(Unknown Source)
        at com.evermind._io._gc(Unknown Source)
        at com.evermind._if.run(Unknown Source)

and this is the line which is failing:

            if (datasource != null) dbConnection =
datasource.getConnection();

Has anyone managed to get jps 1.1.2 working using Cloudscape? What am I
missing here? I'm running with jdk1.3.1, the data sources are below.
Cloudscape is from j2sdkee1.3 beta 2.

data-sources.xml:

<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd";>

<data-sources>
        <!--
                An example/default DataSource that uses an ordinary
                JDBC-driver (in this case hsql) to create the connections.
                This tag creates all the needed kinds
                of data-sources, transactional, pooled and EJB-aware
sources.
                The source generally used in application code is the "EJB"
                one - it provides transactional safety and connection
pooling.
        -->
        <!--
        <data-source
                class="com.evermind.sql.DriverManagerDataSource"
                name="Hypersonic"
                location="jdbc/HypersonicCoreDS"
                xa-location="jdbc/xa/HypersonicXADS"
                ejb-location="jdbc/HypersonicDS"
                connection-driver="org.hsql.jdbcDriver"
                username="sa"
                password=""
                url="jdbc:HypersonicSQL:./database/defaultdb"
                inactivity-timeout="30"
        />
        -->

        <!-- Java Pet Store - Cloudscape -->

        <data-source
        class="com.evermind.sql.DriverManagerDataSource"
        name="EstoreDB"
        location="jdbc/EstoreDataSource"
        xa-location="jdbc/xa/EstoreXADS"
        ejb-location="jdbc/EstoreDB"
                connection-driver="COM.cloudscape.core.RmiJdbcDriver"
                username="estoreuser"
                password="estore"
        
url="jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true"
                inactivity-timeout="30"
        />

        <data-source
                class="com.evermind.sql.DriverManagerDataSource"
        name="InventoryDB"
        location="jdbc/InventoryDataSource"
        xa-location="jdbc/xa/InventoryXADS"
        ejb-location="jdbc/InventoryDB"
                connection-driver="COM.cloudscape.core.RmiJdbcDriver"
                username="estoreuser"
                password="estore"
        
url="jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true"
                inactivity-timeout="30"
        />

        <data-source
                class="com.evermind.sql.DriverManagerDataSource"
        name="SignOnDB"
        location="jdbc/SignOnDataSource"
        xa-location="jdbc/xa/EstoreXADS"
        ejb-location="jdbc/EstoreDB"
                connection-driver="COM.cloudscape.core.RmiJdbcDriver"
                username="estoreuser"
                password="estore"
        
url="jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true"
                inactivity-timeout="30"
        />
</data-sources>

Thanks

Andrew Harris
[EMAIL PROTECTED]




********************************************************************************************
" This message contains information that may be privileged or confidential and 
is the property of the Cap Gemini Ernst & Young Group. It is intended only for 
the person to whom it is addressed. If you are not the intended recipient, you 
are not authorized to read, print, retain, copy, disseminate, distribute, or use 
this message or any part thereof. If you receive this message in error, please 
notify the sender immediately and delete all copies of this message ".
********************************************************************************************

---