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...
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), '?');
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
