Inserting NCLOB into DB using JDBC adapter

We are actually trying to insert NCLOB into Oracle 10 g DB using the Stored Procedure Template of webmethods but we received the “Invalid Column Type” error We are using JDBC Adapter 6.0.3 - Feature Pack 1 - Fixes 7, 9 & 10. We are using the Oracle Thin Driver with Datasource Class = oracle.jdbc.pool.OracleDataSource.

If any one can provide some solution that will be good.

I also have the same problem when trying to insert large size of data using the WebMethods built in JDBC Adapter but succeeded when using a custom java service (using Oracle Driver). So for this case i would like to suggest you to write your own java service that insert to your Database.

Hi,

Thanks For Replying. Can you provide me with the Java Service you had written for reference. This will be a great help.

Thanks,
Himanshu

Hi,

Did you try oracle 10g drivers.
copy n paste :

  1. ojdbc14.jar
  2. ojdbc14_g.jar

into “/IntegrationServer/packages/WmJDBCAdapter/code/jars/static/”

Hope it helps.

Regards,
Sumit