java Connection Pooling from Oracle

Question

I'm trying to make a connection pool following this link: http://192.9.162.55/developer/onlineTraining/Programming/JDCBook/conpool.html

I don't understand something: Somewhere in the class JDCConnectionDriver implements Driver you can find this method:

public static final String URL_PREFIX = "jdbc:jdc:";
public Connection connect(String url, Properties props) 
                                   throws SQLException {
    if(!url.startsWith(URL_PREFIX) {
         return null;
    }
    return pool.getConnection();
}

so, if you use mysql (for example), the url it will always start with jdbc... so the method connect it will never return you a connection... Why is that?

Also I would like to ask you which is the best connection pooling framework...

c3p0 is a good connection pooling framework as well.

Rocky Pulley
– Rocky Pulley

2011-07-01 12:34:07 +00:00
Commented Jul 1, 2011 at 12:34 — Rocky Pulley
– Rocky Pulley, Commented Jul 1, 2011 at 12:34

Community · Accepted Answer · 2017-05-23 12:13:20Z

1

so, if you use mysql (for example), the url it will always start with jdbc... so the method connect it will never return you a connection... Why is that?

This driver is specifically written to connect to a JDC Connection. That's why. It's looking for a url starting with jdbc:jdc: and not just jdbc:.

Also I would like to ask you which is the best connection pooling framework...

The most well known Connection Pooling library out there and used on many application servers and servlet containers is Apache Object Pool. The most common connection pooling is Apache DBCP (DataBase Connection Pooling).

Also, as stated by Rocky Triton, c3p0 is another JDBC library that included Connection and Statement Pooling.

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Jul 1, 2011 at 12:11

Buhake Sindi

89.5k30 gold badges176 silver badges234 bronze badges

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

1 Comment

spauny Over a year ago

Ok, i understood... Though the answers are reversed :)

Collectives™ on Stack Overflow

java Connection Pooling from Oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related