search

timyates / mod-jdbc-persistor

BusMod Persistor for JDBC support in vert.x
Other
36 stars 14 forks source link

stored procedure #6

Closed hongseokyoon closed 10 years ago

hongseokyoon commented 11 years ago

why doesn't it support invoking stored procedure...? or I've just missed it?

timyates commented 11 years ago

what have you tried?

hongseokyoon commented 11 years ago

I've tried simple select query and it works okay. and I've made also simple procedure returns(select) one column of one row.

on the manual, it doesn't say about stored procedure. 'execute' may not for this, 'cuz it doesn't return result row. and may be 'select' work for this(i didn't try it yet), but how to deal with out parameter?

thanks for reading.

hongseok.com

      1. 오전 1:33 Tim Yates notifications@github.com 작성:

what have you tried?

— Reply to this email directly or view it on GitHub.

timyates commented 11 years ago

Sorry for the late response, yeah currently there is no support for in/out parameters. You should be able to call stored procedures that return tabular data as a regular select action with a CALL ... stmt

timyates commented 10 years ago

Unless anyone has a suggestion for a message format to allow this, I'm going to close this.

I guess rolling your own db access mod might be the better option if this is a hard requirement