Reason for "Invalid JDBC escape syntax at line position 24 '=' character expected" error when executing SQL Server call through JTDS driver?

I am trying to execute the following piece of SQL on SQL Server 2012, using a Java program, connecting to the database with the JTDS driver:

Declare @username varbinary(128); SET @username=convert(varbinary(128), ?); SET CONTEXT_INFO @username; 

I always get the following error:

Invalid JDBC escape syntax at line position 24 '=' character expected.

Any ideas?

1 Answer

I believe you are missing quotations marks around ?

SET @username=convert(varbinary(128), '?');