Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pooling composite showing error for SQL Driver Exception

M.Jawad-OracleApr 21 2021

Hi,
I have moved a running composite from Oracle SOA 12.1.3 to 12.2.1.4 with Database 19C and created a data source with SQL server 2016 by placing SQLJDBC4.jar file on domain path data source succesfully defined but when I start the composite it shows error in logs and below:

com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.

The composite is pooling on table in SQL server 2016 based on a columns value and updates the status of column after reading it.

Regards
Jawad

Added on Apr 21 2021

#adapter, #database, #soa, #soa-process-management, #soa-suite-discusssions

0 comments

157 views