On Wed, 6 Jan 1999, Ing. Conrado Miguel Rodr?guez Fern?ndez wrote:
> 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.
What version of the driver are you using?
Last week, I posted an updated driver to the postgresql site, that fixed a
few problems, and included JDK1.2 support.
I should be posting another update later this weekend.
> 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
I haven't tried JDBC:RMI before. I'd be interested in knowing how well it
goes.
> 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:
Is this exception being thrown on the RMI server or on the RMI client?
> [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.
Hmmm, if the Exception is being thrown on the client, then I'd think it's
the RMI driver that's not being found, rather than PostgreSQL.
--
Peter T Mount [EMAIL PROTECTED]
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
