Struct Database Specific Data Types

, ,
1

Hi all,

I’m trying to integrate with a SP which has a TYPE as an output parameter. The JDBC Type in the adapter service is a STRUCT (java.sql.Struct). When I run the service, the following error is thrown:

Could not run ‘flowServiceTYPE’
com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service bbmCadena100.exemploTYPE:SR_PREENCHE_TYPE_TEST_2.
[ADA.1.316] Cannot execute the SQL statement "call TRON2000.SR_PREENCHE_TYPE_TEST_2 (?, ?) ". "
b ORA-03115: unsupported network datatype or representation[/b]

I tried to change the type to java.lang.Object, but with no success.

I was wondering if my jdbc driver is older and cannot allow a TYPE as a output parameter.

Do you have any idea?

Thank’s!

STRUCT.png
STRUCT.png758×134 3.16 KB

2

Hi Filipe,

please provide some more details:

wM Version
JDBC Adapter Version
Fixes for the above

Database and driver version

Regards,
Holger

3

Hi Holger,

WM Version: 9.8
Updates: IS_9.8_Core_Fix4
Build Number: 247
JDBC Adapter Version: 9.0.0.0
Build: 341

4

Hi Fillipe,

please apply latest Fix for JDBC-Adapter 9.0 (currently Fix9) to your installation.

See if this helps.

Regards,
Holger

1 Like
5

I have to notify the client about this.

Thank’s!

6

Holger,

I can get the fix only from Empower?

7

Hi Filipe,

Fixes need to be obtained by Software AG UpdateManager by using your Empower credentials.

Regards,
Holger

1 Like