Memsql Stored Procedure from Scala

Help
1

Hi Team,

We are trying to call StoredProcedure from Scala in memsql using mariadb java connector. however we are getting the below exception.

Caused by: java.sql.SQLException: Feature ‘Audit logging with binary protocol’ is not supported by MemSQL.

we tried to pass the property useServerPrepStmts=false in connection string, still the same issue.

jdbc:mariadb://localhost:3307/testdb?useServerPrepStmts=false
val callableStatement = connection.prepareCall("{call test_sp()}")
callableStatement.execute().

kindly suggest me on the issue.

THanks.

2

Hi,

If audit logging is enabled, we don’t currently support using the MySQL binary protocol. The MySQL binary protocol is used whenever server side prepared statements are used (that is what prepareCall is doing under the hood).

I’m not that familiar with JDBC, but is it possible to run the stored proc via executeQuery(“call test_sp()”) instead?

-Adam