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

Dennis,

This might be a long shot but I noticed the following in your emails:

You appear to be doing both:
-Djdbc.drivers=org.postgresql.Driver
and
Class.forName("org.postgresql.Driver");

Only one or the other should be necessary.  Perhaps because you are
using both methods to load the driver, you are seeing a problem, just a
guess.

thanks,
--Barry


Dennis King wrote:
> 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
>
> ---------------------------(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
>