I'm trying to distribute my PostgreSQL tables through JDBC:RMI. I have been using
the PostgreSQL JDBC driver from contrib.redhat. and it do it's job Ok.
The JDBC:RMI system has been also succesfully tested with the JDBC-ODBC
bridge. The problem arises when I try to connect to the SQL Server through
the following URL:
jdbc:rmi://horus/jdbc:postgresql:conrado
Where "jdbc:postgresql:conrado" is the URL for reaching my database through JDBC
(not RMI-JDBC) which has been tested, and the rest is required by RMI-JDBC (horus
is the server's name).
The execution gives the following messages:
java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at RmiJdbc.RJDriver.connect(RJDriver.java:136)
at java.sql.DriverManager.getConnection(DriverManager.java:91)
at java.sql.DriverManager.getConnection(DriverManager.java:134)
at TestClient.main(TestClient.java:34)
The RMI-JDBC documentation announces that "No suitable driver" means that the driver
is
not registerd but when you see the RMI-JDBC servers output it clearly shows:
[conrado@Horus tantra]$ java RmiJdbc.RJJdbcServer postgresql.Driver
postgresql.Driver registered in DriverManager
Binding RmiJdbcServer...
RmiJdbcServer bound in rmi registry
what means that the driver is recognized. I was thinking in a bug in the JDBC driver
but I think that the RMI-JDBC layer uses the driver as any other application.
Does anybody has a clue?
Thanks...
--
===========================================================================
== Ing. Conrado Rogr�guez Fern�ndez | Tel�fono: 45-4644 ext. 2170,2311 ==
== Analista de Sistemas. -+- Email: [EMAIL PROTECTED] ==
== ECASA S.A. | [EMAIL PROTECTED] ==
===========================================================================
JDBC:RMI --> JDBC --> PostgreSQL
Ing. Conrado Miguel Rodr?guez Fern?ndez Wed, 6 Jan 1999 17:01:09 -0500
- Re: JDBC:RMI --> JDBC --> Po... Ing. Conrado Miguel Rodr?guez Fern?ndez
- Re: JDBC:RMI --> JDBC --&g... Chris Abbey
- Re: JDBC:RMI --> JDBC --&g... Thomas Bocek
- Re: JDBC:RMI --> JDBC ... Peter T Mount
- Re: JDBC:RMI --> JDBC --&g... Peter T Mount
