Supraja

• Dec 10th, 2006

The new functionality in the core JDBC 2.0 API includes scrollable result sets, batch updates, programmatic inserts, deletes, and updates, performance hints, character streams for streams of internati...

sidd

• Aug 1st, 2006

Jdbc 2.0 provides RowSer where jdbc 1.0 dosn't

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

We have got dribers for that !!!Thanks,Vinay

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...

Answer Question  Select Best Answer

Can u give correct answer for this....!

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

public static Enumeration getDrivers() method in java.sql.DriverManager class will do this for us.Some more useful information below:public class DriverManager is the basic service for managing a set ...

Nitesh Gupta

• Sep 10th, 2007

Through MethodDriverManger.getDriver(url)  you will get the driver name.

Answer Question  Select Best Answer

koti

• Sep 9th, 2012

U store the object of a class in database. but database is meant for storing the values in the table format. for that reason only sun introduced JNDI for storing the object. by using this concept u can store the object in registry software. with that u can provide the global visibility also

jingboliu

• Sep 24th, 2007

1. Please make sure the java object is serializable2. Serialize the java object into a file3. Store the content of the file to relational database as Blob

Answer Question  Select Best Answer

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

sampra

 Profile Answers by sampra Questions by sampra

• Feb 11th, 2008

Here a and b can be used for (1,2) place respectivly.

sandeep.pandey15oct

 Profile Answers by sandeep.pandey15oct Questions by sandeep.pandey15oct

• Feb 10th, 2008

Here in given sample we can pass a and b fr place 1

Answer Question  Select Best Answer

Resultset objects follow index pattern ofa)Array standardb)java standardc)RDBMS standardd)c++ standarde)pl/sql standard

Mahendra

• Oct 20th, 2020

C

kittupeddi

 Profile Answers by kittupeddi Questions by kittupeddi

• Apr 10th, 2008

It should be 'Array standard'

Answer Question  Select Best Answer

How can we call a stored procedure in Java using CallableStatements? Give an example.

lilliput2009

 Profile Answers by lilliput2009 Questions by 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

 Profile Answers by pradeepkmr18 Questions by 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();

Answer Question  Select Best Answer

Explain with examples for SCROLLABLE_SENSITIVE resultset?

mohanpatil

 Profile Answers by mohanpatil Questions by 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

 Profile Answers by pradeepkmr18 Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by ashwin1483 Questions by 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

 Profile Answers by cvshankar Questions by cvshankar

• Apr 23rd, 2008

The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes made by others

Answer Question  Select Best Answer

Name the method that gives the existing isolation level in JDBC.

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by 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

 Profile Answers by awasie Questions by 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...

Answer Question  Select Best Answer

What must be done by the system administrator in order for a programmer to use the data source?

AMit bhati

• Mar 13th, 2016

Admin must ensure that he have created JNDI in JNDI registry of respective Server.

Code
InitialContext ic=new InitialContext();
DataSource ds=(DataSource)ic.lookUp(<name of jnti>);
Connection con=ds.getConnection();

ketan

• Feb 3rd, 2016

Using JDBC
jdbc:oracle:thin:@localhost:
con=ods.get connection ("---path---",1521----port number---:xe)

Answer Question  Select Best Answer

How to achieve a single value from web page to be updated/stored in many tables ?

sekhar

• Mar 15th, 2012

To update data in multiple table using single click ,we can go with triggers in database.we have different types of triggers like after insert,after update,after delete.Better using triggers.

G S

• Nov 4th, 2011

By using Transactions.

Every JDBC Driver will be able to perform Transactions. But its not recommended.

If we want to use out own Transactions we will set

con.setAutoCommit(false); and after executing the transactions we will execute con.commit();

Answer Question  Select Best Answer

Answered by Jey on 2005-05-10 06:01:10: Here are the steps.  Using DriverManager: 1. Load the driver class using class.forName(driverclass) and class.forName() loads the driver class and passes the control to DriverManager class 2.DriverManager.getConnection() creates the connection to the databse  Using DataSource. DataSource is used instead of DriverManager in Distributed...

safiya

• Oct 18th, 2005

First we register the connection and after that we connect the database, in that we give to which database is connecting giving that  ipaddress ,port number,username and password .

sudhakar

• Oct 15th, 2005

it has two steps:1.load the class by using class.forName2.register the driver by using DriverManager class

Answer Question  Select Best Answer

tgnanakumar

 Profile Answers by tgnanakumar Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by rameshvdnv Questions by 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();

Answer Question  Select Best Answer

Naim Kazi

• Feb 14th, 2006

But guys prepared statement has one disadvantage that it holds the data in the database. So when you execute a prepared statement for the first time, it will save the data in the database so that for ...

Anurjay Pradhan

• Nov 22nd, 2005

Prepared Statement is Pre-compiled class , but Statement is not.So in PreparedStatement the execution will be faster.

Answer Question  Select Best Answer

pavani

• Nov 14th, 2005

A single application can have one or more connections with a single database, or it can have connections with many different databases.A user can get information about a Connection object's datab...

Mamatha

• Oct 23rd, 2005

Meta Data- is information that describes about structure and properties of our data. When we define a table we specify each columns name, type of data it holds and restrictions imposed (Constraints) ...

Answer Question  Select Best Answer

A) Type - 1B) Type - 2C) Type - 3D) Type – 4

Hema chandra Reddy

• May 15th, 2006

Hi Type -4  is the best use

ak40732

 Profile Answers by ak40732 Questions by 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...

Answer Question  Select Best Answer

This involves two steps: (1) loading the driver and (2) making the connection.

shekarGeek

 Profile Answers by shekarGeek Questions by 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

 Profile Answers by rameshvdnv Questions by 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");

Answer Question  Select Best Answer

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

 Profile Answers by shekarGeek Questions by 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);

Answer Question  Select Best Answer