connect through jdbc

From: zeb <spam_at_nowhere.com>
Date: Tue, 16 Nov 2004 21:45:05 +0100
Message-ID: <419a65e7$0$1870$626a14ce@news.free.fr>

Hi,

I try to connect to a db through a simple java program:

JDK 1.4 CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.jar and
CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc14.jar ( loaded from otn for oracle 9.2.0.0 JDK1.4) and I have the following error:
java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver

Can you help me ???
TIA oracle_at_pluto:/home/oracle/jdbc$ cat Applet1.java

package mypackage;

       import javax.swing.JApplet;
       import java.awt.Dimension;
       import java.awt.Toolkit;
       import java.awt.BorderLayout;
       import javax.swing.JFrame;
       import javax.swing.UIManager;
       import javax.swing.JButton;
       import java.awt.Rectangle;
       import javax.swing.JTextArea;
       import java.awt.event.ActionListener;
       import java.awt.event.ActionEvent;
       import java.sql.*;
       import javax.swing.JLabel;

       public class Applet1 extends JApplet {

         private JButton DbConnect = new JButton();
         private JTextArea empValues = new JTextArea();
         private Connection con;
         private JLabel jLabel1 = new JLabel();

         public Applet1()  {


         }


         public void init()  {
           try {
             jbInit();
           } catch(Exception e) {
             e.printStackTrace();
           }


         }


         private void jbInit() throws Exception {
           this.getContentPane().setLayout(null);
           DbConnect.setText("Click to Connect to DB");
           DbConnect.setBounds(new Rectangle(90, 225, 175, 40));
           DbConnect.addActionListener(new ActionListener() {
               public void actionPerformed(ActionEvent e)   {
                 connectToDB(e);
               }
             });
           empValues.setBounds(new Rectangle(40, 50, 310, 150));
           jLabel1.setText("TOTO Records :");
           jLabel1.setBounds(new Rectangle(45, 20, 155, 20));
           this.getContentPane().add(jLabel1, null);
           this.getContentPane().add(empValues, null);
           this.getContentPane().add(DbConnect, null);


         }



         private void connectToDB(ActionEvent e) {
           try {
             DriverManager.registerDriver(new

oracle.jdbc.driver.OracleDriver())
;

con = DriverManager.getConnection ("jdbc:oracle:thin:@pluto:1521:DB
9IDEV","system","manger");

empValues.setText("Connected to the Database. Fetching Values from
TOTO Tables.\n");

             fetchValues();
           } catch (SQLException ex)     {
             System.out.println("Connection Error =  "  + ex.toString());
           }


         }


         public void fetchValues() {
          try {
           Statement stmt = con.createStatement();
           StringBuffer allRowValues = new StringBuffer();
           int counter = 1;
           ResultSet rset = stmt.executeQuery("SELECT NO, DTCREA FROM
TOTO");
           while (rset.next())
           {
             allRowValues.append("ROW " + counter +  ": ENAME = " +

rset.getStri
ng(1) + " & ENO = " + rset.getString(2) + "\n");

             counter++;
           }
           empValues.setText(allRowValues.toString());
           rset.close();
           stmt.close();
           con.close();


         } catch (SQLException ex)

         {
           System.out.println("Error While Fetching Values =  "  +

ex.toString(
));

}
}

}

oracle_at_pluto:/home/oracle/jdbc$ cat Applet1.html

      <HTML>
       <HEAD>
       <TITLE>
       Applet JDBC Operations
       </TITLE>
       </HEAD>
       <BODY>

       </BODY>
       </HTML>

oracle_at_pluto:/home/oracle/jdbc$ javac -d /home/oracle/jdbc Applet1.java oracle_at_pluto:/home/oracle/jdbc$ appletviewer -J-Djava.security.policy=mypolicy.txt Applet1.html java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver

        at mypackage.Applet1.connectToDB(Applet1.java:55)
        at mypackage.Applet1.access$000(Applet1.java:17)
        at mypackage.Applet1$1.actionPerformed(Applet1.java:41)
        at

javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17 64)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra ctButton.java:1817)

at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel .java:419)

at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257 )

at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL istener.java:245)

        at java.awt.Component.processMouseEvent(Component.java:5193)
        at java.awt.Component.processEvent(Component.java:4990)
        at java.awt.Container.processEvent(Container.java:1566)
        at java.awt.Component.dispatchEventImpl(Component.java:3698)
        at java.awt.Container.dispatchEventImpl(Container.java:1623)
        at java.awt.Component.dispatchEvent(Component.java:3539)
        at

java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3449 )

at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3164)

at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)

        at java.awt.Container.dispatchEventImpl(Container.java:1609)
        at java.awt.Component.dispatchEvent(Component.java:3539)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
        at

java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh read.java:197)

at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre ad.java:150)

at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)

at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:99) Received on Tue Nov 16 2004 - 14:45:05 CST