Hi people, I have a class which does the usual : i.e.
...

String dbc="org.apache.derby.jdbc.EmbeddedDriver";
String url="jdbc:derby:C:\\PersistenceStore;create=true";
...
<<store them into a properties file db_pr >>
...

   private Connection openConnection() {
       Connection c = null;
       try {
           Class.forName(db_pr.getProperty("dbc")).newInstance();

c = DriverManager.getConnection(db_pr.getProperty("url"), db_pr.getProperty("uid"), db_pr.getProperty("pwd"));
       } catch (IllegalAccessException iae) {
           logException(iae, getClass().getName(), 6000);
       } catch (ClassNotFoundException cnfe) {
           logException(cnfe, getClass().getName(), 6005);
       } catch (InstantiationException ie) {
           logException(ie, getClass().getName(), 6010);
       } catch (SQLException se) {
           while (se != null) {
               logException(se, getClass().getName(), 6015);
               se = se.getNextException();
           }
       }
       return c;
   }
...

I have the derby jar files set in the classpath. This code has always worked fine from any programs run from the command line but when I package the code above into a jar file, it can't find the embedded driver for Derby anymore, although the code works fine with Oracle DB 7.x, Sybase etc. I tried to set the jar files as run-time parameters as :

java -cp .;./derby.jar program.jar or
java -cp %classpath% program.jar

to no avail.

Can anyome tell me what I have to do to get this to work ?
Regards, Dan

Reply via email to