How to retrieve DB connection using DataSource without JNDI?

Question

We want our own db connection configuration instead of using JNDI, but in the meantime, we also want to use DataSource instead of using DriverManager, how to do so?

have a look at c3p0 or commons dbcp connection poolers

Arun P Johny
– Arun P Johny

2013-03-22 08:20:05 +00:00
Commented Mar 22, 2013 at 8:20 — Arun P Johny
– Arun P Johny, Commented Mar 22, 2013 at 8:20

Greg Brown · Accepted Answer · 2019-01-25 19:24:08Z

7

You use a connection pool library like c3p0 or commons dbcp.

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();

DBCP

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();

edited Jan 25, 2019 at 19:24

Greg Brown

3,3222 gold badges29 silver badges40 bronze badges

answered Mar 22, 2013 at 8:32

Arun P Johny

389k68 gold badges532 silver badges532 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anubhab · Accepted Answer · 2013-03-22 08:26:34Z

3

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");

answered Mar 22, 2013 at 8:26

Anubhab

1,7862 gold badges18 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to retrieve DB connection using DataSource without JNDI?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related