🚀 go-pugleaf

"Paul Furbacher [TeamB]" <pfurbacher@mac.com> wrote:
>George wrote:
>> "George" <me@here.com> wrote:
>>> I want to load JDBC drivers on demand.  The user tells me the
>>> driver class name and where the jar files are located and my app
>>> loads the driver.  Or so I would like.  The following code does
>>> not work:
>>> 
>>> try { System.setProperty("java.class.path", path + ";"    +
>>> "C:\\MyDrivers\\ojdbc14.jar" ); 
>>> Class.forName("oracle.jdbc.OracleDriver"); } catch (Exception ex)
>>> { ex.printStackTrace(); }
>>> 
>>> 
>>> The code works if I include the jar file on the java command line
>>> invocation.  What am I doing wrong?
>>> 
>>> TIA George
>>> 
>>> Never mind.  I just found out about URLClassLoader.
>
>Yes.  There are several open source projects (e.g., OR mappers)
>which have tools that provide you with this capability.  One
>which comes to mind is objectstyle.org's Cayenne Modeler.
>You might want to study their code to see if you can enhance
>what you already have accomplished.  (It's always good to see
>how other folks approach a problem.)
>
>
>-- 
>
>
>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.

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();
    }