What exactly do you expect? The ResultSet 'rs' should contain the query result but you never process that result. Everything looks okay so far... or do you get an exception? Where does the mentioned output come from?
Such error is raised by the server whenever it cannot perform a conversion between client and server encoding. But I don't have an idea what is causing the error in your specific case. There are simply too much variables... Maybe you could try to add some debugging to your procedure to find the exact step that fails. And maybe write a Java 10-liner for calling the procedure and process the result that you can easily debug on the client side.
You can clearly see from the attached stacktrace that the driver receives a TDS error token, so the error is definitly raised by the server. I can only guess, but maybe the stored procedure successfully inserts the data and then raises the error?
The error is raised by the server. You should make sure that the "charset" connection property matches the character set the server was installed with. If you try inserting characters not supported by that charset, this should be handled by your client code. And maybe have a look at the "sendStringParametersAsUnicode" connection property...
Your output looks like you simply called toString() on the result. Could you please share the source code?
Hi Tim, ticket 129 has been closed years ago. Do you mean ticket 729? Cheers, momo
Colon is used to specify the port... 192.168.1.1:4545
Using Comma in jtds Connection URL