Difference between javax.sql and java.sql?

Question

What is the difference between javax.sql and java.sql I understand that javax.sql is for JavaEE. or am I wrong.

I am struggling with understanding this difference. And their usage scenarios.

Answer 1

What is the difference between javax.sql and java.sql I understand that javax.sql is for JavaEE.

It used to be that javax.sql was for JDBC extensions that were in Java EE and not Java SE, but this changed as of JDBC 3.

Now both packages are part of JDBC in Java SE, and the fact that there are two packages is now just a historical anomaly. The two packages continue to exist because removing one would cause backwards compatibility problems.

Answer 2

Java.sql

Provides the API for accessing and processing data stored in a data source (usually a relational database) using the JavaTM programming language.

. This API includes a framework whereby different drivers can be installed dynamically to access different data sources. Although the JDBCTM API is mainly geared to passing SQL statements to a database, it provides for reading and writing data from any data source with a tabular format. The reader/writer facility, available through the javax.sql.RowSet group of interfaces, can be customized to use and update data from a spread sheet, flat file, or any other tabular data source.

Javax.sql

Provides the API for server side data source access and processing from the JavaTM programming language. This package supplements the java.sql package and, as of the version 1.4 release, is included in the Java Platform, Standard Edition (Java SETM). It remains an essential part of the Java Platform, Enterprise Edition (Java EETM).