Re: JDBC connection problem

Dave,

Thanks for the quick reply.

I am using java code like what you show to connect to postresql in my app

And that's part of the weird thing - java connect code with postgres
database on windows is fine, same java code trying to connect to to a
postgres database on debian, can't connect or even see the database for
that matter

Could it be a driver version issue?

Thanks again for your time

Brian

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

> Brian,
> I have no idea why you can't connect but I have comments about running
> tomcat and pg below
>
> write a very small program which attempts to connect outside of tomcat
>
> ie
>
> main
> class.forName("org.postgresql.Driver")
> Driver.getConnection(....
>
> and see if that connects
>
> see below for more comments
> On 5-Feb-08, at 8:17 AM, Brian Tomaszewski wrote:
>
> Guy,
>
> Thanks for the response. See below for clarifications:
>
> On Feb 5, 2008 1:05 AM, Guy Rouillier <guyr-ml1(at)burntmail(dot)com> 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 can run psql (the command line tool) on Debian and using the psql tool
> on Debian see/query the database that is always being reported as not
> existing when the app connects.
>
> On my Windows box, I use pgAdmin interface. I also develop the Java Code
> for the app on windows and then upload it to the server to run/tes. Also, I
> built the inital database on the windows box, and then uploaded and restored
> it to the debian postgres running there
>
>
>
>
> > 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.
>
>
> yes, we do have tomcat running on the database server (i.e the debian
> server), is that a bad thing?
>
> It's not good, since tomcat and postgresql both like memory. However you
> may not have a choice.
>
>
>
> My thought with using localhost on the debain is that is that is how the
> tomcat could easily connect
>
>
> So, run psql from whatever box is running Tomcat, and figure out how to
> > connect it to your DB server.
>
>
> I have done this on windows. Every thing for my app on windows is on the
> same box (tomcat, postgres etc). When I port the app up to the debian
> server, the connection fails
>
>
>
> > 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.
> >
>
>
> Ok, so is the real issue then having tomcat and postgres on the same
> server? Should they be physically separate? If they are not, what do you
> need to consider in terms of configuration
>
> No, it's no real issue, other than a resource sharing problem.
>
> Dave
>
> Thank you for your time
>
> Brian
>
>
> >
> > --
> > Guy Rouillier
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: You can help support the PostgreSQL project by donating at
> >
> > http://www.postgresql.org/about/donate
> >
>
>
>