🚀 go-pugleaf

Yes, this works.  Thank you.

I guess my mental block was here :  "...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 .....".

Anyway to get back to the issue which started this all:  looks like the
runtime never revisits the value of java.class.path after the VM has
started.  Wonder why.

Thanks again.
George X.


P.S Sorry I accidentally emailed you instead of the newsgroup in  posting my 
reply.


"Paul Furbacher [TeamB]" <pfurbacher@mac.com> wrote in message 
news:442b51bb$1@newsgroups.borland.com...
> 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.