Re: JDBC on Postgres 8.3

Allgood, John wrote:
> Thanks for responding. I think I have figured out what I need to do. I
> think I just need to install the JDBC driver on his client machine and
> then setup the connection strings within the query tool he is using. I
> assume since he already has java installed on his workstation. Then he
> can communicate with the PostgreSQL database. The only thing he is
> wanting to do is pull data out of our database and put into there Oracle
> Transportation System.

You're probably in good shape, but you might check the version of Java
that is installed. I *think* RHEL4 comes with GNU java, which may or may
not work with JDBC (anybody know?). If the user has installed Sun's JDK,
then things are almost certainly fine. To find out, run:

java -version

If you get back something like:

->java -version
java version "1.4.2"
gcj (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

you're running GNU java. If you get back something like:

->java -version
java version "1.6.0_06"
Java(TM) SE Runtime Environment (build 1.6.0_06-b02)
Java HotSpot(TM) Server VM (build 10.0-b22, mixed mode)

you're running Sun's Java.

--
Steve Wampler -- swampler(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.