Re: jdbc driver not recognized

From: wyrd <wyrd(at)triskelion-nova(dot)com>
To: Stuart Urban <sturban(at)cs(dot)uiowa(dot)edu>
Cc: postgres novice list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: jdbc driver not recognized
Date: 2000-07-18 20:55:11
Message-ID: 3974C42F.EF309E3C@triskelion-nova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi Stuart,

Sorry abou the delay getting back to you. In case you haven't
gotten any more info on this. As it happens I do use Java 2.
It's been awhile since I've use 1.1. One thing you might try
instead of using the System.setProperty() method is try the -D
option of the java command :

java -Djdbc.drivers=<driver> <java class>

The jar containing the driver definitely has to be in CLASSPATH.
Setting this will depend on on which shell you are using. From
below it looks like you're using csh or a csh variant.
You could try:
set CLASSPATH <path to classes.zip>:<path to pqsl driver jar>

Note that the above pathes need to include the classes.zip and the
jar file.

Hope this helps.

~Rob
Stuart Urban wrote:
>
> Hello Rob,
>
> Thank you for responding to my e-mail concerning the jdbc driver included
> in the PostgreSQL package. Unfortunately, I am still having problems.
> The 'System.setProperty' method you suggested does not exist(I am using
> JDK 1.1.5, so maybe this is the problem, if you are using Java 2). I
> checked into Sun's documentation on the System and Property classes, and
> it looks as though there is not a method in 1.1.x to set a single
> property. I have tried numerous different ways of getting JDBC to work.
> First of all, the suggested 'export CLASSPATH'(given in the README file
> with the jdbc stuff) command does not work on my machine. If I do a 'set
> CLASSPATH' to the proper .jar file, it makes the standard Java classes
> unrecognizable to the system, and the 'setenv $ CLASSPATH' seems to do
> nothing, even though it shows no errors. I may just be working with a
> weird system(I do not have access to all of the Java files because I am a
> computer science student and the JDK is a shared application), so I will
> try to find out if anyone around knows how to do this, but if you have any
> more suggestions, I would appreciate it.
>
> --

--
wYRd.:|:(dot)wyrd(at)triskelion-nova(dot)com(dot):|:.prohibitions void where offered
de recta non tolerandum sunt

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message David Ross 2000-07-19 08:51:03 Re: How to get ODBC going?
Previous Message Eduardo Kotujansky 2000-07-18 20:30:32 Stored procedures