Jdbc adapter output type

pavanven · August 26, 2005, 1:00pm

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

leonlee · August 26, 2005, 6:54pm

can you state your SQL statement ?

Aneel_Murari · August 27, 2005, 3:09am

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.