How to test jdbc connection to sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages of using preparedstatement over statement?
How can we store and retrieve images from the database?
When do we use execute method in java jdbc?
What is JDBC Connection? Explain steps to get Database connection in a simple java program.
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"); } } }
What is the syntax of URL to get connection?
How to find that, a row is updated or not?
How do you insert images into database using jdbc?
What are the considerations for deciding on transaction boundaries?
Why do we use jdbc?
What does the jdbc resultset interface?
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?