In my third line Iksepshin. My Connection conn does not want to see the driver. I sit crying. Here is:

Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jdbc:ojdbc14::@localhost:1521/isqlplus";Connection conn = DriverManager.getConnection(url,user, pass); // ->

Writes:

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:ojdbc14::@localhost:1521/isqlplusat java.sql.DriverMqnager.getConnection<DriverManager.java:602>at java.sql.DriverMqnager.getConnection<DriverManager.java:182>at J3.main<J3.java:17>

Anastasia.

    1 answer 1

    The error text says that the appropriate driver was not found. Create a test class:

     import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class SampleTest { public static void main(String args[]) throws SQLException, ClassNotFoundException { Class.forName("oracle.jdbc.OracleDriver"); String database = "jdbc:oracle:thin:@localhost:1521:xe"; Connection connection = DriverManager.getConnection(database, "username", "password"); Statement statement = connection.createStatement(); ResultSet resultset = statement.executeQuery("..."); while(resultset.next()) System.out.println(resultset.getString("...")); resultset.close(); statement.close(); connection.close(); }}

    Compile

     javac SampleTest.java

    We carry out

     java -cp ojdbc14.jar;. SampleTest

    Notice the string Class.forName("oracle.jdbc.OracleDriver"); and on option -cp .

    • Thank you Petrovich for responding. I am very pleased. But my TextPad and cmd.exe do not see the lines Connection connection = DriverManager.getConnection (database, "hr", "hr"); Give eksepshn. I spat. Well her to leshu. Thank you. Excuse for troubling. - Anastasia 1