Database Connectivity

[Jeremy Hooie]

I'm trying to connect to an Oracle database using the JDBC-ODBC bridge. I've set up the ODBC (using a System DSN) and I know nothing is wrong with the driver itself. I've signed the jar and given permission in my .java.policy file. When I run the Applet, I get the message No Suitable Driver. I added a snippet of code to make sure the driver was loaded, registered, and JDBC compliant.

Class.forName(driver);
Enumeration drivers = DriverManager.getDrivers();
System.out.println("The following drivers have been registered ");
while (drivers.hasMoreElements())
{
  Driver d = (Driver) drivers.nextElement();
  System.out.print(d.toString());
  System.out.println(" Version " +d.getMajorVersion() + "." + d.getMinorVersion() 
                                                              + " JDBC Compliant: "+ d.jdbcCompliant());
}

Everything seems fine to this point. Has anyone else ran into this problem?

[Tim Holloway]

Just for giggles, could you list the output of that display code?

[Jeremy Hooie]

Sure!
The following drivers have been registered
sun.jdbc.odbc.JdbcOdbcDriver@5f6303 Version 2.1 JDBC Compliant: true
java.sql.SQLException: No suitable driver

[Tim Holloway]

It's been a long time since I used the JDBC-ODBC bridge. You really ought to be using the Oracle driver. JDBC-ODBC is primarily a stopgap designed to support databases whose vendors are too mean-spirited to support Java. But most likely you're not coding the URL properly.
You might also want to test things in an Application first - that way the sandbox won't exacerbate your problems.

[Jeremy Hooie]

I'm just starting to learn Java (2 monts into it) and I'm using the bridge because it's just a Proof of Concept. I'll try moving to an Oracle thin driver. However, the bridge works fine with the same code as a desktop app.

[Chak Terlapu]

Is the database on the same machine as your applet code? If it is on a different machine then you cannot do it because of applet security features. In that case you need your applet to call a servlet program in order to connect to a remote database.

[Jeremy Hooie]

Say I have two boxes - a web server housing the Applet and a database. Can you have database connectivity if you set up policy files and sign the jar?
I know Sun's purpose is to encourage ntier architecture, but it's just a for instance.