-
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
-
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
-
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
-
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
-
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.
-
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).
-
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...
-
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 )
-
Which is the best driver among the 4 jdbc drivers?how can we load that driver?
arun kumar
- Dec 7th, 2005
Hi, there, the order in which the drivers can be used is 4213, :) bye
-
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...
-
Which Driver is preferable for using JDBC API in Applets.
A) Type - 1B) Type - 2C) Type - 3D) Type – 4
Hema chandra Reddy
- May 15th, 2006
Hi Type -4 is the best use
ak40732
- Mar 21st, 2006
As we know that applets has many restrictions on the remote machine on which they are executed.But they can make connections to the server from which they have been originated.As the database obviousl...
-
Which of the following is true regarding the use of the JDBC-ODBC bridge with the applets.
A) Use of the JDBC-ODBC bridge from an untrusted applet running in a browser, such as Netscape Navigator, isn't allowed.B) It is possible to use the JDBC-ODBC bridge with applets that will be run in appletviewer since appletviewer assumes that applets are trusted.C) It is not possible to use the JDBC-ODBC bridge with applets that are run in the HotJavaTM browser (available from Java Software), since...
taramesquita
- May 22nd, 2008
It is not possible to use the JDBC-ODBC bridge with applets that are run in the HotJavaTM browser (available from Java Software), since HotJava provides an option to turn off applet security.
rajagopal
- Mar 10th, 2006
Answer is D
-
Connection pooling concept through weblogic 8.1
Hi,I tried using connection pooling concept through weblogic 8.1 .import java.sql.*;import javax.naming.*;import javax.sql.DataSource;public class ConnectionpoolDemo { public static void main(String[] args) { try { InitialContext ic=new InitialContext(); Object obj=ic.lookup("MyDsJNDI"); DataSource ds=(DataSource)obj; Connection con=ds.getConnection(); Statement st=con.createStatement(); ResultSet...
ashwin1483
- May 15th, 2008
try using this code............import java.util.*;import java.sql.*;import javax.sql.*;import javax.naming.*;public class ConnectionPool{ public static void main(String args[]) { ...
cvshankar
- Apr 23rd, 2008
The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes made by others
-
Which of the following values can be replaced in the place of 1 and 2 belowStatement stmt = con.createStatement(1, 2);
A) ResultSet. TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLYB) ResultSet. TYPE_SCROLL_INSENSITIVE , ResultSet. CONCUR_UPDATABLEC) ResultSet. CONCUR_UPDATABLE,ResultSet. TYPE_SCROLL_SENSITIVED) ResultSet. CONCUR_UPDATABLE,ResultSet. TYPE_FORWARD_ONLY
sravan
- Jun 30th, 2006
A and Bbecause, the createStatement() method takes ResultSet Type as 1st argument and concurrency as 2nd argument. we cannot alter this.
-
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...
-
How to create Container Managed Persistance program in EJB and tell me the procedure to deploy in Weblogic server.
Abdul Gafoor
- Feb 12th, 2006
My name is Abdul Gafoor, I am a sun certified J2EE Developer.I am using Weblogic 8.1 server.Compile bean and interface program.create jar file.Before the deploy jar file.You must create connection poo...
-
Which of the following values can be replaced in the place of 1 and 2 below Statement
Which of the following values can be replaced in the place of 1 and 2 below Statement stmt= con.createStatement(1,2);a) ResultSet. TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLYb) ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLEc) ResultSet. CONCUR_UPDATABLE, ResultSet. TYPE_SCROLL_SENSITIVEd) ResultSet.CONCUR_UPDATABLE, ResultSet. TYPE_FORWARD_ONLY
-
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.
-
Changing function of a buttom.
Consider the following:-ID [_______]Name [_______]Marks [_______]NEW EDIT CLOSEThis is a form which I have made. What i need is When I click on NEW button, if textboxes should be cleared and the text on the NEW button should change to SAVE. the EDIT button should be disabled and CLOSE should change to CANCEL.I am able to change the text of the buttons using settext command...
ShahnawazSheikh
- Jan 15th, 2008
Hi Dude..It's a a very simple problem what u need to do is ..Let, JButton n1=new JButton("New"); n1.setActionCommand("New"); JButton n1=new JButton("Save&q...
-
What do you mean by priority of thread?
ramesh.sukka
- Dec 1st, 2007
Thread is dispatchable unit of work and Process is group of inter related threads. So when you start more than one process in single JVM, JVM will give default priority to all threads. If you want alt...
JDBC Interview Questions
Ans