Skip to Content
avatar image
Former Member

Oracle JDBC driver 10g and xMII

I have a BLS that tries inserting CLOB data into Oracle 10g database. Since Oracle 8 JDBC driver does not support that (I saw other SDN messages on the same issue), I have download and copied Oracle JDBC driver for 10g

ojdbc14.jar to

C:\ServletExec AS\se-xMII\webapps\default\Lighthammer\WEB-INF\lib

folder

I restarted Servlet exec engine and I'm still seeing the same error

that the value to be inserted is too large ( I'm inserting more than

4000 characters but much lesser than 4 GB which CLOB column can take)

1. I want to understand if there is something else that I need to

change in order for xMII to pickup the new driver.

2. Also, should I add it classpath?

3. Looking at some Oracle notes on using capability of 10g driver for

manipulating large data, the property SetBigStringTryClob=true should

be set. I saw examples of some non-xMII applications setting it in their

servers.xml. Similarly, in which file can I set this property in xMII

to force the driver to use this feature?

Is ServerDefaults.xml under C:\Lighthammer\Illuminator\SysConf the

right place? Since it is not recommended to modify the configuration

files manually rather than using admin console, I'm not sure on this

one.

Let me know

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 02, 2008 at 03:37 PM

    Could anyone pls. respond to this question

    Thanks

    Deepa

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Rick.

      I had posted a support ticket with SAP and they confirmed that the methods that are used to set CLOBS are not being invoked by xMII. So this is not supported.

      Hope the xMII v12 supports this approach.