|
|
Features of JDBC 3.0 API
- Reusabilty of prepared statements by
connection pools.
- In this version there is number of properties
defined for the ConnectionPoolDataSource. These properties can be
used to describe how the PooledConnection objects created by DataSource
objects should be pooled.
- A new concept has been added to this API is of savepoints:
One of the useful new features is transactional savepoints. With JDBC 3.0,
the transactional model is now more flexible. Now you can start a
transaction , insert several rows in it and then create a savepoint. This
savepoint serves as a bookmark. The application can rollback to the
savepoint and then commit the group of inserts as if the updates have never
been attempted. For eg:
Statement st=connection.createStatement();
int rowcount=st.executeUpdate("insert into employee
values("tim"));
int rowcoutn=st.executeUpdate("insert into salary values(20000.0);
Savepoint sv=connection.setSavePoint("savepoint");
//create save
point for inserts
int rowcount=st.executeUpdate("delete from employee");
connection.rollback(sv);
//discard the delete statement but keeps the
inserts
connection.commit();
//inserts are now permanent
- Retrieval of parameter metadata.
- It has added a means of retrieving values from
columns containing automatically generated values.
- Added a new data type i.e. java.sql.BOOLEAN.
- Passing parameters to CallableStatement.
- The data in the Blob and Clob can be
altered: JDBC 3.0 introduces a standard mechanism for updating BLOB
and CLOB data.
- DatabaseMetaData API has been added.
- It allows stored procedure parameters
to be called by name.
|
|
Facing Programming Problem?
|
| Add This
Tutorial To: |
Del.icio.us |
Digg |
Google |
Spurl |
Blink |
Furl |
Simpy |
Y! MyWeb |
|
|
Current Comments
4 comments so far (post your own) View All Comments Latest 10 Comments:Browse all Java Tutorials
Java
New to Java?
Learn Java In A Day
Learn Java Quickly
Java Tools
Beginners Java Tutorial
Master Java Tutorial (TOC)
Java IO Package Examples
Java AWT Package Examples
Swing Example
Java util Examples
Java Programming
JSP
Introduction to JSP
JSP Architecture
Introduction to the JSP tags
Features of JSP 2.1
JSP Fundamentals
Struts
Introduction to the Apache Struts
Struts Architecture
Introduction to the Struts Controller
Introduction to Struts 2
Struts 2 Features
Struts 2 History
Servlets
History of Web application
Introduction to Web Server
What is servlet?
Methods of Servlet
Advantages of Java Servlets
Hibernate
Introduction to Hibernate 3.0
Hibernate Architecture
Hibernate Update Query
Hibernate Count Query
Hibernate Projections
XML
XML : An Introduction
XML: An Introduction - Brief History
XML:Validation
Introduction to DTD
DTD:Document Type Definition
Ajax
What is Ajax?
Ajax Code Libraries and Tools
Ajax Login Example
JDBC
What is JDBC?
JDBC Driver and Its Types
Features of JDBC 3.0
EJB
Introduction to Application Server
Features of EJB 3.0
Message Driven Beans
MySQL
Introduction to MySQL
Installing MySQL on Windows
MySQL Configuration
JavaScript
What is JavaScript?
Statements In JavaScript
Functions in JavaScript
JSF
Introduction To JSF
JSF Releases
JSF Features
Maven2 Tutorial
An introduction to Maven 2
Maven 2: Features
Maven 2 Eclipse Plug-in
JEE5 Tutorial
Understanding JEE technologies
JEE 5 API
Deploying Application
Java Threading Tutorial
Overview of Thread
Thread Creation
Daemon Thread
Photoshop Tutorials
How to design a express realization mode
How to design a table lamp
Linux
Linux Tutorials
Linux CDs
Linux Distributions
Free Linux CDs
Technology
GPS
WiMAX
VoIP
WiFi
HSDPA
Tech. What is?
Technology Revolutions
Rich Internet Application
Web 2.0
Web 3.0
JavaFX
Eclipse
About IDE
Creating a Project
Spring Tutorial
Introduction to the Spring Framework
Bioinformatics Tutorials
History of Bioinformatics
Tools
Junit
Jmeter
DBUnit
SQL
SQL: A brief Introduction
Create a database
Posted by Dhiraj on Tuesday, 04.29.08 @ 15:11pm | #58115
give me a one project in jsp and servlet pls
send me
Posted by dharmendra kumar on Thursday, 12.27.07 @ 10:09am | #43921
thank's its a nice note but is there any complete sample example
Posted by anish chapagain on Thursday, 11.8.07 @ 02:51am | #36464
good, Thanks.
Posted by Lakshmi on Thursday, 06.7.07 @ 01:14am | #18439