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. Open up the majority of the channels on the gear and let the water out swimming pools

    ReplyDelete
  3. 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
  4. Within this webpage, you'll see the page, you need to understand this data. Stahlwandbecken

    ReplyDelete
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. At last, total mortar completes consolidate reasonableness and excellence. Swimmingpool

    ReplyDelete
  11. Es un blog muy interesante, me ha gustado mucho leerlo, ya que puede ser algo de gran utilidad para poner en práctica.

    ReplyDelete
  12. Each state of pool joined with each corner sweep has a particular border estimation related with it. Still to be certain you should peruse the entirety of the supporting documentation that the provider make accessible to you to see how to quantify the pool as per their necessities.Holzpool

    ReplyDelete
  13. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also Pool ohneBeton

    ReplyDelete
  14. You have done a great job on this article. It’s very readable and highly intelligent. You have even managed to make it understandable and easy to read. You have some real writing talent. Thank you. swimming pool contractors orange county

    ReplyDelete
  15. Today, considering the fast chosen lifestyle that everyone is having, credit cards have a huge demand in the economy. Persons throughout every discipline Pool

    ReplyDelete
  16. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. Swimmingpool

    ReplyDelete