Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc error

 
gani
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Following is the error I am getting when I compile the code below:
import java.sql.*;
class JdbcTest {
public static void main (String args []) throws SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc racle ci8:@lmtest", "gani", "babu");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select sname from students");
while (rset.next ())
System.out.println (rset.getString (1));
}
}
error
--------------------------
JdbcTest.java:5: Exception java.lang.ClassNotFoundException must be caught, or it must be declared in the throws clause of this method.
Class.forName("oracle.jdbc.driver.OracleDriver");

Pls help me if you have any suggestions.
Thanks
Gani
 
Riaz Mohamed
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi ghani ,
when u throw an exception always remember to catch it ..i dont see a try catch block in u'r program.. the ideal program would be as below
class JdbcTest {
public static void main (String args []) throws SQLException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DDriverManager.getConnection("jdbc racle:thin:username/password@host ort:sid");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select sname from students");
while (rset.next ())
{
System.out.println (rset.getString ("sname"));
}

}
catch(SQLException e)
{
}
}
guess this would work
 
Adam Adams
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if you are using Oracle Jdrivers instead of thin driver what would be the URL: ??? and the
Driver ClassName = ???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic