-
What is Prepared Statements and How many types of Prepared Statements are there?
agsuvidha
- Aug 14th, 2007
Prepared statements are used whenever your pl/sql depends on the user input.suppose you want to insert some values in the table that you are taking from the text boxes in an applet connection con; Pre...
-
How can you create JDBC statements?
A Statement object is what sends your SQL statement to the DBMS. You simply create a Statement object and then execute it, supplying the appropriate execute method with the SQL statement you want to send. For a SELECT statement, the method to use is executeQuery. For statements that create or modify tables, the method to use is executeUpdate. E.g. It takes an instance of an active connection to create...
trinadh gantla
- May 3rd, 2007
Using Statement interface we can create JDBC statements as follows Statement stmt=con.createStatement();here con is the connection object reference Different types of statements are Prepa...
rameshvdnv
- Apr 25th, 2007
Class.forName("oracle.jdbc.driver.OracleDriver");Connection con;con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");Statement stmt=con.createStatement();
-
Which of the following is not an isolation level in the JDBC.
A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_WRITEExplanation: it is TRANSACTION_REPEATABLE_READ and not TRANSACTION_REPEATABLE_WRITE
-
What are the steps involved in establishing a connection?
This involves two steps: (1) loading the driver and (2) making the connection.
shekarGeek
- Jul 25th, 2007
Steps to follow establish a connection1.import required(sql) package.import java.sql.*;import javax.sql.*;javax.sql-----------------------1Data source 2Connection pooling 3Distributed transactions 5Ro...
rameshvdnv
- Apr 25th, 2007
1)Register the driver with the drivermanagerDriver drv=new oracle.jdbc.driver.OracleDriver();Drivermanager.registerDriver(drv);Connection con=Drivermanager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");
-
-
How can you load the drivers?
Loading the driver or drivers you want to use is very simple and involves just one line of code. If, for example, you want to use the JDBC-ODBC Bridge driver, the following code will load it:Eg.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Your driver documentation will give you the class name to use. For instance, if the class name is jdbc.DriverXYZ , you would load the driver with the following line...
sudhakar
- Sep 9th, 2007
by using:Class.forName("oracle.jdbc.driver.OracleDriver");Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");in the above way we can load the drivers.
shekarGeek
- Jul 25th, 2007
There are 2 ways to load the dirvers1.By usiing Class.forName();Ex- Class.forName("jdbc.odbc.OracleDriver");2.By using DriverManager.Driver thind=new Driver("jdbc:odbc:OracleDriver");DriverManager.registerDriver(thind);
-
-
How to Create SQL Server database through Java code?
surendra.java
- Nov 28th, 2007
1st: register with drive2nd: make a connection3rd: write statement or procedurestatement4th: write a sql stmt using statement methods
-
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...
-
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 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 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
-
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...
-
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...
-
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.
-
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 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
-
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...
-
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 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
JDBC Interview Questions
Ans