How to get DB connection using DataSource without JNDI?

Question

We want to have our own db connection configuration instead of using JNDI, but at the same time we also want to use DataSource instead of using DriverManager, how to do it?

Answer 1

You are using a connection pool library, such as c3p0 or dbcp commons .

C3p0

ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setDriverClass( "org.postgresql.Driver" ); //loads the jdbc driver cpds.setJdbcUrl( "jdbc:postgresql://localhost/testdb" ); cpds.setUser("dbuser"); cpds.setPassword("dbpassword"); Connection connection = cpds.getConnection(); 

DBHP

 BasicDataSource ds= new BasicDataSource(); ds.setDriverClassName("org.postgresql.Driver"); ds.setUrl("jdbc:postgresql://localhost/testdb"); ds.setUsername("dbuser"); ds.setPassword("dbpassword"); Connection connection = ds.getConnection(); 

Answer 2

You can use org.apache.commons.dbcp.BasicDataSource

 BasicDataSource ds= new BasicDataSource(); ds.setDriverClassName("oracle.jdbc.driver.OracleDriver"); ds.setUrl("jdbc:oracle:thin:@dburl:port:sid"); ds.setUsername("uname"); ds.setPassword("pass");