Forum Discussion

johan_l's avatar
johan_l
New Contributor
11 years ago

Hexadecimal property in a JDBC request seems to be treated as a string

Hello! I got a property on a jdbc request that is a hexadecimal. The problem is when I run the query it seems as the property is treated as a string or something and not a hexadecimal. 

 

Name Value

fooId 0xF66D61BF578C4073A19CADFBEAAC7D16

 

select * from
foo where foo_id =:fooId

 

This returns nothing but if I run it directly without the variable like this I find my foo

 

select * from
foo where foo_id =0xF66D61BF578C4073A19CADFBEAAC7D16

 

Is it possible to make the property to a hexadecimal or something like that? Ive tryed to fix this the SQL way aswell but havent found a solution, its a MS SQL database.

 

Btw I am using SoapUI Pro 5.1.2

 

Thanks for your help!

No RepliesBe the first to reply