🚀 go-pugleaf

George wrote:

> I guess I spoke too soon.
> 
> I'm having trouble going the URLClassLoader route.  The code below
> succeeds in loading the Oracle jdbc driver...however the call to
> DriverManager.getConnection() returns saying "No suitable
> driver"...
> 
> George
> 
>     try {
>       File f = new File(System.getProperty("user.dir") + "\\ojdbc14.jar");
>       URL url = new URL("file:///"+ f.getAbsolutePath());
>       URL [] urlList = new URL[1];
>       urlList[0] = url;
>       URLClassLoader cld = new URLClassLoader(urlList);
>       Class cl = cld.loadClass("oracle.jdbc.OracleDriver");
>       Connection connection = 
           DriverManager.getConnection(
            "jdbc:oracle:thin:@STPDB1P:1521:STP20P1", "fo", "fo");
>     } catch (Exception ex) {
>         ex.printStackTrace();
>     }

If I look at how the Cayenne folks do it (Andrei Adamchik,
specifically) in

   org.objectstyle.cayenne.modeler.FileClassLoadingService

I notice that the new classloader is instantiated with a
parent classloader.

That's different from how you have done it.  Maybe that's
the difference; try

   URLClassLoader cld =
     new URLClassLoader(
       new URL [] { url },
       this.getClass().getClassLoader() );

Also, have you stepped through the above code in the
debugger and ascertained that "cl" is not null?  You
hinted that you have when you wrote "... succeeds in
loading the Oracle jdbc driver...", but I just want to
be sure.


-- 


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.