-
Difference between Type-2 and Type-3 driver
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
- 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...
-
How to call a Stored Procedure from JDBC?
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
- 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...
-
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
-
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.
-
What is JDBC?
JDBC is a layer of abstraction that allows users to choose between databases. It allows you to change to a different database engine and to write to a single API. JDBC allows you to write database applications in Java without having to concern yourself with the underlying details of a particular database.
guptach
- Sep 22nd, 2005
JDBC is a core API of Java 1.1 and later which provides a standard set of interfaces to SQL-compliant databases.
Jaime
- Jul 17th, 2005
Call-level interfaces such as JDBC are programming interfaces allowing external access to SQL database manipulation and update commands. They allow the integration of SQL calls into a general programm...
-
How to call ejb from Struts
Purushotham2007
- Oct 29th, 2008
Yes, we use Service locator design pattern We can call from Action Calss through JNDI to home object. then call remote object from home object
kiran
- May 19th, 2007
Yeah I too agree with this, Here action class is client for EJBFirst get home interface object using JNDI then call remote interface reference variable and continue.
-
What is the difference between Struts 1.0 and Struts 1.1
Prabhakar122
- Nov 3rd, 2010
Struts 1.1 new features are:====================1) Method perform() replaced by execute() in Struts base Action Class2) Declarative exception handling3) Dynamic ActionForms4) The Struts Validator5) De...
raj.ntrj
- Nov 11th, 2008
The new features added to Struts 1.1 are 1. RequestProcessor class 2. Method perform() replaced by execute() in Struts base Action Class3. Changes to web.xml and struts-config.xml4.Declarative excepti...
-
What is Struts
Answered by asreeni on 2005-04-08 03:24:40: The core of the Struts framework is a flexible control layer based on standard technologies like Java Servlets, JavaBeans, ResourceBundles, and XML, as well as various Jakarta Commons packages. Struts encourages application architectures based on the Model 2 approach, a variation of the classic Model-View-Controller (MVC) design paradigm. Struts...
vana_mlk
- Jul 2nd, 2010
I worked with struts it completely MVC base. I used SHINE pattern. It is a MVC base too. Actually it is an open source project to implement J2EE application.
satyanandr
- Sep 11th, 2009
Apache Struts is a frame work build on several design patterns like MVC, FrontController, Factory, Singleton etc., It is most suitable framework to develop web based applications, because this f...
-
-
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...
