JDBC Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

JDBC Interview Questions

Questions Answers Views Company eMail

write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum

Bosch, HireCraft, Infosys,

3 8170

Is JDBC a language or Application?

3 5128

how can we get the metaData (columnNames) from a table which has no Records..

2 3221

While in CallableStatament using in the oracle my procedure is return no.of columns so in java how can i retrivbe the data and i wnat to view all data which is reetrive from my procedure

ADP,

1654

all Java qts are imp ?

eBay,

1 3698

Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.

6 7765

I have written a program to connect to database using odbc.Can this Application run on any Platform????

2 3687

please tell me the name and url path for type-4 driver ?

1 2465

How we store procedure in oralce for callable statements in jdbc

1840

Give me some example for getting connection from connection pooling in JBoss Server. Is Connection Pool default in Server or we have to create it? Who can create Connection Pool in a Team. How it will be accessed by the developer code?

TCS,

1 4023

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"); } } }

CTS,

6 22944

What will happen when ResultSet is not closed?

CTS,

1 6261

PreparedStatement is a pre compiled statement but where it's pre compiled ?

4 11051

can we create a own jdbc driver? how can we create?

HCL,

1 4708

what are the drawbacks of JDBC? explain briefly?

5 38881

Post New JDBC Questions

Un-Answered Questions { JDBC }

How do we load the drivers?

541

What types of DataSource objects are specified in the Optional Package?

501

How to connect html page to database using jdbc?

483

What is odbc. how is it related to sql cli?

596

What is jdbc and its advantages?

490

Does jdbctemplate use prepared statements?

503

How many ways that we can view a result set?

527

Is jdbc connection secure?

502

What is the role of class.forname while loading drivers?

561

What are the different types of lockings in jdbc?

496

What is jdbc and explain jdbc architecture?

512

What are the 4 types of jdbc drivers?

506

What is connection data?

474

How many types of jdbc drivers are there?

546

What are database warnings in jdbc and how can we handle database warnings in jdbc?

605

For More Un-Answered { JDBC } Questions Click Here