Calling MSSQL stored procedure from Trireme-JDBC

[#1]

We are working on a Node.js base API proxy which uses "trireme-jdbc" to connect to a MSSQL database. While it is pretty straightforward with executing simple SQL statements, we are not sure how to call a stored procedure in MSSQL using "trireme-jdbc".

Is it possible with trimem-jdbc or any workarounds?

[DChiesa]

Yes, I have done this using npm modules intended for MS SQL Server.

• mssql
• seriate

There is a sample bundle here that demonstrates this working.

Check the seriate docs for how to invoke stored procedures - it's basically the same as for doing queries.