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