Exams Attended

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Difference between JDBC 3.0 and JDBC 4.0

JDBC 3.0JDBC 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.
Is it helpful? Yes No

Get differences from below

JSF vs JSPJSP vs ServletsJSP vs ASP
JSF 1.2 vs JSF 2.0JSF 2.0 vs JSF 2.1Java 5 vs Java 6
Java 6 vs Java 6 update 10Java 6 vs Java 7Java 6 update 10 vs Java 6 update 12
Java 1.0 vs Java 1.1Java 1.1 vs Java 1.2Java 1.2 vs Java 1.3
Java 1.3 vs Java 1.4Java 1.4 vs Java 5Struts 1 vs Struts 2
Struts 1.1 vs Struts 1.2Struts 1.2 vs Struts 1.3Linux vs Unix
C vs C++Java vs C++Java vs J2EE
Java vs KotlinStruts vs JSFStruts vs Spring
Spring vs Spring BootApache vs IISJboss vs Tomcat
Jboss vs WebLogicWebLogic vs WebsphereJavaScript vs Jquery
JavaScript vs VBScriptJquery vs AngularJSHTML vs XML
HTML vs XHTMLHTML vs DHTMLHTML 5 vs HTML 4
Java 7 vs Java 8EJB 2.0 vs EJB 3.0EJB 3.0 vs Spring
JDBC vs HibernateJDBC vs JPAJDBC 3.0 vs JDBC 4.0
CSS 2 vs CSS 3EJB 1.0 vs EJB 2.0AWT vs Swing
Swing vs AppletPHP vs JSPJ2EE vs J2ME
Java 8 vs Java 9JPA vs HibernateMVC 1 vs MVC 2
Hibernate 3 vs Hibernate 4Spring 3.0 vs Spring 4.0Java 9 vs Java 10
jQuery Mobile vs BootstrapJavaBeans vs EJBJSON vs XML
RESTful Web Services vs SOAP Web ServicesSpring 2.5 vs Spring 3.0HTTP vs HTTPS
AngularJS vs NodeJSNodeJS vs JavaNodeJS vs Spring Boot
NodeJS vs GolangPaaS vs IaaSSaaS vs PaaS
SaaS vs IaaSOn-Premise vs Cloud ComputingMonolithic vs Microservices
Java 10 vs Java 11Spring MVC vs Spring BootGolang vs Java
Python vs JavaAWS vs AzureAWS vs Google Cloud/GCP
Ansible vs TerraformAnsible vs PuppetPuppet vs Terraform
OpenID Connect vs OAuth 2.0SAML vs OpenID ConnectJava 11 vs Java 12
Java 12 vs Java 13Java 13 vs Java 14Java 14 vs Java 15
Java 15 vs Java 16
©2021 WithoutBook