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 used by resource jdbc/WebSphere Commerce Oracle DataSource demo : DSRA0023E: The DataSource implementation class "oracle.jdbc.pool.OracleConnectionPoolDataSource" could not be found.
    at java.lang.ClassLoader.loadClass(
    at java.lang.ClassLoader.loadClass(

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.
            DatasourceName="WebSphere Commerce Oracle DataSource demo"
            HelpServerHostName="localhost" HelpServerPort="8001"
            JDBCDriverType="native" WASProfileName=""
            appUpdateTimeout="1800000" applicationName="WC" port="900"> 


  1. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted oracle training in bangalore.

  2. I think this is the best article today. Thanks for taking your own time to discuss this topic, I feel happy about that curiosity has increased to learn more about this topic. Keep sharing your information regularly for my future reference.
    Java Courses in chennai

  3. Open up the majority of the channels on the gear and let the water out swimming pools

  4. So why not set up a pool party with your companions since each one will hang out by the pool at any rate? Simply make sure to bring bunches of sun square.professional swimming competition

  5. Although why not consider the higher quality , pool area dust of which by some means is able to to help area into your crevices or maybe slots of this pool area handle? Imagine everyone When i seemed to be inside my senses conclude trying to find out the reason your pool area handle received "built-in" slots. Couldn't people go along with everyone of which these slots eliminate the aim of spanning in the pool area?