Announcement Announcement Module
Collapse
No announcement yet.
Oracle Lob Handler + Websphere 6.1 Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle Lob Handler + Websphere 6.1

    Hi,

    Requirement is to insert blob/clob into database.
    I am using OracleLobHandler with WebSphereNativeJdbcExtractor.

    However, it is recommended not to use WebSphereNativeJdbcExtractor.
    http://www.ibm.com/developerworks/we...ringHirbernate

    Using WSCallHelper websphere class will make my application dependent on Websphere.

    I have defined both types of datasources in my application.

    <jee:jndi-lookup id="J2eedataSource" jndi-name="jdbc/${database.jndi.name}" resource-ref="true"/>

    <bean id="StdDataSource"
    class="org.springframework.jdbc.datasource.DriverM anagerDataSource">
    <property name="url"><value>jdbc:oracle:thin:@${database.hos t}:${database.port}:${database.dbname}</value></property>
    <property name="username" ><value>${database.user}</value></property>
    <property name="password" ><value>${database.password}</value></property>
    <property name="driverClassName"><value>${database.driver}</value></property>
    </bean>

    to execute all sQL queries, I am passing J2eedataSource datasource to JdbcTemplate.

    How to configure extractor/Oracle lob handler to pick native connections from StdDataSource?

    If SqlLobValue objects created using connections from StdDataSource, then can it be executed using J2eedataSource?

    Thank you.
Working...
X