I have started to implement stored procedure calls. They are not complete in JDBC plugin. At the moment it is an undocumented (incomplete) feature that can register field names to callable statement result parameters. You hit the nail - how to map result set output to field names is not done yet.
Because I don't know MS SQL, it will not be easy to assist, I hope this is JDBC compliant. The stored procedures I can test are MySQL stored procedures like described here: http://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#calling_javadb_mysql Jörg On Mon, Aug 4, 2014 at 11:50 PM, Christopher Ambler <[email protected]> wrote: > I would like to use the JDBC river to consume a queue implemented in an > MSSQL server. > > I have been given a stored procedure to call that hands me the top 100 > items in the queue. I'm given a number of columns as output, and the names > of the columns do not correspond to the names of the fields in > Elasticsearch. > > Can anyone give me some adult supervision on how I can (or even IF I CAN) > use the JDBC river to call this SP and properly transform the column names, > as they're coming out of the SP's result set, into the proper field names > in my index? > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/45ff2a25-6e36-4edd-a849-b5bba0f60449%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/45ff2a25-6e36-4edd-a849-b5bba0f60449%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGn63REWuQRzdbbXyONL3%3D-GFFQdq0Az_gmk5wxbJgK1A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
