Forums Register Login

jdbc error

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
if you are using Oracle Jdrivers instead of thin driver what would be the URL: ??? and the
Driver ClassName = ???
My previous laptop never exploded like that. Read this tiny ad while I sweep up the shards.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1032 times.
Similar Threads
JSP cannot connect to Oracle on remote machine
jdbc connection in jsp
jdbc connection in jsp
Problem with conn to oracle
Oracle connectivity
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 17:12:12.