> I am a graduate research assistant at West Virginia University.
> I am trying to use Postgress on Linux.
Hi. I'm not familiar with the Java interface, and not familiar with
the rst package. I've reposted this to the "interfaces" mailing list,
which is the best place to ask for information.
Good luck.
- Tom
> when I try to connect to the database template1 using
> psql template1
> it connects
>
> but when I try to connect using Java and the classes I ftped from
> ftp://ftp.ai.mit.edu/people/rst/rst-jdbc.tar.gz
> it says SQLException: Connection refused
> this is in the constructor of Connection (line 102)
>
> the command that I'm using to run the Test application is
> java -Djdbc.drivers=rst.sql.Driver Test
> jdbc:rst://157.182.194.71:5432/template1 "" ""
>
> and I get
>
> ----
> java.sql.SQLException: Couldn't connect: java.net.ConnectException:
> Connection refused
> at rst.sql.Connection.fatal(Connection.java:614)
> at rst.sql.Connection.<init>(Connection.java:102)
> at rst.sql.Driver.connect(Driver.java:139)
> at java.sql.DriverManager.getConnection(DriverManager.java:91)
> at java.sql.DriverManager.getConnection(DriverManager.java:134)
> at Test.main(Test.java:43)
> ----
>
> postmaster is running on 157.182.194.71 on port 5432
> but it refuses connection?
>
> ---
> also the $PGHOST and $PGPORT environment variables were initially empty
> and psql template1 works
> but when I try to set them to the IP address or hostname (for PGHOST)
> and the port# of postmaster (for PGPORT)
> it doesn't work
> Connection refused.
> -----
>
> Please advise me in this regard
>
> I am currently stuck in the implementation of my project, and would
> greatly appreciate your help
>
> thanks
>
> Soumya Aithal
> Graduate Research Assistant
> Dept. of Computer Science & Electrical Engineering.
> West Virginia University
> Morgantown, WV. 26506
>
> Res:
> 1064,VanVoorhis Road, Apt # K-226
> Morgantown, WV 26505
> Ph: (304)293-2349