JDBC

JDBC means for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

The JDBC library includes APIs for each of the tasks commonly associated with database usage:

•    Making a connection to a database
•    Creating SQL or MySQL statements
•    Executing that SQL or MySQL queries in the database
•    Viewing & Modifying the resulting records

WebSphere application server provide the JDBC with resource adapter ( Data source ) 

For Database connection with WebSphere application server we have to follow the below procedure : 

1.    Creating the Env variable for the jdbc client jar files 
2.    Creating the JDBC Provider.   

3.    Creating the DataSource.          

• Adding and modifying the Connection pool properties.