Difference between JDBC 3.0 and JDBC 4.0

JDBC 3.0 Interview Online Test	JDBC 4.0 Interview Online Test
Features: - 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. - 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.	Features: - Auto- loading of JDBC driver class: In JDBC 4 invoking the getConnection() on DriverManager will automatically load a driver. - Connection management enhancements: In jdbc it may happen that a Connection is lying idle or not closed in a pool, then it became stale over time. This will led to the connection pool run out of resources due to stale connection. - Support for RowId data type: JDBC introduces support for ROWID, a data type that had been in use in database products even before it became part of the SQL. - SQL exception handling enhancements: JDBC 4 addresses the error handling beautifully. As databases are often remotely accessible resources, problems such as network failures is common and it can cause exceptions when executing a database operation. SQL statements can also cause exceptions. Prior to JDBC 4, most JDBC operations generated a simple SQLException. - SQL XML support. - DataSet implementation of SQL using Annotations: The JDBC 4.0 specification leverages annotations to allow developers to associate a SQL query with a Java class without a need to write a lot of code to achieve this association.

JDBC 3.0

JDBC 4.0

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

Features:
- Auto- loading of JDBC driver class: In JDBC 4 invoking the getConnection() on DriverManager will automatically load a driver.
- Connection management enhancements: In jdbc it may happen that a Connection is lying idle or not closed in a pool, then it became stale over time. This will led to the connection pool run out of resources due to stale connection.
- Support for RowId data type: JDBC introduces support for ROWID, a data type that had been in use in database products even before it became part of the SQL.
- SQL exception handling enhancements: JDBC 4 addresses the error handling beautifully. As databases are often remotely accessible resources, problems such as network failures is common and it can cause exceptions when executing a database operation. SQL statements can also cause exceptions. Prior to JDBC 4, most JDBC operations generated a simple SQLException.
- SQL XML support.
- DataSet implementation of SQL using Annotations: The JDBC 4.0 specification leverages annotations to allow developers to associate a SQL query with a Java class without a need to write a lot of code to achieve this association.

Related differences

JDBC 3.0 vs JDBC 4.0

Is it helpful? Yes No

Get differences from below

JSF vs JSP	JSP vs Servlets	JSP vs ASP
JSF 1.2 vs JSF 2.0	JSF 2.0 vs JSF 2.1	Java 5 vs Java 6
Java 6 vs Java 6 update 10	Java 6 vs Java 7	Java 6 update 10 vs Java 6 update 12
Java 1.0 vs Java 1.1	Java 1.1 vs Java 1.2	Java 1.2 vs Java 1.3
Java 1.3 vs Java 1.4	Java 1.4 vs Java 5	Struts 1 vs Struts 2
Struts 1.1 vs Struts 1.2	Struts 1.2 vs Struts 1.3	Linux vs Unix
C vs C++	Java vs C++	Java vs J2EE
Java vs Kotlin	Java vs .NET	Struts vs JSF
Struts vs Spring	Spring vs Spring Boot	Apache vs IIS
Jboss vs Tomcat	Jboss vs WebLogic	WebLogic vs Websphere
JavaScript vs Jquery	JavaScript vs VBScript	JavaScript vs TypeScript
Jquery vs AngularJS	HTML vs XML	HTML vs XHTML
HTML vs DHTML	HTML 5 vs HTML 4	Java 7 vs Java 8
EJB 2.0 vs EJB 3.0	EJB 3.0 vs Spring	JDBC vs Hibernate
JDBC vs JPA	JDBC 3.0 vs JDBC 4.0	CSS 2 vs CSS 3
EJB 1.0 vs EJB 2.0	AWT vs Swing	Swing vs Applet
PHP vs JSP	J2EE vs J2ME	Java 8 vs Java 9
JPA vs Hibernate	MVC 1 vs MVC 2	Hibernate 3 vs Hibernate 4
Spring 3.0 vs Spring 4.0	Java 9 vs Java 10	jQuery Mobile vs Bootstrap
JavaBeans vs EJB	JSON vs XML	RESTful Web Services vs SOAP Web Services
Spring 2.5 vs Spring 3.0	HTTP vs HTTPS	AngularJS vs NodeJS
AngularJS vs Angular	NodeJS vs Java	NodeJS vs Spring Boot
NodeJS vs Golang	PaaS vs IaaS	SaaS vs PaaS
SaaS vs IaaS	On-Premise vs Cloud Computing	Monolithic vs Microservices
Java 10 vs Java 11	Spring MVC vs Spring Boot	Golang vs Java
Python vs Java	AWS vs Azure	AWS vs Google Cloud/GCP
Ansible vs Terraform	Ansible vs Puppet	Puppet vs Terraform
OpenID Connect vs OAuth 2.0	SAML vs OpenID Connect	Java 11 vs Java 12
Java 12 vs Java 13	Java 13 vs Java 14	Java 14 vs Java 15
Java 15 vs Java 16	Java 16 vs Java 17	Python 2 vs Python 3
RDBMS vs Hadoop	Angular vs React	Java 17 vs Java 18
GraphQL vs RESTful Web Services (REST API)	RESTful Web Services (REST API) vs gRPC	Android vs iOS
TikTok vs Instagram	Instagram vs YouTube	TensorFlow vs PyTorch
OracleJDK vs OpenJDK