SuSE

Hi,

I am writing a Java Swing application and want to add Embedded SQL to it. The application should interact with a PostgreSQL database running on my local machine. The compiler complains that it cannot find the org.postgresql package included in the code. I'm guessing the problem is that the classpath is not set properly. But when I try to add the postgresql-jdbc driver to the classpath using "export CLASSPATH=$CLASSPATH:/usr/share/pgsql/pg73b1jdbc1.jar", the program stops recognizing the other Java files it uses. How do I set the classpath up properly?

Code sample:

import java.awt.*;
import javax.swing*;
import java.sql.*;
import org.postgresql.*;

public class MyClass
{

public static void main (String [] args)
{

MyFrame frame = new MyFrame();
MyPanel panel = new MyPanel();

// more code here

}

}

MyClass.java:4: package org.postgresql does not exist
import org.postgresql.*;
^
1 error

Any help is much appreciated.
Marina.