is it possible to change the JDBC Type in an selectSQL JDBC Adapter ?
When I select all the column of a particular table in a select adapter service, I get one of the column Type as “NUMBER(11,2)” and JDBC Type as “DECIMAL”. Now the problem is I need to map this field value to another filed of a publishable document. however this field of a publishable doc expects “DOUBLE” as input type and the document is not published if I pass String,decimal,object in it.
Also, if JDBC type is “DECIMAL”, then we have only three options in Output field type :- java.lang.string,java.lang.object,java.math.bigdecimal