Hello Peter,
sorry it does compile but won't start because of connection problemt to my
localhost. Has it something to do with the Portnumber a have not entered. If
yes, which can it be.
commsql is working fine.
Thanks Frank
F:\Downloads\RMI_JDBC>java TestClient
TestClient:jdbc:rmi://goal-pdc/jdbc:idb:F:/InstantDB/Examples/sample.prp
java.rmi.ConnectException: Connection refused to host: goal-pdc; nested
exceptio
n is:
java.net.ConnectException: Connection refused: no further
information
java.net.ConnectException: Connection refused: no further information
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:125)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:112)
at java.net.Socket.<init>(Socket.java:269)
at java.net.Socket.<init>(Socket.java:98)
at
sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirect
SocketFactory.java:29)
at
sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMaster
SocketFactory.java:124)
at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:497)
at
sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:194
at
sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:178)
at sun.rmi.server.UnicastRef.newCall(UnicastRef.java:322)
at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
at RmiJdbc.RJConnection.<init>(RJConnection.java:75)
at RmiJdbc.RJDriver.connect(RJDriver.java:131)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at TestClient.main(TestClient.java, Compiled Code)
java.sql.SQLException: Connection refused to host: goal-pdc; nested
exception is
:
java.net.ConnectException: Connection refused: no further
information
at RmiJdbc.RJDriver.connect(RJDriver.java:137)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at TestClient.main(TestClient.java, Compiled Code)
F:\Downloads\RMI_JDBC>
> -----Ursprüngliche Nachricht-----
> Von: owner-instantDB@enhydra.org [mailto:owner-instantDB@enhydra.org]Im
> Auftrag von Peter Hearty
> Gesendet am: Mittwoch, 26. Juli 2000 19:07
> An: instantDB@enhydra.org
> Betreff: Re: InstantDB: connection problems
>
> Frank
>
> When you say it doesn't compile, what error message do you get.
> If it's the
> code below then you need to comment out the
>
> file://String url = "jdbc:idb=sample.prp"; (geändert in)
>
> line. The commsql url you supplied should be OK. Again, though, I need to
> know what error message you're getting.
>
> Regards
>
> Peter Hearty
> Lutris Technologies UK Ltd.
> -----Original Message-----
> From: Frank Mirche <frank.mirche@netcologne.de>
> To: Instantdb <instantdb@enhydra.org>
> Date: 26 July 2000 18:33
> Subject: InstantDB: connection problems
>
>
> hello,
>
> i'm trying to test the rmi_jdbc sample below but it does not
> connect to the
> database and java will not compile the following syntax:
>
> file://String url = "jdbc:idb=sample.prp"; (changed to)
> String url = "jdbc:idb:F:/InstantDB/Examples/sample.prp";
>
> by the way..
> when i have to connect to a *.prp on a diffrent drive in commsql
> what is the correct syntax ??
> Enter the URL for the database:
> jdbc:idb:F:/InstantDB/Examples/sample.prp (does not work)
>
> Thanks Frank
>
>
>
> /**
> * RmiJdbc client/server JDBC Driver
> * (C) GIE Dyade (Groupe BULL / INRIA Research Center) 1997
> *
> * @version 1.0
> * @author Pierre-Yves Gibello (Pierre-Yves.Gibello@inrialpes.fr)
> */
>
> import java.sql.*;
> import java.net.InetAddress;
>
> /**
> * This is a sample program for RmiJdbc client/server jdbc Driver
> * RmiJdbc relies on Java RMI for jdbc objects distribution
> */
> public class TestClient {
>
> public static void main(String args[]) {
>
> try {
>
> // Register RmiJdbc Driver in jdbc DriverManager
> // The call to newInstance() is necessary on some platforms
> // (with some java VM implementations)
> Class.forName("RmiJdbc.RJDriver").newInstance();
>
> // Test with InstantDB free java database engine
> // See http://www.instantdb.co.uk for info & download
> file://String url = "jdbc:idb=sample.prp"; (geändert in)
> String url = "jdbc:idb:F:/InstantDB/Examples/sample.prp";
>
>
> // RMI host will point to local host
> // A port number may be specified as 1st argument to the program
>
> String portSpec = "";
> if(args.length > 0) {
> Integer.parseInt(args[0]); // Check port number is an integer
> portSpec = new String(":" + args[0]);
> }
>
> String rmiHost = new String(
> "//" + InetAddress.getLocalHost().getHostName() + portSpec);
>
> // RmiJdbc URL is of the form:
> // jdbc:rmi://<rmiHostName[:port]>/<jdbc-url>
>
> String jurl = "jdbc:rmi:" + rmiHost + "/" + url;
> System.out.println("TestClient:" + jurl);
> Connection c = DriverManager.getConnection(jurl);
>
> Statement st = c.createStatement();
> ResultSet rs = st.executeQuery("select * from import1");
>
> ResultSetMetaData md = rs.getMetaData();
> while(rs.next()) {
> System.out.print("\nTUPLE: | ");
> for(int i=1; i<= md.getColumnCount(); i++) {
> System.out.print(rs.getString(i) + " | ");
> }
> }
>
> rs.close();
>
> } catch(Exception e) {
> e.printStackTrace();
> }
> }
> };
>
> ------------------------------------------------------------------
> ----------
> -
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
>
>
> ------------------------------------------------------------------
> -----------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|