Announcement Announcement Module
No announcement yet.
How to get OracleLobHandler working for weblogic as well as websphere Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to get OracleLobHandler working for weblogic as well as websphere


    We have an application which used oracle 11g and spring 3.0.7
    This application should be portable on weblogic as well as websphere, without any modification done to spring beans or other configurations or to code.

    This application has a need to read as well as write CLOB and BLOB in DB.

    When deployed on Websphere it works fine with WebSphereNativeJdbcExtractor but fails on weblogic.
    When deployed on weblogic with CommonsDbcpNativeJdbcExtractor, it works fine but fails on websphere with exception as
    Could not create Oracle LOB; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Couldn't initialize OracleLobHandler because Oracle driver classes are not available. 
    Note that OracleLobHandler requires Oracle JDBC driver 9i or higher!; nested exception is java.lang.ClassNotFoundException: oracle.sql.BLOB
    My question is, which NativeJdbcExtractor to use in this case, or is there any other way to achieve the same.
    If there is no way out to above problem then, Is there a way where spring can identify the App-server, so that I can write my own NativeJdbcExtractor which contains weblogic and websphere specific native extractors.

    Thanks and Regards,

  • #2
    This problem is resolved.
    Use OracleJdbc4NativeJdbcExtractor.