Try to use these:
connection-driver="RmiJdbc.RJDriver"
url="jdbc:rmi://localhost:1099/jdbc:cloudscape:defaultDB"
I checked it a half a year ago and it worked just fine.
(don't forget to change url defaultDB )
-----Original Message-----
From: Harris, Andrew S [SMTP:[EMAIL PROTECTED]]
Sent: ? 21 ?????? 2001 20:26
To: Orion-Interest
Subject: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2
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
".
****************************************************************************
****************
