Session has been expired. Please
login again
.
Home
Interview
Online Test
Tutorial
Difference Between
Trending Topics
LIVE Mock Interviews
Sign Up
Login
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.
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
-->