Re: Redhat 8 default database warning: JDBC problems (CLARIFICATION) - Mailing list pgsql-jdbc

From Dennis King
Subject Re: Redhat 8 default database warning: JDBC problems (CLARIFICATION)
Date
Msg-id 20021127235411.87831.qmail@web40409.mail.yahoo.com
Whole thread Raw
In response to Re: Redhat 8 default database warning: JDBC problems (CLARIFICATION)  (Fernando Nasser <fnasser@redhat.com>)
List pgsql-jdbc
Thanks, Fernando. Can you tell me how I set the path correctly?

I only posted this after I sent email to Red Hat support through
their Red Hat Network pages and didn't hear back. I just couldn't get
it working following the instructions in the RHN online docs, even
after helpful review from this list. I just checked the
administrators and users manual again, and the first sections,
covering account creation and initdb to create the database, don't
mention setting the path. Also, since the install was included in the
OS install and the user was created and the service registered and
started automatically, I'd expect the path to have been set as well.
The "Using Red Hat Database with JDBC" tutorial also makes no mention
that there could be a conflict with the Sun JRE it instructs you to
install and assumes you use.

By the way, I _am_ a Redhat fan, and really like 8.0 overall.

Best,

Dennis


--- Fernando Nasser <fnasser@redhat.com> wrote:
> Just to clarify the issue, I use RHDB (many versions) and the JDBC
> driver with all variants of JREs every day, in machines with
> several
> different versions of the RHL OS, without any problems so far.
> And so do a score of other people.
>
> Dennis had the wrong PATH set.  I myself do the same thing many
> times as
> I also have the GNU gcj compiler installed on my system.
> Unfortunately
> I didn't see his message in the hundreds of ones I get daily.
>
> If you encounter any problem that you think are specific to the Red
> Hat
> Database packing please feel free to use the rhdb public mailing
> list:
>
>       rhdb@sources.redhat.com
>
> or at list cross post to that list to make sure one of us sees it.
>
> Regards to all,
> Fernando
>
> Dennis King wrote:
> > This is a summary of the problems I had getting JDBC working with
> the
> > Redhat Database that comes with the Redhat 8.0 installation,
> which
> > are treated in an earlier thread. "forName finds Driver but
> > getConnection doesn.t".
> >
> > Very simple, really. I believe I correctly configured PostgreSQL;
> the
> > postgresql.conf file had "tcpip_sockets=true", the pg_hba.conf
> file
> > had "host all 127.0.0.1 255.255.255.255 password," the driver
> from
> > both Redhat and PostgreSQL were in the path. I could load the
> driver
> > with the Class.forName() call, but not make the connection.
> >
> > I downloaded the upgrade packages and installed. Same thing.
> >
> > I uninstalled all the packages. Then I installed the source
> tarball
> > for 7.2.3. I could not run make successfully with and
> configuration
> > options other than "./configure". All --with-x and --enable-y
> options
> > broke make.
> >
> > I reinstalled the OS without the Redhat database, installed Java
> > 1.3.1 and the Java Web Services Developers Pack, and all ran
> fine.
> > The same program that had failed with the Redhat distribution
> worked
> > right away.
> >
> > Redhat's site mentions that their database has been approved for
> > Redhat 7.3. Perhaps they distribute incompatible software with
> the
> > 8.0 distribution.
> >
> > Hope this saves somebody some grief. Thanks for all the helpful
> words
> > from those who wrote me back.
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an
> appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>
>
> --
> Fernando Nasser
> Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
> 2323 Yonge Street, Suite #300
> Toronto, Ontario   M4P 2C9
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

pgsql-jdbc by date:

Previous
From: Nic Ferrier
Date:
Subject: jdbc functions and bytea values
Next
From: Dennis King
Date:
Subject: Re: forName finds Driver but getConnection doesn't