jTDS
jTDS copied to clipboard
Invalid JDBC escape syntax with jtds driver
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.