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"> 




20 comments:

  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.

    ReplyDelete
  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

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

    ReplyDelete
  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

    ReplyDelete
  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? https://pressurewasherguides.com/best-telescopic-pool-pole/

    ReplyDelete
  6. Within this webpage, you'll see the page, you need to understand this data. Stahlwandbecken

    ReplyDelete
  7. Your content is nothing short of brilliant in many ways. I think this is engaging and eye-opening material. Thank you so much for caring about your content and your readers. Swimmingpools

    ReplyDelete
  8. I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work. Ovalpools

    ReplyDelete
  9. Sun pool domes provide another great way to use the sun's energy as a heating source for your swimming pool. Typically constructed from vinyl and aluminum, sun pool domes provide a complete enclosure for your swimming pool, preventing heat loss and also helping to keep your pool clean. Pool selber bauen

    ReplyDelete
  10. I like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed... Achtformbecken

    ReplyDelete
  11. Sun pool domes provide another great way to use the sun's energy as a heating source for your swimming pool. Typically constructed from vinyl and aluminum, sun pool domes provide a complete enclosure for your swimming pool, preventing heat loss and also helping to keep your pool clean. Edelstahlpool

    ReplyDelete
  12. I prefer my water cooler than that, and avoid one of our 'public pools' because the surroundings and water are both too warm for me.sandfilteranlage

    ReplyDelete
  13. Elements like the consistency of utilization along with just how much trash falls into your swimming pool may signify more or less appointments from your swimming pool service in a month. Schwimmbecken

    ReplyDelete
  14. At last, total mortar completes consolidate reasonableness and excellence. Swimmingpool

    ReplyDelete