-
What is the purpose of setAutoCommit( )
raghuprasad
- Nov 24th, 2008
SetAutoCommit(false); disables the default commit mode. we need to explicitly commit the transaction.
dkiranmai
- Nov 21st, 2008
If a connection is in auto-commit mode, then all its SQL statements are run and commited as individual transactions. Otherwise, its SQL statements are grouped into transactions that are ended by a cal...
-
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...
-
JDBC Type1 drivers
Can we use Type1 driver in web Application?If possible give me a simple example for all driver types?
timmireddy
- Jul 15th, 2008
Yes , u can use JDBC type-1 driver for web application but here need to upload many Database libraries for middleware interaction purpose.
timmireddy
- Jul 14th, 2008
There are four types of JDBC drivers, Type1 driver is not purely java driver, here we can uploaded so many databse libraries ( these are the middleware softwares).So better to use type-4 driver (also called Oracle thin driver )
-
What is a transaction
Answered by anoop shukla on 2005-05-02 10:33:27: transaction is collection of logical operation that perform a task
-
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.
-
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.
-
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?
-
How can i connect oracle database from java program ? explain the steps with one example?
shalini shivhare
- Dec 26th, 2009
Step 1: Import JAVA Package:- import java.sql.*; Step 2: Register the driver with the following command:- Class.For.Name("sun.jdbc.odbc.JdbcOdbcDriver"); Step 3:- Create the connection with ...
RajNair
- Feb 9th, 2007
DriverManager.registerDriver(new Oracle:jdbc:OracleDriver());Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "scott", "tiger");
-
-
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...
-
What is the difference between executeUpdate() and executeQuery() in JDBC ?
Manohar
- Nov 2nd, 2012
ExecuteUpdate() is ment for Non-Select Statements,,and it returns Update Count as an int value.
executeQuery() is ment for Select Statements, and it returns ResultSet.MeenaDeepak
- May 21st, 2012
ExecuteQuery() is used for Select statements.
executeUodate() is used for insert,update,delete statements.. -
What is stored procedure. How do you create stored procedure
pradeepkmr18
- Jul 3rd, 2008
Stored procedure contains set of sQL Statements thar are executed in the database by the sql stament processor.code:DECLARE NUM1 NUMBER:=10; NUM2 NUMBER:=20;BEGIN DBMS_OUTPUT.PUT_LINE('sum:'||To_Char(NUM1+NUM2,'999.99'));END;
Hameed
- Oct 12th, 2005
Stored Procedure is an object design with business logic and stored in the database .Since it stays in the database ,the execution of the business logic is more faster...
-
How can you use PreparedStatement?
This special type of statement is derived from the more general class, Statement. If you want to execute a Statement object many times, it will normally reduce execution time to use a PreparedStatement object instead. The advantage to this is that in most cases, this SQL statement will be sent to the DBMS right away, where it will be compiled. As a result, the PreparedStatement object contains not...
kalyan789
- Apr 23rd, 2009
Following above answer, we can set input values by specifying column index (index starts from 1) and value using corresponding Java set methods like setInt/String/Float etc.
sampra
- Feb 11th, 2008
If we have to use palce holder mechnaism and pass compiled query in the sql engine the we use prepares stament.For one prepared stmt we can use only one query
-
Which of the following allows phantom read in JDBC, connection class?
A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A phantom read is where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction re-reads for the same condition, retrieving the additional 'phantom' row in the second...
sanky
- Jun 3rd, 2014
Charankk, please read question carefully. We need ans for which allows phantom read. We dont need ans for which does not allows. Ans is A,B,D
pradeepkmr18
- Jul 3rd, 2008
These will allow phanthom readRead_uncommitedRead_commitedRepeatable_read
-
-
What is the difference between store procedures and prepared statement?
vinaymudgil007
- Jun 8th, 2010
To be straightforward, we can only compare two things when they are in the same scope/domain. This question says to differentiate b/w SPs and prepared statements isn't valid.Stored Procs are persi...
subhankar1982
- Feb 21st, 2009
Generally procedure and functions are written in PL/SQL code and it will reside in databases. When we develop some application in Java using JDBC to deal with specific databases for specific purpose...
-
What's going on
Is the driver get registred then where it is inintialized, if it is initialized & registerde there only, How?">In the Statement below class.forName(" ---");What's going onIs the driver get registred then where it is inintialized, if it is initialized & registerde there only, How?
vinaymudgil007
- Jun 8th, 2010
class.forName(" Any Class Name Here") is a static method in Class class which returns the Class object associated with the class or interface with the given string name.....So when I say cl...
subhankar1982
- Feb 21st, 2009
Every JDBC driver vendor providing a static block for Driver classprovided by vendor. Which taking care of creating driver class object and registaring driver class , so instead of writing code Ex:- D...
-
What are the two major components of JDBC?
One implementation interface for database manufacturers, the other implementation interface for application and applet writers.
sujatham
- Feb 7th, 2008
JDBC has four major components:1.The JDBC API2.The JDBC Driver Manager3.The JDBC Test Suite4.The JDBC-ODBC Bridge The first two components of JDBC,the JDBC API and the JD...
Vasavi
- Sep 18th, 2007
The two major components of JDBC are 1. JDBC API: is a programming interface for database application developers, and2. JDBC Driver API: is a lower-level programming interface for developers of specific drivers.
-
Which of the following allows non repeatable read in JDBC, connection class?
A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A non-repeatable read is where one transaction reads a row, a second transaction alters or deletes the row, and the first transaction re-reads the row,getting different values the second time.
-
What is thin driver and thick driver. Why it is called so?
prakash reddy
- Apr 21st, 2008
Major differences the number layers present between the java application and database
asmita das
- Sep 7th, 2006
thick driver - type 1 and type 2 JDBC drivers are called thick drivers. The reason for it is - it provides JDBC access via ODBC drivers. ODBC binary code, and in many cases, database client code, must...
JDBC Interview Questions
Ans