How to close URL connection?

JAVA JDBC: How do I establish a connection to an oracle database through JAVA?

• I have code here that should connect me to an oracle DB through JAVA but I am getting errors, here's the Code: import java.sql.* ; import java.lang.* ; import java.io.* ; public class SimpleJdbc { public static void main(String[] args) throws SQLException, ClassNotFoundException { //load the JDBC Driver Class.forName("oracle.jdbc.driver.Oracle… System.out.println("Driver loaded"); // Establish a connection Connection connection = DriverManager.getConnection ("jdbc:oracle:thin:@edgar1.cse.lehigh.ed… System.out.println("Database connected"); // create a statement Statement statement = connection.createStatement(); // execute a statement ResultSet resultSet = statement.executeQuery ("select course_id, title, dept_name from course"); // Iterate through the result and print the information while (resultSet.next()) System.out.println(resultSet.getString(1… + "\t" + resultSet.getString(2) + "\t" + resultSet.getString(3)); // close the connection connection.close(); } } All of the Connection URL info is correct and I use an actual USERNAME and PASSWORD in trying to connect, but when I run this I get the following error: java.lang.ClassNotFoundException at edu.rice.cs.plt.reflect.PathClassLoader.… at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at SimpleJdbc.main(SimpleJdbc.java:13) at sun.reflect.NativeMethodAccessorImpl.inv… Method) at sun.reflect.NativeMethodAccessorImpl.inv… Source) at sun.reflect.DelegatingMethodAccessorImpl… Source) at java.lang.reflect.Method.invoke(Unknown Source) at edu.rice.cs.drjava.model.compiler.JavacC… > Does anyone see a problem with the code, How can I make this code connect me to a database or can someone supply me with code that works to establish a DB connection, where I can type in the connection URL and my user name and password? Thanks in advance,l really need help with this

• Answer:

  Did you include the Oracle JDBC driver in your class path ?