No suitable driver error

Hi,
I am trying to connect to a database and display the results in an applet using JTable. I am using a TableModel in which I have the following statements:

try
                   {
                   Class.forName("oracle.jdbc.driver.OracleDriver");
                   DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
                   Connection con = DriverManager.getConnection("jdbc [img]http://www.javaranch.com/ubb/redface.gif[/img]dbc:thin:@union21:1521:UNION1B","alma","alma");
                                 sqlStatement = con.createStatement();  
                    ResultSet rs = sqlStatement.executeQuery("select * from holiday");
                                 numCols = rs.getMetaData().getColumnCount();
                                 columnNames = new String[numCols];
                                 //Get the column names and cache them
                                 for(int column = 0; column<numCols; column++)>
                                 {
                                    columnNames[column] = rs.getMetaData().getColumnLabel(column+1);
                                 }
                                 while (rs.next())
                                 {
                                    Vector rowVector = new Vector();                     
                                      for (int currentCol = 1; currentCol < numCols; currentCol++)
                                    {
                                       rowVector.addElement(rs.getObject(currentCol));
                                    }
                                    tableData.addElement(rowVector);
                                    con.close();
                                    fireTableChanged(null);//Tell the listener a new table has arrived
                                 }
                              }
                              catch(ClassNotFoundException e){
                                  System.out.println("*** Cannot find database driver classes: "+e.getMessage());
                              }
                              catch(SQLException e) {
                                   System.out.println("*** Cannot connect to this database: "+e.getMessage());
                              }
                           }

When I try to view the applet from the browser, I get an error in Java console saying "Cannot connect to this database: No suitable Driver". I tried a simple java program that connects to a databse and displays the results at stdout and I was successful. I am unable to figure out what might be the problem. Could anyone
please help me out?
Thanks in advance
Chak

Hi,
No suitable driver found, => that the driver classes are not there in the classpath, check for classpath properly.
Moreover the database must reside on the same machine from where the applet originated.
Cheers
Durga

Originally posted by Chak Terlapu:
[B]Hi,
I am trying to connect to a database and display the results in an applet using JTable. I am using a TableModel in which I have the following statements:
try { Class.forName("oracle.jdbc.driver.OracleDriver"); DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection con = DriverManager.getConnection("jdbc [img]http://www.javaranch.com/ubb/redface.gif[/img]dbc:thin:@union21:1521:UNION1B","alma","alma"); sqlStatement = con.createStatement(); ResultSet rs = sqlStatement.executeQuery("select * from holiday"); numCols = rs.getMetaData().getColumnCount(); columnNames = new String[numCols]; //Get the column names and cache them for(int column = 0; column<numCols; column++)> { columnNames[column] = rs.getMetaData().getColumnLabel(column+1); } while (rs.next()) { Vector rowVector = new Vector(); for (int currentCol = 1; currentCol < numCols; currentCol++) { rowVector.addElement(rs.getObject(currentCol)); } tableData.addElement(rowVector); con.close(); fireTableChanged(null);//Tell the listener a new table has arrived } } catch(ClassNotFoundException e){ System.out.println("*** Cannot find database driver classes: "+e.getMessage()); } catch(SQLException e) { System.out.println("*** Cannot connect to this database: "+e.getMessage()); } }
When I try to view the applet from the browser, I get an error in Java console saying "Cannot connect to this database: No suitable Driver". I tried a simple java program that connects to a databse and displays the results at stdout and I was successful. I am unable to figure out what might be the problem. Could anyone
please help me out?
Thanks in advance
Chak [/B]

Hi,
I think the problem is that the database resides on a different machine from where the applet originates. Is there a fix to this problem. Can we make it work if the database is on a different machine. Is it because of applet "security issues" that we might not be able to do this. Could you answer these questions please
Thanks
Chak