Explain the difference between rowset vs. Resultset in jdbc?
No Answer is Posted For this Question
Be the First to Post Answer
What is database connection pooling? Advantages of using a connection pool?
what happens if connection is not closed?
What is jdbc databasemetadata interface?
What causes no suitable driver error?
What is a JDBC 2.0 DataSource?
What is serialization and deserialization in java programming?
How many types of jdbc drivers are there?
How can we execute stored procedures using callablestatement?
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"); } } }
wa is connection pooling? how do u create connection pooling?wat is use connection pooling?
can we define indexes on a foreign key? Explain pros and cons?
What is namedparameterjdbctemplate?