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 9711

Is JDBC a language or Application?

3 6456

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

2 4215

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,

2226

all Java qts are imp ?

eBay,

1 4777

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 9744

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

2 4733

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

1 3244

How we store procedure in oralce for callable statements in jdbc

2388

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 4957

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 25306

What will happen when ResultSet is not closed?

CTS,

1 7110

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

4 12645

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

HCL,

1 5589

what are the drawbacks of JDBC? explain briefly?

5 42211

Post New JDBC Questions

Un-Answered Questions { JDBC }

What are the differences between setmaxrows(int) and setfetchsize(int)?

1111

What is jdbc odbc in java?

1177

What is difference between jdbc and odbc?

1069

Where is jdbc used?

1042

What are the factors that the jdbc driver performance depends upon?

1033

Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?

1018

Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

1025

What is odbc and jdbc?

1082

How do we call a stored procedure from jdbc?

1028

Why would you use setautocommit(false) in jdbc?

1269

What is @entity in java?

1013

What is the execute method in java?

1066

How can you create jdbc statements?

1018

What are the functions of the jdbc connection interface?

1012

Which is better jpa or jdbc?

971

For More Un-Answered { JDBC } Questions Click Here