-
JDBC - Pre compile and Sored Procedure
As prepare statement also precompiles the SQL stmt & stored procedure also compiles the stmt once &den execute the same,then what is the diff between these 2 stmts?
Murali100
- Oct 7th, 2012
The difference between these two statements are
1) SQL Query will be compiled every time it is executed. whereas Stored Procedures are compiled only once when they are executed for the first time
2) Stored Procedure is efficient & fast execution than SQL query -
What is difference b/w Type-1 and Type-4 JDBC Driver with Example ?
Give me brief description with small Example
Suman Kumar Thati
- Oct 5th, 2012
JDBC-ODBC Bridge is a type 1 JDBC driver which converts JDBC operations in to C language ODBC APIs and then ODBC calls are then passed to appropriate ODBC driver.
dasavtar
- Jan 25th, 2011
Type1: JDBC-ODBC Bridge driverThis is a "birdge" driver, Translates all JDBC calls into ODBC calls and sends them to ODBC driver and ODBC inturn will communicate with a database. The Java Na...
-
Fill in the blanks -- The full form of JDBC is _________________
A) Java Database connectivity
-
-
What is Connection Pooling
Chandan
- Jun 20th, 2012
Connection pooling is a technique using which we can get the precreated connection object from the connection pool.After using that connection object, the connection object is released to the pool fo...
Suresh Yerra
- Dec 11th, 2011
Usually Acquiring the connection is time consumption task. In order to avoid that situations, we are reusing already created connection objects. This requirement doesnot support DriverManager interface, we have interface DataSource in javax.sql package.
-
-
JDBC - update many table on single submit
How to achieve a single value from web page to be updated/stored in many tables ?
-
-
JDBC retrieve Row
How can we retrieve a whole row of data at once in JDBC ?
-
3.which one is better to create a thread by implementing Runnable or By Extending Thread in java?">
1.why constructor does not have return type in java?2.why static does not support " this" and "super" keyword in java ?3.which one is better to create a thread by implementing Runnable or By Extending Thread in java?
-
Retrieving data methods
what methods did you use for retrieving data form a ResultSet object
Mohit Pabari
- Oct 6th, 2011
The getX() method is used, where X is String or Int depending on the type used in the database.
debasish padhy
- Jul 15th, 2011
GetString() method is used to retrieve data from the resultset
-
-
What are the three statements in JDBC & differences between them
Answered by Jey on 2005-05-10 05:53:50: 1.Statement which is used to run simple sql statements like select and update 2. PrepareStatment is used to run Pre compiled sql. 3. CallableStatement is used to execute the stored procedures.
Naveen Sharma
- Jul 31st, 2011
Class.forname is used to load a class.
When we are making database connectivity then class.forname(................) must be the first statement.Harish Chevuri
- Jun 3rd, 2011
three statements in jdbc1. statement : whic is used to execute select and non select queries.2. PreapreStatement : which is also used to execute select and non select queries but PrepareStatement whic...
-
SQL query using JDBC
When you execute a SQL query using JDBC, do you get a complete recordset or the partial recordset?
-
What Class.forName( ) method will do
Answered by Jey Ramasamy on 2005-05-10 05:50:07: Class.forName() is used to load the Driver class which is used to connect the application with Database. Here Driver class is a Java class provided by Database vendor.
sankalpshah06
- Jun 21st, 2011
It is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a Database.
ashwin1483
- May 15th, 2008
Class.forName is used to create an instance of the driver and register with the DriverManager.
-
How many statements can be created with one connection
Chaka
- Jun 13th, 2011
As many as you want, as long as it's one-at-a-time and you reset the Statement object after each usage:Statement st=con.createStatement(SQL_String1)ResultSet rs=st.executeQuery();//process rs herest.close();st=null;st=con.createStatement(SQL_String2)etcetc
manikant
- Oct 31st, 2005
No upper bound
-
JVM and JDBC Connectivity
Explain working of Java Virtual Machine (JVM)
Explain the working cycle of the JDBC-ODBC connectivity?Ashwinshenoy7
- May 9th, 2011
As the question says JVM and JDBC, let me tell you what JVM is initially,JVM is java virtual machine which is platform dependent but Java is platform independent and its source code can be executed on...
-
Difference between local and global transaction?
vinaymudgil007
- Jun 8th, 2010
The primary difference is that local transaction are single JVM level while global transaction are at multiple JVM level and hence global transactions need different design approach [which can be clas...
ak40732
- Mar 21st, 2006
A transaction is atomic unit of Work.The tasks which are made into the transaction act as a unit which can be executed successfully all,or if at least one task fails to its promise ,then the effect of...
-
Which of the following statement is true regarding the three tier model in the JDBC driver model architecture.
A) A middle tier is introduced in this model.B) Collection of SQL statements from the client and handing it over to the database.C) Maintaining control over accessing and updating of receiving results from database to the client.D) All of the above.
satheesh kumar. sriramaneni
- May 4th, 2006
A is the correct one.
-
ODBC & JDBC
What is the purpose of creating ODBC data source in establishing a connection between Java application & database?
sindhumsc
- Aug 24th, 2010
ODBC stands for open database connectivity which helps us to connect then link from Java to database..so if we want to connect from Java to any database one way is to use ODBC which helps to connect Java to any database (like Oracle, MySQL..).
JDBC Interview Questions
Ans