Jdbc adapter output type

, ,
1

Hi
i am facing a problem with the jdbc Custom sql adapter service. The database has fields with varchar2(24bytes) as the datatype.I am not able to retrieve that data with such fields to the webMethods environment. Can any one help me as to how to retrieve such data to the webMethods?

Thanks in advance

2

can you state your SQL statement ?

3

Pavan,

You should be able to get this data as a string in webMethods. Make sure your Output JDBC type is set to VARCHAR and Output Field Type is set to java.lang.String in your adapter service.