Re: PreparedStatement with Hexadecimal Literals

[Alexander Soklakov]

Hi,

You are right, there is a limitation here because we can't distinguish literals and non-literal strings and JDBC spec has no special method for setting literals.

You can build the sql query with a StringBuilder or deconstruct literal and call something like:

ps.setBytes(1, new byte[] { 0x4D, 0x79, 0x53, 0x51, 0x4C });

Thanks,
Alex



Edited 1 time(s). Last edit at 07/18/2013 03:39AM by Alexander Soklakov.