Java Datasource will be used to get JDBC connection in Spring java framework. There are a different ways of getting JDBC connection using DataSource in the java Spring framework and every approach has some meaning, so we should know where should be used what? and how this will be the best practices? Getting of DataSource is very easy in the Spring application framework.
1. Maven Dependency for java datasource
Spring JDBC dependency
org.springframework spring-context 4.0.2.RELEASE org.springframework spring-tx 4.0.2.RELEASE org.springframework spring-jdbc 4.0.2.RELEASE
Maven for MySql dependency to get datasource in java
mysql mysql-connector-java 5.0.5
DBCP DataSource dependency
org.apache.commons commons-dbcp2 2.1
2. Get Java Datasource using Driver Manager
We should use the
DriverManagerDataSource class should only be used for testing purposes since it does not provide pooling and will perform poorly when multiple requests for a connection are made. Another best part for testing we do not need to add addition maven dependency like basicDataSource or c3po datasource.
Meta data Bean Configuration as:
Corresponding Java class configuration as:
DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("org.hsqldb.jdbcDriver"); dataSource.setUrl("jdbc:hsqldb:hsql://localhost:"); dataSource.setUsername("sa"); dataSource.setPassword("");
3. Get Datasource from DBCP configuration
Basic dataSource has capability to pool connection and it’s industry standard to use in the project.
XML bean configuration as :
4. Get datasource from C3PO Configuation
How to get java datasource and its XML bean configuration for C3PO configuration as follows and pull dependency from maven repository.
Your suggestions are welcome to encourage us to write further. Happy Learning 🙂