Hi Markjason,
As per the JDBC Adapter Guide, it doesn’t support user defined types. Also I couldn’t find this uniqueidentifier in the JDBC to JAVA data type mapping as supported.
**Adapter for JDBC does not support user-defined data types,**
For driver - SQL Server 2005 / Driver for JDBC Version 1.0.809.102, there is a limitation specified as - This driver returns invalid JDBC data type for MS SQL UNIQUEIDENTIFIER data type.
Please try to use Stored Procedure along and not with signature, and try to invoke without mapping the input parameter causing issue.
else use Custom SQL and invoke the SP with required parameters, as you said on database it worked fine.
Regards,
Firoz N