[JAVA - DBCP] Problema con i driver jdbc

[magix2003]

Ciao a tutti,

è due giorni che cerco di implementare il connection pooling nella mia web-application. Per questo utilizzo la libreria DBCP di apache.

Il problema è che mi ritorna sempre la solita eccezione al momento di creare il data-source, cioè non riesce a trovare il driver. Con la classe che utilizzavo prima (senza connection-pooling) questo problema non lo avevo, ed il driver è sempre nella build-path in netbeans.

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package it.unibz.inf.wobda.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.tomcat.dbcp.dbcp.BasicDataSource;
import javax.sql.DataSource;

/**
 *
 * @author giorgio
 */
public class DBPool {

    public static DataSource theDataSource;

    public static void setUpDatasource(WonderDataSource theSource) throws ClassNotFoundException {
        Class.forName(theSource.getDriver());
        BasicDataSource ds = new BasicDataSource();
        ds.setDriverClassName(theSource.getDriver());
        ds.setUsername(theSource.getUser());
        ds.setPassword(theSource.getPwd());
        ds.setUrl(theSource.getDriver());
        theDataSource = ds;
    }

    public static void getDataSourceStats(DataSource ds) throws SQLException {
        String res = "";
        BasicDataSource bds = (BasicDataSource) ds;
        res += "NumActive: " + bds.getNumActive() + "\n";
        res += "NumIdle: " + bds.getNumIdle();
    }

    public static void shutdownDataSource(DataSource ds) throws SQLException {
        BasicDataSource bds = (BasicDataSource) ds;
        bds.close();
    }

    public static Connection getConnection() throws SQLException {
        return theDataSource.getConnection();
    }

    public static void executeQuery(QueryMediator aMediator, String sql) throws SQLException {
        aMediator.setStmt(aMediator.getConn().createStatement());
        aMediator.setRset(aMediator.getStmt().executeQuery(sql));
    }
}

GRAVE: QueryManager: SQLException
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'oracle.jdbc.driver.OracleDriver'
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at it.unibz.inf.wobda.db.DBPool.getConnection(DBPool.java:46)
	at it.unibz.inf.wobda.queryprocessing.obda.OBDAInterface.query(OBDAInterface.java:106)
	at it.unibz.inf.wobda.queryprocessing.obda.OBDAInterface.performQuery(OBDAInterface.java:98)
	at it.unibz.inf.wobda.servlets.queryanswering.QueryManager.processRequest(QueryManager.java:90)
	at it.unibz.inf.wobda.servlets.queryanswering.QueryManager.doPost(QueryManager.java:189)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:279)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
	... 20 more

Vi prego aiutatemi, non so più che pesci pigliare.


Giorgio

[magix2003]

C'era un piccolo errore nella dichiarazione di un import, ora ho modificato ma il risultato finale è sempre lo stesso

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package it.unibz.inf.wobda.db;

import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbcp.BasicDataSource;
import javax.sql.DataSource;

/**
 *
 * @author giorgio
 */
public class DBPool {

    public static DataSource theDataSource;

    public static void setUpDatasource(WonderDataSource theSource) throws ClassNotFoundException {
        BasicDataSource ds = new BasicDataSource();
        ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
        ds.setUsername(theSource.getUser());
        ds.setPassword(theSource.getPwd());
        ds.setUrl(theSource.getDriver());
        theDataSource = ds;
    }

    public static String getDataSourceStats(DataSource ds) throws SQLException {
        String res = "";
        BasicDataSource bds = (BasicDataSource) ds;
        res += "NumActive: " + bds.getNumActive() + "\n";
        res += "NumIdle: " + bds.getNumIdle();
        return res;
    }

    public static void shutdownDataSource(DataSource ds) throws SQLException {
        BasicDataSource bds = (BasicDataSource) ds;
        bds.close();
    }

    public static Connection getConnection() throws SQLException {
        return theDataSource.getConnection();
    }

    public static void executeQuery(QueryMediator aMediator, String sql) throws SQLException {
        aMediator.setStmt(aMediator.getConn().createStatement());
        aMediator.setRset(aMediator.getStmt().executeQuery(sql));
    }
}

GRAVE: QueryManager: SQLException
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'oracle.jdbc.driver.OracleDriver'
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at it.unibz.inf.wobda.db.DBPool.getConnection(DBPool.java:43)
	at it.unibz.inf.wobda.queryprocessing.obda.OBDAInterface.query(OBDAInterface.java:106)
	at it.unibz.inf.wobda.queryprocessing.obda.OBDAInterface.performQuery(OBDAInterface.java:98)
	at it.unibz.inf.wobda.servlets.queryanswering.QueryManager.processRequest(QueryManager.java:90)
	at it.unibz.inf.wobda.servlets.queryanswering.QueryManager.doPost(QueryManager.java:189)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:279)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
	... 20 more

[zimo78]

Credo che l'errore sia l'utilizzo di 'oracle.jdbc.driver.OracleDriver'. Infatti lo stack dice 'not suitable' e cioè che quel driver è deprecato. Dalla versione 9 di Oracle infatti il driver corretto è 'oracle.jdbc.OracleDriver'.

Spero di esserti stato di aiuto.

Zimo78