A: 

Since your database jar is inside your same EJB ear package, I think it is supposed to be "in the classpath", so you should try following the "in the classpath" section of the docs at http://db.apache.org/derby/docs/10.6/devguide/cdevdvlp24155.html#cdevdvlp24155.

That is, I don't think you want to use the "jar" sub-protocol.

Alternatively, if you are going to use the "jar" sub-protocol, then I think that the part inside the parentheses should be the full filesystem path of your ejb ear file.

Bryan Pendleton
Thank you for your reply. I am not sure if I am able to add my whole comment here, but, I have edited my question to include what I tried based on your answer. Appreciate if you could please review it there. Thanks again.
javagoodies
<p>The following worked:</p><p><font size=2><pre>private static String dbURL_nfdc = "jdbc:derby:classpath:/";private static String dbName = "myDB";private static String user = "";private static String password = "";Connection con = DriverManager.getConnection(dbURL+dbName, user, password);</pre></font><p>Thank you so much for leading me in the right direction. Appreciate your help!!!</p>
javagoodies