What happens if we don't close the connection in jdbc?
No Answer is Posted For this Question
Be the First to Post Answer
Why do we use jdbc statements?
What is connection pooling? What Method and class used for Connection pooling in Java?
What is execute(), executeUpdate() and executeQuery() methods?
What are the differences between stored procedure and functions?
What is the use of dialect?
is java pure object oriented or not ?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
What is the major difference between java.util.date and java.sql.date data type?
What is database deadlock ? How can we avoid them?
If iam using JDBC API, do I also have to use ODBC?
java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }