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:55555/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:55555/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:55555/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:55555/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:55555/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.