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

Suse 9 comes with jdk1.3 and jbuilder install jdk1.4.1

--- Bruce Ashton <bruce@ashton.net> wrote:
> 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
> >
> >

__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools