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

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