All when i try and use the DBCP code i get the following error
java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool at complexcvfeed.OraThin.setupDataSource(OraThin.java:77) at complexcvfeed.OraThin.<init>(OraThin.java:35) ANd in my class OraThin line 77 i have public static DataSource setupDataSource(String connectURI) { BasicDataSource ds = null; ds = new BasicDataSource(); ds.setDriverClassName("oracle.jdbc.driver.OracleDriver"); ds.setUsername("user"); ds.setPassword("pass"); ds.setUrl(connectURI); return ds; } And 35 i have String dbUrl = "jdbc:oracle:thin:user/[EMAIL PROTECTED]:1521 :SID"; DataSource dataSource = setupDataSource(dbUrl); I have the commons-dbcp-1.2.1.jar in the class path, so i don't understand why it does not work