Re: JDBC thin driver loading problem

I had the jdbc classes included in the jar file. It occurred to me this looked familiar to when I tried to run the database on a different server than the web server (it looked the same, but was actually a database link to another machine.) This was way back with the first publicly available beta jdbc driver, running oracle7 on both machines. The problem was proxying. I think this may be related to the problem, but I don't really know.

Now I have the classes located where the web service and database are, and I get a security exception instead. I have no solution to this. Soon I shall panic a little -- say, in about 10 days ;-)

The new problem seems to have more to do with java than oracle, specifically security / path setup info, so I posted it to comp.lang.java.machine, but haven't had any responses yet. The subject heading for my posting was "AccessControlException: access denied / java intranet applet NONINITED problem"

Thanks for your help,
Rachel Rainey

Alex Filonov wrote:

> Do you have classes111.zip in your classpath during execution?
>
> In article <3A6FC3A3.5EEBCBD4_at_look.ca>,
> rr <raineyr_at_look.ca> wrote:
> > I would appreciate any help you might be able to provide.
> > I am trying to test a JBuilder program. It works under JBuilder, but
> > when I deploy, including the oracle thin drivers in the jar file, I
 get
> > a
> > no suitable driver
> > error.
> > the string is:
> > jdbc:oracle:thin:@MACHINE:1521:DB1
> >
> > I have tried registering the driver in two ways.
> > I have packaged the oracle thin driver package classes111.zip, and
> > oracle 8.1.5 is running on linux RH6.0
> > I get a SQLException:
> > SQLState: 08001
> > Message: No suitable driver
> > Vendor: 0
> > When I test with JBuilder3, it works, but fails at this point when I
> > test with Opera5.02 running the JVM1.3. (Also, when I test with NS
 with
> > the java plugin, I get a notinited problem).
> >
> > thanks in advance for any help,
> > Rachel
> >
> > I have tried with both these options for driver registration and
> > connection:
> >
> > String url = jdbc:oracle:thin:@MY_MACHINE:1521:DB1;
> > try
> > {
> > /*
> > * Load the Oracle JDBC driver
> > */
> > Class.forName("oracle.jdbc.driver.OracleDriver");
> >
> > conn = DriverManager.getConnection (url, user_id, password );
> >
> > .....
> > }
> >
> > and I have also tried:
> >
> > String url = jdbc:oracle:thin:@MY_MACHINE:1521:DB1;
> > oracle.jdbc.driver.OracleDriver oracleDriver = null;
> > try
> > {
> > /*
> > * Load the Oracle JDBC driver
> > */
> > oracleDriver = new oracle.jdbc.driver.OracleDriver ();
> > DriverManager.registerDriver(oracleDriver);
> > conn = DriverManager.getConnection (url, user_id, password );
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 26 2001 - 14:42:26 CST