Re: CLASSPATH Problem ???? - Mailing list pgsql-jdbc

What version of Java are you using?

Kostas Stergiou wrote:
> For the last two days i'm trying to use java on a
> linux box but i'm completely lost i'm afraid.
> What i want to do is to write an app that will
> communicate with a database (oracle or postgres).
> I use Suse 9 and postgresql to start.
> The database is configured without problems and i can
> communicate with it using psql utility (the owner of
> the postgres is another user i created also named
> postgres).
> I can communicate with the db also through C / C++
> with no problems.
> To use java i download the pg73jdbc3.jar (postgres
> version is 7.3.4). I copied that file in /usr/lib/java
> and i tried to compile the following program
>
> import java.sql.*;
>
> class JDBCVersion
> {
>    public static void main (String args[])
>           throws SQLException
>    {
>     Class.forName("org.postgresql.Driver");
>    }
>
> The response i got was
> unreported exception java.lang.ClassNotFoundException
>
> Trying to resolve that error i've found that there
> were no CLASSPATH variable for any user. I added the
> line
> export
> CLASSPATH=/usr/lib/java:/usr/lib/java/pg73jdbc3.jar
> in .bash file but that didn't help.
> Other vars like JAVA_HOME, JAVA_JDK was already set by
> the OS.
> Since i'm new in java and linux i tried jbuilderX from
> borland in case i could manage it better through IDE.
> In jbuilder i added a library through
> Tools->Configure Libraries->New->Class->pg73jdbc3.jar
> I also added in the class option of
> Tools->Configure JDK->User Home
> the line
> /home/usr/JBuilderX/thirdparty/postgres/pg73jdbc3.jar
> and in project properties option i added the jar file
> in required libraries
> That didn't seem to work also. The same program
> doesn't work in the IDE. When i'm trying to use
> Database Pilot the postgres driver is always
> displaying in red.
> I tried the same with oracle 9i and still nothing
> works.
> Everything seem to work ok in windows 2k installation.
> What am i doing wrong in Suse? Is it a CLASSPATH
> problem as i believe or it might be something else?
>
> Sorry for the size of the post, but i'm completely
> confused
>
> PS i tried another version of the driver
> (pg74.1.jdbc3.jar) with the same results
>
> TIA
>
>
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>