Re: forName finds Driver but getConnection doesn't - Mailing list pgsql-jdbc

Another typo. Sorry. I'm using 'postgresql'. I've tried every
imaginable variant. I'm thinking I need to compile my own version
instead of using Red Hat's. Though of course 7.2.2 won't compile,
errors regarding classes ResultSet and Statement not declared as
abstract for not declaring methods. 7.2.3, here I come. Unless
someone can suggest a better way to get at usable binaries with jdbc
support.

Thanks everyone for your help. It sounds like I'm doing everything
right, but something somewhere you don't usually touch is wrong.


--- Alex Dovlecel <dovle@kbs.twi.tudelft.nl> wrote:
> On Wednesday 20 November 2002 19:30, Alex Dovlecel wrote:
> > > I run my program with
> > >
> > > java -cp /usr/java/jdk/jre/lib/ext/postgresql.jar:.
> > > -Djdbc.drivers=org.postgresql.Driver MyProgram
> > >
> > > By the way, I had a temporary typo in the sourceURL that shows
> up in
> > > the stack trace (jdbc:postgres://host:database instead of
> > > host/database) but that was only temporary.
> >
> > My URL looks like this:
> > jdbc:postgresql://localhost/webdb
> >
>
> Sorry, forgot to switch the language output stream :o)))
>
> The translation is:
>
> I think must be postgresql instead of postgres.
>
> >
> > HIH
> > dovle
> >
> > > --- Haris Peco <snpe@snpe.co.yu> wrote:
> > > > On Wednesday 20 November 2002 04:20 pm, Dennis King wrote:
> > > > > --- Haris Peco <snpe@snpe.co.yu> wrote:
> > > > > > On Tuesday 19 November 2002 11:46 pm, Dennis King wrote:
> > > > > > > Hi All. I can't get to my carefully set-up database
> through
> > > >
> > > > java
> > > >
> > > > > > with
> > > > > >
> > > > > > > a simple test program. I think I've hit most of the
> required
> > > > > >
> > > > > > set-up
> > > > > >
> > > > > > > points:
> > > > > > >
> > > > > > > * I've got all the postgresql packages installed
> (checked
> > > >
> > > > with
> > > >
> > > > > > rpm
> > > > > >
> > > > > > > -qa | grep -i postgres; they're there, including the
> jdbc
> > > >
> > > > one).
> > > >
> > > > > > > * I set tcpip_socket = true in
> > > > > >
> > > > > > /var/lib/pgsql/data/postgresql.conf.
> > > > > >
> > > > > > > * I also updated /etc/rc.d/init.d/ so that postmaster
> gets -o
> > > > > >
> > > > > > "-i";
> > > > > >
> > > > > > > this means that the "pg_ctl -D /var/lib/pgsql/data
> status"
> > > > > >
> > > > > > command
> > > > > >
> > > > > > > shows the -i flag was passed in.
> > > > > > > * I have the right driver in the classpath (I pass in
> > > >
> > > > -classpath
> > > >
> > > > > > > /usr/share/pgsql/pgjdbc2.jar when compiling and
> running; for
> > > >
> > > > some
> > > >
> > > > > > > reason, copying the jar to /jre/lib/ext doesn't work
> with any
> > > > > >
> > > > > > jars
> > > > > >
> > > > > > > for me).
> > > > > > > * I added the lines "host all 127.0.0.1 255.255.255.255
> > > >
> > > > trust"
> > > >
> > > > > > and
> > > > > >
> > > > > > > "host all 192.168.0.0 255.255.0.0 trust" to
> > > > > > > /var/lib/pgsql/data/pg_hba.conf
> > > > > > > * I created a new database, "webdb"
> > > > > > > * I added the user "xxx" with the password "yyy" to the
> > > >
> > > > database,
> > > >
> > > > > > and
> > > > > >
> > > > > > > verified by logging into psql with -U xxx (had
> pg_hba.conf
> > > >
> > > > set to
> > > >
> > > > > > > password so was challenged and succeeded)
> > > > > > >
> > > > > > > With all of this, my java program has these lines:
> > > > > > >
> > > > > > > Connection dbConnection = null;
> > > > > > > try{
> > > > > > > Class.forName("org.postgresql.Driver");
> > > > > > > dbConnection =
> > > > > >
> > > > > > DriverManager.getConnection("jdbc:postgresql:webdb",
> > > > > >
> > > > > > > "xxx", "yyy");
> > > > > > > }
> > > > > > >
> > > > > > > I get the error "java.sql.SQLException: Driver not
> found for
> > > >
> > > > URL:
> > > > > > > jdbc:postgresql:webdb". (Note it's finding the driver
> with
> > > >
> > > > the
> > > >
> > > > > > > forName() method call).
> > > > > > >
> > > > > > > I've tried using jdbc:postgresql://localhost/webdb.
> > > > > > >
> > > > > > > I have, of course, restarted the box several times.
> > > > > > >
> > > > > > > Any pointers you have would be extremely gratefully
> received.
> > > > > >
> > > > > > Hello Dennis,
> > > > > >   jdbc:postgresql:webdb is not good URL
> > > > > > If you database webdb and server localhost then second
> URL is
> > > >
> > > > good
> > > >
> > > > > > and problem is in TCP connection - what is your port ?
> > > > > >
> > > > > > regards
> > > > > > Haris Peco
> > > > >
> > > > > Haris et al.,
> > > > >
> > > > > I never specified a port in the install, so Postgresql
> should be
> > > > > running on the default port, 5432. I did uncomment the line
> in
> > > >
> > > > the
> > > >
> > > > > .conf file (all lines seem to be commmented out by
> default). (By
> > > >
> > > > the
> > > >
> > > > > way, my .conf file has all lines commented out, which I
> presume
> > > >
> > > > means
> > > >
> > > > > that it's just operating on the defaults. Is there any
> chance my
> > > > > firewall (default product shipped with Red Hat 8) would be
> > > > > interfering with the communication?
> > > > >
> > > > > Just in case it helps, the SQLException stack trace is
> this:
> > > > >
> > > > > java.sql.SQLException: Driver not found for URL:
> > > > > jdbc:postgresql://localhost:webdb
> > > > >    at 0x4028115f:
> java.lang.Throwable.Throwable(java.lang.String)
> > > > > (/usr/lib/libgcj.so.3)
> > > > >    at 0x402740d2:
> java.lang.Exception.Exception(java.lang.String)
> > > > > (/usr/lib/libgcj.so.3)
> > > > >    at 0x40316294:
> > > > > java.sql.SQLException.SQLException(java.lang.String,
> > > > > java.lang.String, int) (/usr/lib/libgcj.so.3)
> > > > >    at 0x40316244:
> > > > > java.sql.SQLException.SQLException(java.lang.String)
> > > > > (/usr/lib/libgcj.so.3)
> > > > >    at 0x40316102:
> > > > > java.sql.DriverManager.getConnection(java.lang.String,
> > > > > java.util.Properties) (/usr/lib/libgcj.so.3)
> > > > >    at 0x4031603a:
> > > > > java.sql.DriverManager.getConnection(java.lang.String,
> > > > > java.lang.String, java.lang.String) (/usr/lib/libgcj.so.3)
> > > > >    at 0x4039d347: ffi_call_SYSV (/usr/lib/libgcj.so.3)
> > > > >    at 0x4039d307: ffi_raw_call (/usr/lib/libgcj.so.3)
> > > > >    at 0x40248528:
> > > > > _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation)
> > > > > (/usr/lib/libgcj.so.3)
>
=== message truncated ===


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com