vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

The primary difference is that local transaction are single JVM level while global transaction are at multiple JVM level and hence global transactions need different design approach [which can be clas...

ak40732

 Profile Answers by ak40732 Questions by ak40732

• Mar 21st, 2006

A transaction is atomic unit of Work.The tasks which are made into the transaction act as a unit which can be executed successfully all,or if at least one task fails to its promise ,then the effect of...

Answer Question  Select Best Answer

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
 

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

Chidambara Gupta. Cheedella

• Sep 21st, 2005

Batch Updates are nothing but a bunch of updations that are done at a time without interruption. All the update statements are added to a Batch by using the addBatch() method and the Batch is&nbs...

sendil

• Sep 12th, 2005

we can add batch system using add.batch();

Answer Question  Select Best Answer

Prasanna V V

• Aug 31st, 2005

Also JDBC2.0 provides extended support for transactions that includes batch updates and savepoints

PChal

• Aug 11th, 2005

JDBC 2.0 Provides RowSet Implementation

Answer Question  Select Best Answer

The JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendors driver must provide implementations of the java.sql.Connection,Statement,PreparedStatement, CallableStatement, ResultSet and Driver.

pavan

• Feb 3rd, 2006

As has been mentioned above, the implementations are provided by the database vendors like for example, the classes12.jar of oracle which has the implementations.

Ravi

• Aug 23rd, 2005

In jdbc connecion is a interface , we are using the methods in that interface but we didnt provide any implementation where is the implementation? 

Answer Question  Select Best Answer

Create an instance of a JDBC driver or load JDBC drivers through jdbc.driversRegister a driverSpecify a databaseOpen a database connectionSubmit a queryReceive results

srilatha

• Jan 22nd, 2006

import java.sql.*;class Type1 { public static void main(String[] args)throws Exception {  Connection c=null;  try  {    Driver d=new Driver("sun....

Jayachandran

• Jan 3rd, 2006

Please Can any post the sample code for this set of operations. How do we register ?. Through DirverManager or what else ?

Answer Question  Select Best Answer

A URL string -->getConnection-->DriverManager-->Driver-->Connection-->Statement-->executeQuery-->ResultSet.

kalyan789

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

Answer Question  Select Best Answer

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

M.Nithiyanandhan

• Oct 17th, 2005

It is used tom initialize the driver .

deepak

• Sep 24th, 2005

class.forName()method create an  instance of specified driver, loads that driver, and then register that driver with the DriverManager class.

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer