how to create single common class for jdbc connection pool

Asked Jan 23 '19 at 18:03

Active Jan 23 '19 at 18:09

Viewed 32 times

I am using jdbc connection pooling and i am getting the connection more than 100 place in the web application. how can i write the common code in single class and call, where required.

 Context initContext = new InitialContext();
 Context envContext = (Context)initContext.lookup("java:/comp/env");
 DataSource ds = (DataSource)envContext.lookup("jdbc/UserDB");
 Connection con = ds.getConnection();

edited Jan 23 '19 at 18:09

Ryuzaki L

37,302
12
68
98

asked Jan 23 '19 at 18:03

rajan kumar

1

Are you using a dependency injection framework like Spring? – Jose Martinez Jan 23 '19 at 18:16
Take a look at Spring JDBCTemplate, which is thread-safe (https://docs.spring.io/spring/docs/current/spring-framework-reference/data-access.html#jdbc-JdbcTemplate-idioms). – Woodchuck Jan 23 '19 at 18:19
@JoseMartinez i m using only jsp and servlet – rajan kumar Jan 24 '19 at 03:44

how to create single common class for jdbc connection pool

0 Answers0