Wednesday, April 23, 2014

"oracle.jdbc.pool.OracleConnectionPoolDataSource" could not be found

Error below, can happen due to multiple reasons on server start, if it can't locate the Oracle JDBC driver. please find below some of the resolution steps that may help debug.

J2CA0036E: An exception occurred while invoking method setDataSourceProperties on com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by resource jdbc/WebSphere Commerce Oracle DataSource demo : com.ibm.ws.exception.WsException: DSRA0023E: The DataSource implementation class "oracle.jdbc.pool.OracleConnectionPoolDataSource" could not be found.
    at java.net.URLClassLoader.findClass(URLClassLoader.java:423)
    at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:191)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:660)
    at com.ibm.ws.bootstrap.ExtClassLoader.loadClass(ExtClassLoader.java:111)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:626)


Resolution:
ToolkitModuleConfig.xml -->Update XML to point to correct toolkit location.
Close toolkit
Run setDBType          (For Oracle 11g Oracle home:: Oracle\product\11.2.0\client_1)
Which updates wc-server.xml and variables.xml for oracle home.
Right click on server and click clean.

In wc-server.xml
Also make sure the JDBCDriverLocation is correctly pointing to the JDBC driver location.
<Websphere
            DatasourceName="WebSphere Commerce Oracle DataSource demo"
            HelpServerHostName="localhost" HelpServerPort="8001"
            JDBCDriverLocation="C:\IBM\Oracle\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar"
            JDBCDriverType="native" WASProfileName=""
            appUpdateTimeout="1800000" applicationName="WC" port="900"> 




No comments:

Post a Comment