[ https://issues.apache.org/jira/browse/DBCP-309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13027555#comment-13027555 ]
Phil Steitz commented on DBCP-309: ---------------------------------- Unfortunately, I think the right fix here is to drop the BasicDataSource example and resolve this issue, but open another one to make BasicDataSource implement Referenceable in 2.0. > First example for FSContext is invalid > -------------------------------------- > > Key: DBCP-309 > URL: https://issues.apache.org/jira/browse/DBCP-309 > Project: Commons Dbcp > Issue Type: Bug > Affects Versions: 1.2.2 > Reporter: Ondrej Tisler > Priority: Trivial > Fix For: 1.3.1, 1.4.1 > > > First example on page http://commons.apache.org/dbcp/guide/jndi-howto.html is > invalid, with this code every call of > InitialContext ic2 = new InitialContext(); > DataSource ds = (DataSource) ic2.lookup("jdbc/basic"); > Connection conn = ds.getConnection(); > conn.close(); > ends with new datasource with unclosed connection in it becase new > Reference("javax.sql.DataSource", > "org.apache.commons.dbcp.BasicDataSourceFactory", null); reference creates > new DataSource instead using created one while calling > ic2.lookup("jdbc/basic"). > At the end it ends with many opened connections to DB until JVM is ended. > Second example I didn't test, i use direct aproach with manualy creating > SharedPoolDataSource and registring it in FSContext JNDI itself. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira