|
Home > Archive > PostgreSQL JDBC > April 2005 > Cannot connect to remote database.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot connect to remote database.
|
|
| Kristina Magwood 2005-04-13, 8:24 pm |
| Hi,
I am trying to connect to two psql databases at once using jdbc.
The first database is v7.3 running on Windows under Cygwin, the second is
v8.01 on Windows both on the local LAN.
The pg_hba.conf files on both machines allow any machine on the LAN to
access the database.
People regularly access the v7.3 database from Crystal Reports, so I know
it's available.
When I try to run the jar from the first machine, I am able to connect to
the local database, but not the remote database.
The same thing happens when I try from the second machine.
The error is:
Backend start-up failed: FATAL: database "xxx" does not exist.
Where xxx is the name of the database on the remote server.
In other words, my program is only looking for databases on the local
machine.
The code I use to connect is:
DriverManager.registerDriver(new org.postgresql.Driver());
String serviceArg = jdbc:postgresql:xxx//<ipAddress>/<port>;
m_conn = DriverManager. getConnection(servic
eArg, m_userName,
m_userPassword);
Any help will be greatly appreciated.
Kristina Magwood
| |
| Dave Cramer 2005-04-13, 8:24 pm |
| Shouldnt the url be jdbc:postgresql://<ipAddress>/<port>/xxx;
Dave
Kristina Magwood wrote:
>
> Hi,
>
> I am trying to connect to two psql databases at once using jdbc.
> The first database is v7.3 running on Windows under Cygwin, the second
> is v8.01 on Windows both on the local LAN.
> The pg_hba.conf files on both machines allow any machine on the LAN to
> access the database.
> People regularly access the v7.3 database from Crystal Reports, so I
> know it's available.
>
> When I try to run the jar from the first machine, I am able to connect
> to the local database, but not the remote database.
> The same thing happens when I try from the second machine.
>
> The error is:
> Backend start-up failed: FATAL: database "xxx" does not exist.
> Where xxx is the name of the database on the remote server.
> In other words, my program is only looking for databases on the local
> machine.
>
> The code I use to connect is:
>
> DriverManager.registerDriver(new org.postgresql.Driver());
> String serviceArg = jdbc:postgresql:xxx//<ipAddress>/<port>;
> m_conn = DriverManager. getConnection(servic
eArg, m_userName,
> m_userPassword);
>
> Any help will be greatly appreciated.
>
> Kristina Magwood
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
| |
| Kristina Magwood 2005-04-13, 8:24 pm |
| Yes! It works. Thank you, Dave and John.
Dave Cramer <pg@fastcrypt.com>
04/13/2005 04:47 PM
Please respond to
pg@fastcrypt.com
To
Kristina Magwood < kristina@nanometrics
.ca>
cc
pgsql-jdbc@postgresql.org
Subject
Re: [JDBC] Cannot connect to remote database.
Shouldnt the url be jdbc:postgresql://<ipAddress>/<port>/xxx;
Dave
Kristina Magwood wrote:
>
> Hi,
>
> I am trying to connect to two psql databases at once using jdbc.
> The first database is v7.3 running on Windows under Cygwin, the second
> is v8.01 on Windows both on the local LAN.
> The pg_hba.conf files on both machines allow any machine on the LAN to
> access the database.
> People regularly access the v7.3 database from Crystal Reports, so I
> know it's available.
>
> When I try to run the jar from the first machine, I am able to connect
> to the local database, but not the remote database.
> The same thing happens when I try from the second machine.
>
> The error is:
> Backend start-up failed: FATAL: database "xxx" does not exist.
> Where xxx is the name of the database on the remote server.
> In other words, my program is only looking for databases on the local
> machine.
>
> The code I use to connect is:
>
> DriverManager.registerDriver(new org.postgresql.Driver());
> String serviceArg = jdbc:postgresql:xxx//<ipAddress>/<port>;
> m_conn = DriverManager. getConnection(servic
eArg, m_userName,
> m_userPassword);
>
> Any help will be greatly appreciated.
>
> Kristina Magwood
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
|
|
|
|
|