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] ==
===========================================================================

Reply via email to