🚀 go-pugleaf

Try this:

   public void getConnection(
       String classname,
       String filename,
       String dbUrl,
       Properties props) {
     try {
       File f = new File(filename);
       URL[] urlList = new URL[] { f.toURL() };
       URLClassLoader cld =
           new URLClassLoader(
               urlList,
               this.getClass().getClassLoader());
       Driver driver =
           (Driver)cld.loadClass(classname).newInstance();
       Connection connection = driver.connect(dbUrl, props);
       /* instead of
       Connection connection =
           DriverManager.getConnection(dbUrl, props);
       */
     }
     catch (Exception ex) {
       ex.printStackTrace();
     }
   }


What I missed was the fact that you have to use
the driver instance itself in this scenario, not
the DriverManager whose class loader will never
know about the dynamically loaded class ... at least
I think that's the explanation.  [Feel free to correct
me if I'm wrong.]

[Thanks to the Cayenne contributors, Andrei Adamchik in particular,
for this solution.  If you want to see it yourself, see the class,
org.objectstyle.cayenne.conn.DriverDataSource.  It's unfortunate
that Cayenne is not more widely known -- my gut feeling is that
it's a heck of a lot smoother an experience than Hibernate, which
to me is very quirky.  Cayenne has just admitted as a Jakarta
Incubator project.

   http://incubator.apache.org/projects/cayenne.html

I'm hoping that will boost its prominence.]


-- 


Paul Furbacher (TeamB)

   Save time, search the archives:
        http://info.borland.com/newsgroups/ngsearch.html

   Is it in Joi Ellis's Faq-O-Matic?
        http://www.visi.com/~gyles19/fom-serve/cache/1.html

   Finally, please send responses to the newsgroup only.
   That means, do not send email directly to me.
   Thank you.