Connection pooling in java example with oracle

• Oracle connection pool example
• Java connection pooling
• Oracle database connection with JDBC
• Implementing  own Connection pooling in Java
• how to implement connection pooling in java with example

Here we are creating a class and declaring all database information. This call will execute only one time at the program beaning. If you are using Web server, this call will execute one time at the beginning of the server start. 

1. 
   
2. import java.sql.Connection;
3. import java.sql.DriverManager;
4. import java.sql.ResultSet;
5. import java.sql.SQLException;
6. import java.sql.Statement;
7. 
   
8. public class ConnectionPool {
9. static Connection con;
10. static Statement st;
11. static{
12. try {
13. Class.forName("oracle.jdbc.driver.OracleDriver");
14. } catch (ClassNotFoundException e) {
15. e.printStackTrace();
16. }
17. try {
18. con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/XE","system","8040");
19. st=con.createStatement();
20. } catch (SQLException e) {
21. e.printStackTrace();
22. }
23. 
    
24. }
25. 
    
26. }

    After Database connection successfully establish , you can use statement  object for other transaction. 

Example

1. import java.sql.ResultSet;
2. import java.sql.SQLException;
3. 
   
4. 
   
5. public class TestConnectionPoll {
6. 
   
7. public static void main(String[] args) throws SQLException {
8. ResultSet rs=ConnectionPool.st.executeQuery("select * from root.website");
9. while(rs.next()){
10. System.out.println(rs.getString(1));
11. }
12. }
13. 
    
14. }