Thread: Remote Connections via JDBC

Remote Connections via JDBC

From
Mark Britton
Date:
I have another newbie question for the interface group:

I have postgreSQL running on a Linux box and am trying to connect to it from a Windows 95 client using JDBC.

I have the postgresql JDBC driver set up on the client, but can't figure out what the connect string should be to
accessthe databases on the Linux server.  I've scoured the postgresql docs for an example but haven't found anything.
I'musing the JDBCTest1_03 test suite to test the connection. 

The url I'm using is jdbc:postgresql:linux_server.template1 where linux_server is the host name for the Linux box.  Is
thisright? 

Thanks in advance for your help!

Mark Britton
mbritton@gte.net
No matter where you go, there you are.

Re: [INTERFACES] Remote Connections via JDBC

From
Felix Morley Finch
Date:
>>In article <01BDA487.6EFDA9E0@britain>, Mark Britton <mbritton@gte.net> writes:

> The url I'm using is jdbc:postgresql:linux_server.template1 where linux_server is the host name for the Linux box.
Isthis right? 

I had mucho trouble with this until I re-re-re read the fine manual,
and found it was correct, and this is what you should use, accordin to
my working linux-on-same-host URL:

MINE    jdbc:postgresql://crowfix.com/template1
WRONG    jdbc:postgresql:linux_server/template1
RIGHT    jdbc:postgresql://linux_server/template1

I note your host name is linux_server; my /etc/hosts says crowfix.com,
so that's what I use in the URL.  YMMV.

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  PGP = 91 B3 94 7C E9 E8 76 2D   E1 63 51 AA A0 48 89 2F  ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o