Re: JDBC connection problem

Dave,

Thanks for the reply, answers below:

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

> Brian,
> So to be clear you are using jdbc:postgresql://localhost:5432/dbname
>
> on both your windows box and your linux box.
>

yes - it works on windows but not on linux. I even tried adding useSSL=true
to the connection string and that didn't make a difference

>
> Both machines have copies of the database locally ?
>

yes

>
> what does the output of psql -l show on the debian box,
>

List of databases
Name | Owner | Encoding
----------------+----------+----------
RW_GEO | postgres | UTF8
lowercase_test | postgres | UTF8
postgres | postgres | LATIN1
template0 | postgres | LATIN1
template1 | postgres | LATIN1
(5 rows)

and is it listening on a tcpip port ?
>

Does "it" refer to the postgres server? if so, how do I check that it is
listening on a TCPIP port? (sorry if this sounds trivial, I am relatively
new to postgres on linux)

Thanks!

Brian

>
> Dave
>
> On 5-Feb-08, at 9:31 AM, Brian Tomaszewski wrote:
>
> 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
> > >
> >
> >
> >
>
>