jTDS icon indicating copy to clipboard operation
jTDS copied to clipboard

Invalid JDBC escape syntax with jtds driver

Open tchouaffe opened this issue 1 year ago • 0 comments

I'am getting java.sql.SQLException: Invalid JDBC escape syntax at line position 22 '=' character expected. when using the jtds driver. I can establish a connection with the LocalDB instance with: jdbc:jtds:sqlserver://./myDatabase;instance=LOCALDB#xyz;namedPipe=true;User=my_user;Password=my_password

I am working with a proprietary software (Guidewire) which connects to the Server LocalDB and then starts running some SQL statements which I have no control over. I read somewhere that the jtds driver unfortunately does not support stored procedure.

tchouaffe avatar Dec 08 '23 17:12 tchouaffe