Re: JDBC and ClassNotFoundException

When you specify java -jar .... The classpath isn't used

Dave
On 15-May-07, at 7:04 AM, Geert Verhaag wrote:

> Dear Members,
>
> I'm currently involved in a database project and have written a GUI in
> Java to manipulate a PostgreSQL database (server version 8.2). I've
> developed the GUI using NetBeans 5.5 (loaded the
> postgresql-8.2-504.jdbc3.jar as JDBC driver) on a Windows XP
> professional platform. Building the projetc's jar file works fine and
> running the Java program on the Windows XP machine runs smoothly.
> Deleting, adding and updating tuples works just fine!
>
> Now I want to run the program's jar file on a Linux platform (OpenSuSe
> 10.2). So I launch the application with the command: java -jar
> AppName.jar at the command prompt, and the program starts
> correctly, by
> displaying the GUI. However when I want to try to connect to the
> database by entering the required username and password, I get the
> ClassNotFoundException: org.postgresql.Driver runtime error. By the
> way, the server on the Windows XP machine is listening for TCP/IP
> connections (listen_addresses = '*' in the postgresql.conf file!)
>
> Can anybody give a hint on how to solve this problem? Some CLASSPATH
> problem perhaps? Specifying the JDBC driver in the classpath option of
> the java-command doesn't seem solve the problem either. I'm afraid
> that
> I don't understand the loading mechanism of the JDBC driver, and
> perhaps
> someone can explain it to me.  Thanks in advance!
>
> Regards,
> Gerard Verhaag
>
>
> ==========================================
>
> Dit bericht is uitsluitend bestemd voor de geadresseerde.
> Het bericht kan vertrouwelijke informatie bevatten.
> Als u dit bericht per abuis hebt ontvangen, wordt u
> verzocht onmiddellijk de afzender te informeren. Ook
> verzoeken wij u het bericht te vernietigen en de inhoud
> niet onder derden te verspreiden of te gebruiken.
>
> This message is intended exclusively for the addressee.
> It may contain information that is confidential.
> If you are not the intended recipient, we request that
> you notify the sender immediately. In that case, we
> also request that you destroy the message and that
> you neither use the contents nor disclose them in any
> manner to third parties.
> ==========================================
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match