milesibastos / jTDS

jTDS JDBC Driver
http://jtds.sourceforge.net/
GNU Lesser General Public License v2.1
81 stars 46 forks source link

Invalid JDBC escape syntax with jtds driver #22

Open tchouaffe opened 11 months ago

tchouaffe commented 11 months ago

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.