Re: Trouble with Rmi-Cloudscape from Orion
Hi Ishpal, Have you defined a datasource in datasources.xml that looks something like this? data-source class="com.evermind.sql.DriverManagerDataSource" name="Cloudscape" location="jdbc/CloudscapeCoreDS" xa-location="jdbc/xa/CloudscapeDS" ejb-location="jdbc/CloudscapeDS" connection-driver="RmiJdbc.RJDriver" username="" password="" url="jdbc:rmi://ishpal2:5/jdbc:cloudscape:HelloWorldDB;create=true;autocommit=false" inactivity-timeout="30" schema="database-schemas/cloudscape.xml" / Ishpal wrote: Hi, I'm having trouble connecting to cloudscape database from orion. Using the same driver, host and the port I can connect to the Cloudscape using RmiJdbcDriver from an application running in a different JVM, but when I try the same from orion I get an error like Auto-deploying hello-ejb... SQL error: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Warning: Error creating table: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Its driving me nuts... Is there some kind of setting to be done in some xml file in orion...??? I have to get this thing up or I might be forced to try with other products... please help Ishpal.
Re: Trouble with Rmi-Cloudscape from Orion
Thanks a lot Wim,
you got the problem by the hook..
I was using the wrong driver.
My application connects to the database with the following code...
Class.forName("COM.cloudscape.core.RmiJdbcDriver").newInstance();
Connection conn =
DriverManager.getConnection("jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;autocommit=false");
And (now) my datasource in datatsources.xml is as...
data-source
name="DefaultDS"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:rmi://localhost:5/jdbc:cloudscape:HelloWorldDB;autocommit=false"
connection-driver="RmiJdbc.RJDriver"
inactivity-timeout="20"
username=""
password=""
schema="database-schemas/cloudscape.xml"
/
The drivers to connect to the database are different , but now I can
connect to the database.
Thanks (once again).
-Ishpal.
wim veninga wrote:
Hi Ishpal,
Have you defined a datasource in datasources.xml that looks something like
this?
data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Cloudscape"
location="jdbc/CloudscapeCoreDS"
xa-location="jdbc/xa/CloudscapeDS"
ejb-location="jdbc/CloudscapeDS"
connection-driver="RmiJdbc.RJDriver"
username=""
password=""
url="jdbc:rmi://ishpal2:5/jdbc:cloudscape:HelloWorldDB;create=true;autocommit=false"
inactivity-timeout="30"
schema="database-schemas/cloudscape.xml"
/
Ishpal wrote:
Hi,
I'm having trouble connecting to cloudscape database from orion.
Using the same driver, host and the port I can connect to the Cloudscape
using RmiJdbcDriver from an application running in a different JVM, but
when I try the same from orion I get an error like
Auto-deploying hello-ejb... SQL error: The database driver
(COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect
to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true
Warning: Error creating table: The database driver
(COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect
to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true
Its driving me nuts...
Is there some kind of setting to be done in some xml file in orion...???
I have to get this thing up or I might be forced to try with other
products...
please help
Ishpal.
Re: Trouble with Rmi-Cloudscape from Orion
Hi Ishpal,
Does cloudscape has rmijdbc in cloudscape.jar ?
I always use rmijdbc.jar and cloudscape.jar to gether and also the
url is different.
What version of cloudscape do you use ?
Thanks in advance,
Greetings Wim Veninga
Ishpal wrote:
Thanks a lot Wim,
you got the problem by the hook..
I was using the wrong driver.
My application connects to the database with the following code...
Class.forName("COM.cloudscape.core.RmiJdbcDriver").newInstance();
Connection conn =
DriverManager.getConnection("jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;autocommit=false");
And (now) my datasource in datatsources.xml is as...
data-source
name="DefaultDS"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:rmi://localhost:5/jdbc:cloudscape:HelloWorldDB;autocommit=false"
connection-driver="RmiJdbc.RJDriver"
inactivity-timeout="20"
username=""
password=""
schema="database-schemas/cloudscape.xml"
/>
The drivers to connect to the database are different , but now I can
connect to the database.
Thanks (once again).
-Ishpal.
wim veninga wrote:
>
> Hi Ishpal,
>
> Have you defined a datasource in datasources.xml that looks something
like
> this?
>
> data-source
> class="com.evermind.sql.DriverManagerDataSource"
> name="Cloudscape"
> location="jdbc/CloudscapeCoreDS"
> xa-location="jdbc/xa/CloudscapeDS"
> ejb-location="jdbc/CloudscapeDS"
> connection-driver="RmiJdbc.RJDriver"
> username=""
> password=""
> url="jdbc:rmi://ishpal2:5/jdbc:cloudscape:HelloWorldDB;create=true;autocommit=false"
>
> inactivity-timeout="30"
> schema="database-schemas/cloudscape.xml"
> />
>
> Ishpal wrote:
>
> > Hi,
> >
> > I'm having trouble connecting to cloudscape database from orion.
> >
> > Using the same driver, host and the port I can connect to the Cloudscape
> > using RmiJdbcDriver from an application running in a different
JVM, but
> > when I try the same from orion I get an error like
> >
> > Auto-deploying hello-ejb... SQL error: The database driver
> > (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to
connect
> > to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true
> > Warning: Error creating table: The database driver
> > (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to
connect
> > to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true
> >
> > Its driving me nuts...
> >
> > Is there some kind of setting to be done in some xml file in orion...???
> > I have to get this thing up or I might be forced to try with other
> > products...
> >
> > please help
> > Ishpal.
Trouble with Rmi-Cloudscape from Orion
Hi, I'm having trouble connecting to cloudscape database from orion. Using the same driver, host and the port I can connect to the Cloudscape using RmiJdbcDriver from an application running in a different JVM, but when I try the same from orion I get an error like Auto-deploying hello-ejb... SQL error: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Warning: Error creating table: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Its driving me nuts... Is there some kind of setting to be done in some xml file in orion...??? I have to get this thing up or I might be forced to try with other products... please help Ishpal.
