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

Is there /usr/java/jdk/jre/lib/ext/postgresql.jar and is it true
postgresql JDBC ?
I don't know if You use gcj - you try with jdk

regards
On Wednesday 20 November 2002 05:23 pm, Dennis King wrote:
> Yes, that line to log into psql works fine.
>
> --- Haris Peco <snpe@snpe.co.yu> wrote:
> > Can you log in Postgresql with :
> > psql -h localhost -U xxx -p 5432 -d webdb ?
> >
> > On Wednesday 20 November 2002 04:57 pm, Dennis King 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.
> > >
> > > --- 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)
> > > > >    at 0x40248e34: _Jv_InterpMethod.run(ffi_cif, void,
> >
> > ffi_raw,
> >
> > > > > _Jv_InterpMethodInvocation) (/usr/lib/libgcj.so.3)
> > > > >    at 0x40246424: _Jv_InterpMethod.run_normal(ffi_cif, void,
> > > >
> > > > ffi_raw,
> > > >
> > > > > void) (/usr/lib/libgcj.so.3)
> > > > >    at 0x4039d1bc: ?? (??:0)
> > > > >    at 0x4025b308: gnu.gcj.runtime.FirstThread.call_main()
> > > > > (/usr/lib/libgcj.so.3)   at 0x402c60b1:
> > > > > gnu.gcj.runtime.FirstThread.run() (/usr/lib/libgcj.so.3)
> > > > >    at 0x40267fdc: _Jv_ThreadRun(java.lang.Thread)
> > > > > (/usr/lib/libgcj.so.3)
>
> === message truncated ===
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> http://webhosting.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)