Re: JDBC connection problem

Dave,

Thanks for the tip. I just tried a test with a lowercase db and the
connection still didn't work.

Thanks again

BT

On Feb 5, 2008 6:29 AM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:

> Brian,
>
> Try using lower case for the name of your database.
>
> Postgresql and upper case is an impedance mismatch.
>
> Dave
> On 5-Feb-08, at 1:05 AM, Guy Rouillier wrote:
>
> > Brian Tomaszewski wrote:
> >> I am having trouble connecting to a psql database running on
> >> Debian GNU/Linux system
> >> The version of psql I am using in the system is 8.2.6.
> >> No matter what I do, I continually am getting the error:
> >> /Backend start-up failed: FATAL: database "RW_GEO" does not exist
> >> /when my JDBC component tries to connect using a URL like this:
> >> jdbc:postgresql://localhost:5432/RW_GEO
> >> from a tomcat app
> >> I have confirmed that the database RW_GEO does in fact exist as I
> >> can see/query tables from it from psql.
> >> Also, when I run my app on my development machine (windows), I can
> >> connect via tomcat with no problems to my local psql server.
> >
> > I'm trying to follow your runtime environment, but some pieces are
> > missing. When you say you can query the database running on Debian
> > using psql, is that psql running on your Windows box or on the
> > Debian box? I don't think this has anything to do with JDBC. The
> > URL you show above has "localhost" as the server for the DB. That's
> > probably not right, is it? I wouldn't think you'd have Tomcat
> > running on your database server.
> >
> > So, run psql from whatever box is running Tomcat, and figure out how
> > to connect it to your DB server. Once you've done that, you should
> > be able to just transfer the connection settings to JDBC. I'm
> > anticipating once you attempt to do that, you'll encounter a
> > connection error. That's because you need to update pg_hba.conf to
> > allow access to your database from remote hosts.
> >
> > --
> > Guy Rouillier
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 7: You can help support the PostgreSQL project by donating at
> >
> > http://www.postgresql.org/about/donate
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>