In establishing a connection is to have the appropriate driver connect to the DBMS. The following line of code illustrates the general idea:E.g.String url = "jdbc:odbc:Fred";Connection con = DriverManager.getConnection(url, "Fernanda", "J8");

Ramu Kondapalli

• Jul 18th, 2006

First You can lode the driver calssee into your program.This can be achived by the useing of follwing Code.Class.forName("oracle.jdbc.driver.OracleDriver");once the driver is avilable now u can get an...

kk

• Jul 6th, 2005

Connection con=DriverManager.getConnection(url,"Krish","k2");

Answer Question  Select Best Answer

First JDBC returns results in a ResultSet object, so we need to declare an instance of the class ResultSet to hold our results. The following code demonstrates declaring the ResultSet object rs.E.g.ResultSet rs = stmt.executeQuery("SELECT COF_NAME, PRICE FROM COFFEES");Second:String s = rs.getString("COF_NAME");The method getString is invoked on the ResultSet object rs , so getString will retrieve...

Siladitya Chatterjee

• Sep 29th, 2005

import java.sql.*;class JDBCtableread{ public static void main(String args[])throws Exception { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:dsn2";//dsn name ...

Sreekanth Chinthalapalli

• Jun 2nd, 2005

Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(SELECT COF_NAME, PRICE FROM COFFEES"); while (rs .next() ) {  //Iam assuming there are 3 columns in th...

Answer Question  Select Best Answer

The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure;E.g.CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");ResultSet rs = cs.executeQuery();

guptach

 Profile Answers by guptach Questions by guptach

• Sep 23rd, 2005

Stored Procedures can be called in java by using the prepareCall() method which returns a CallableStatement object.CallableStatement cs = con.prepareCall("{call Procedure_name}");ResultSet rs = cs.executeQuery();

Jaime

• Jul 17th, 2005

This document demonstrates how to return a JDBC ResultSet as REF CURSOR from a Java Stored Procedure. JDBC ResultSet is a table of data representing a database, which is usually generated by executing...

Answer Question  Select Best Answer

ramesh.sukka

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

Answer Question  Select Best Answer

agsuvidha

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

Answer Question  Select Best Answer

ss

• Nov 11th, 2005

in java program if we want execute a statment 1) load the driver by using Class.forname("driver")2) get connection by using driverManager.getConnection("DataSource")3) createStatement con.createStatement();4) execute the query n get resultset.

Karuna Rajesh

• Oct 2nd, 2005

Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery("select * from user");

Answer Question  Select Best Answer

mamatha03

 Profile Answers by mamatha03 Questions by mamatha03

• Oct 24th, 2005

Type-2 driver is Part Java Part Native Driver. This driver is a mixture of Jdbc driver and Vendor speciifc driver . You not only use ODBC to communicate with DataBase. You can also use Vendor specif A...

guptach

 Profile Answers by guptach Questions by guptach

• Sep 23rd, 2005

Type 2 driver is part Native-part Java driver. It is also one of the thin drivers. After the java calls are converted into JDBC calls by using the JDBC API, and those calls use the vendor specific API...

Answer Question  Select Best Answer

Ramesh

• Oct 18th, 2005

Invove getResultSet() method of the callableStatement object which is inherited from java.sql.Statement interface

Yahel Hamou Malkin

• Oct 7th, 2005

By invoking the getObject on the CallableStatement.CallableStatement proc = conn.prepareCall("{ ? = call " + functionSql + " }");proc.registerOutParameter(1, Types.OTHER);proc.execute();ResultSet results = (ResultSet) proc.getObject(1);

Answer Question  Select Best Answer

Mamatha

• Oct 23rd, 2005

Using binary streams (ie getBinaryStream() ,setBinaryStream()).But it is not visable in database ,it is stored in form of bytes ,to make it visable we have to use any one frontend tool.

a arun kumar

• Oct 3rd, 2005

We can store the image in the database using the blob(binary large object) data type, where the image is stored in the form of the streams...

Answer Question  Select Best Answer

Chaka

 Profile Answers by Chaka Questions by Chaka

• Jun 13th, 2011

As many as you want, as long as it's one-at-a-time and you reset the Statement object after each usage:Statement st=con.createStatement(SQL_String1)ResultSet rs=st.executeQuery();//process rs herest.close();st=null;st=con.createStatement(SQL_String2)etcetc

manikant

• Oct 31st, 2005

No upper bound

Answer Question  Select Best Answer

Supraja

• Dec 2nd, 2005

This link may be quite usefulhttp://www.precisejava.com/javaperf/j2ee/JDBC.htm#JDBC102

justAnother

• Nov 15th, 2005

The following is some information I could find on web regarding JDBC drivers:- The following website (not sure about the information) maintains a list of drivers and their usehttp://www.sqlsummit.com/...

Answer Question  Select Best Answer

A) SQLWarning objects are a subclass of SQLException that deal with database access warningsB) Warnings stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as plannedC) Connection object has a getWarning() method in it.D) Statement and ResultSet objects have getWarning() methods in it.Explanation: warning does not stop the execution of the...

anjudony

 Profile Answers by anjudony Questions by anjudony

• Apr 5th, 2006

No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded J...

Basavaraja.P.A

• Dec 20th, 2005

B].Warnings don't stop the execution of an application

Answer Question  Select Best Answer

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.

rmaghi@yahoo.com

 Profile Answers by rmaghi@yahoo.com Questions by rmaghi@yahoo.com

• Dec 13th, 2005

Answer: A

Answer Question  Select Best Answer

A) 1B) 2C) 1, 2D) Neither of the above

ravikumarzee@gmail.com

 Profile Answers by ravikumarzee@gmail.com Questions by ravikumarzee@gmail.com

• Feb 16th, 2006

Both 1 and 2 are correct. A static block is  written in every Driver class to register the driver, which gets executed when the class is loaded.

kiranreddy_zwx

 Profile Answers by kiranreddy_zwx Questions by kiranreddy_zwx

• Jan 9th, 2006

B

Answer Question  Select Best Answer

A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_WRITEExplanation: it is TRANSACTION_REPEATABLE_READ and not TRANSACTION_REPEATABLE_WRITE

srivanisama

 Profile Answers by srivanisama Questions by srivanisama

• May 31st, 2007

TRANSACTION_READ_UNCOMMITED  is correct answer i.e A

Answer Question  Select Best Answer

Supraja

• Dec 10th, 2006

As per JDBC architecture all four drivers are connection oriented

Answer Question  Select Best Answer

Atul Shelke

• Nov 29th, 2006

The osagent is a process that allows CORBA servers to register their objects and assists client applications in the location of objects. RMI Registry is a remote object registry started on the specifi...

Answer Question  Select Best Answer

surendra.java

 Profile Answers by surendra.java Questions by surendra.java

• Nov 28th, 2007

1st: register with drive2nd: make a connection3rd: write statement or procedurestatement4th: write a sql stmt using statement methods

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer

What is the functionality of the cancel() method, provided in java.sql.Statement?

bino75

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

Answer Question  Select Best Answer