title: The import oracle.jdbc cannot be resolved
body: <p>I am currently working on a project where we have to connect to a database and through Java insert values into our database. Our professor gave us code in order to help us see how to carry that out. I am new to Java and have very little experience in it but I have been watching videos and researching online. My problem  is the following: I am working in eclipse and have created a class called <code>_DataGenerator_</code> all the code that is there is from my professor.</p>
  
  <pre><code>import java.sql.*;
  
  import oracle.jdbc.driver.*;
  
  public class TestDataGenerator {
  
      public static void main(String args[]) {
  
          try {
          Class.forName("oracle.jdbc.driver.OracleDriver");
          String database = "jdbc:oracle:thin:@131.130.122.4:1521:lab";
          String user = "a+MatrNr";
          String pass = "Oracle-Passwort";
  
          // establish connection to database 
          Connection con = DriverManager.getConnection(database, user, pass);
          Statement stmt = con.createStatement();
  
          // insert a single dataset into the database
          try {
              String insertSql = "INSERT INTO person VALUES ('012345678902', 'Erich', 'Schiküta', 'Wien', 1010, 'Rathausstrasse 19', '12-FEB-2000', 'Wien')";
              stmt.executeUpdate(insertSql);
          } catch (Exception e) {
              System.err.println("Fehler beim Einfuegen des Datensatzes: " + e.getMessage());
          }
  
          // check number of datasets in person table
          ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM person");
          if (rs.next()) {
              int count = rs.getInt(1);
              System.out.println("Number of datasets: " + count);
          }
  
          // clean up connections
          rs.close();
          stmt.close();
          con.close();
  
          } catch (Exception e) {
          System.err.println(e.getMessage());
          }
      }
  }
  </code></pre>
  
  <p>The only error I get when trying to run the code is from
  <code>import oracle.jdbc.driver.*;</code>
  When I put my cursor over the error symbol it says </p>
  
  <blockquote>
    <p>the import oracle.jdbc cannot be resolved</p>
  </blockquote>
  
  <p>When I try to run the code the only message I get back is
  the statement in Red <code>oracle.jdbc.driver.OracleDriver</code>
  I don't know what the problem is. I don't know if it helps to know that I have created my database in oracle SQL developer.</p>