-
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 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...
-
Which of the following statement is false regarding the different type of statements in JDBC
A) Regular Statement (use createStatement method)B) Prepared statement (use prepareStatement method)C) Callable statement (use prepareCall).D) Interim statement (use jdbcCall).
-
Which of the following statements is true regarding the two tier model of the JDBC driver model.
A) In this java applications interact directly with the database.B) A JDBC driver is required to communicate with the particular database management system that is being accessed.C) This model is referred to as the client/server configuration where user is the client and the machine that has the database is called the user.D) All of the above.
sanjayg_mnit
- Jan 14th, 2009
B) A JDBC driver is required to communicate with the particular database management system that is being accessed.
satheesh kumar. sriramaneni
- May 4th, 2006
B is the correct one here.
-
State true or false .Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection ?
A) TrueB) FalseExplanation: You can open only one Statement object per connection when you are using the JDBC-ODBC Bridge.
kuldip2004
- Jan 23rd, 2009
No. You can open only one Statement object per connection when you are using the JDBC-ODBC Bridge.
virendra maurya
- May 29th, 2006
A
-
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
-
How to Make Updates to Updatable Result Sets?
Another new feature in the JDBC 2.0 API is the ability to update rows in a result set using methods in the Java programming language rather than having to send an SQL command. But before you can take advantage of this capability, you need to create a ResultSet object that is updatable. In order to do this, you supply the ResultSet constant CONCUR_UPDATABLE to the createStatement method.E.g.Connection...
kalyan789
- Apr 23rd, 2009
Following above answer, we can iterate through result set using, next() method and set corresponding column values for each row, using setInt/String/Float etc methods specifying column index or column name and value.Thankskalyan
Ashwini
- Oct 26th, 2005
New Features of JDBC2.0To make a updateble resultset use,Resultset.CONCUR_UPDATABLE
-
What are the flow statements of JDBC?
A URL string -->getConnection-->DriverManager-->Driver-->Connection-->Statement-->executeQuery-->ResultSet.
kalyan789
- Apr 23rd, 2009
I guess, order is like this1) load driver2) register driver to driver manager3) get connection from driver manager4) get statement object from connection5) create queries and execute them6) close connection
Suresh Pendyala
- May 8th, 2005
1). Register the Driver 2) load the Driver 3)get the connection 4) create the statement 5) Execute the query 6) fetch the results with ResultSet
-
Functionality of the cancel() method
What is the functionality of the cancel() method, provided in java.sql.Statement?
bino75
- Sep 16th, 2009
Cancels the Statement object if both the DBMS and driver support aborting an SQL statement. This method can be used by one thread to cancel a statement that is being executed by another thread.
-
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
A) TrueB) FalseExplanation: This is the new feature in the JDBC 2.0 API usage is Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
anitpatel
- Nov 6th, 2009
True. One has to call insertRow() programmatically to get the resultset data changes reflected in database. The CONCUR_UPDATABLE implementation can be driver specific. If driver does not support this mode of update, it will not allow the resultset update.
-
Call stored procedure in Java using CallableStatements
How can we call a stored procedure in Java using CallableStatements? Give an example.
lilliput2009
- Nov 18th, 2009
import java.sql.CallableStatement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class Sample{ public static void main(String[] args) &...
pradeepkmr18
- Jul 3rd, 2008
first get connection objectConnection con=DriverManager.getConnection(); (we can get by datasourse object also)CallableStatement cstmt=con.prepareCall("{ call procedurename(?,?,?,?) }");cstmt.setString(1,ID);cstmt.setString(2,name);....ucount=cstmt.executeUpdate();
-
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");
-
How do you implement Connection Pooling
tgnanakumar
- Apr 23rd, 2010
By using the J2EE servers like WebLogic, WebSphere, jBoss, Tomcat. We have to configure the data source object and connection pool object and supply the values as part of connection pool configu...
G.kirankumar
- Oct 6th, 2005
code for connecting the connection poolingInitalContext ic=new InitialContext();Hashtable ht=new Hashtable();ht.put("Context.INITIAL_PROVIDER",weblogic.jndi.InitialCla) //u have to set weblogic proper...
-
SCROLLABLE_SENSITIVE resultset
Explain with examples for SCROLLABLE_SENSITIVE resultset?
mohanpatil
- May 15th, 2010
If resultset is sensitive then using stmt.refreshRow() method, you get the updated data which is recently changed by other client in the database.
pradeepkmr18
- Jun 27th, 2008
Scrollable means the cursor can move forward or backward and Sensitive meansex:If u are using SCROLLABLE_SENSITIVE resultset i.e u have opened the result setIf any other person makes changes like inse...
-
JDBC-ODBC Bridge
When would you use a JDBC-ODBC Bridge?
vinaymudgil007
- Jun 7th, 2010
We use JDBC-ODBC bridge only when pure JDBC drivers are not available [say for connecting to a database] otherwise pure Java drivers are a good optoion.The use of JDBC-ODBC drivers isn't recommended v...
hsavinash2001
- May 26th, 2010
It is not recommended to use because of the dependency on native language (This is implemented in C++)
-
JDBC Isolation Level
Name the method that gives the existing isolation level in JDBC.
vinaymudgil007
- Jun 7th, 2010
Just to add more info to the above answer (public int getTransactionIsolation() throws SQLException from Connection interface) that their is always a trade-off between isolation level and concurrency ...
awasie
- Nov 14th, 2009
Isolation level represent how a database maintains data integrity against the problems like dirty reads, phantom reads and non-repeatable reads which can occur due to concurrent transactions. java.sql...
-
WasNull() method to handle null database fields
which of the following methods eliminates the need to call wasNull() method to handle null database fields?a)getObject()b)getInt()c)getString()d)getFloat()e)getNull()
vinaymudgil007
- Jun 8th, 2010
To my understanding, the question isn't framed properly. The answers given by two fellows above are ways to go around this situation but none eliminates the need to call wasNull().Other views are appreciated !!!
kittupeddi
- Apr 10th, 2008
Two Ways:1> Use the wasNull() method on the ResultSet.2> Use the getObject() method on the ResultSet and do the Comparision.
-
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 is the state of Connection object after execution of Statement(Populated Result Set)?
vinaymudgil007
- Jun 8th, 2010
The connection object is still open after the excecution unless explicitly closed by Connection.close() method.
venu
- Apr 10th, 2007
The connection object is still active, meaning it is ready to execute another statement.
-
ResultSet is an interface, How does it support rs.next()?
NAVEEN
- Jun 18th, 2007
Question: If Result Set is an interface, then why can we call methods like next(), isLast() etc. without defining the method body anywhere in the program? As I understand it, in an interface, methods...
JDBC Interview Questions
Ans