Good Morning, All. Thank you very much, Jeremy.
I see the execute method of Statement class is returning a boolean indicating if resultset exists for unknown SQL statement and then can be fetched using getResultSet(). Is there a way that I can use the "stmt" that sequel gem uses, so that I can iterate over resultSet? https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#execute(java.lang.String) Problem with our business/design flow is we don't know at coding time, what statement would be received by program. ________________________________ From: [email protected] <[email protected]> on behalf of Jeremy Evans <[email protected]> Sent: Thursday, June 6, 2019 12:26:14 PM To: sequel-talk Subject: Re: Issue with SEQUEL when moved from tinyTDS to JDBC On Thursday, June 6, 2019 at 8:31:40 AM UTC-7, Rama Musidipalli wrote: Thank you Jeremy. Sure, will go with your recommendation. Could you suggest method for running Stored Procedure that run few insert, updates and then return cursor. Sequel has some limited support for stored procedures on JDBC, but I don't believe it supports returning cursors. You'll need to use Database#synchronize to get access to the underlying JDBC connection object, and then use the JDBC API: DB.synchronize do |jdbc_conn| # ... end The jdbc_conn object yielded is the underlying JDBC connection, so if you have questions on how to use it, please refer to the JDBC documentation, as you are no longer using Sequel's API at that point. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at https://groups.google.com/group/sequel-talk. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/c8f8ff81-c4b0-426c-9a54-cf7ee1187c89%40googlegroups.com<https://groups.google.com/d/msgid/sequel-talk/c8f8ff81-c4b0-426c-9a54-cf7ee1187c89%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 "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/DM6PR04MB42334D0FDC6525A7C0B29453F9100%40DM6PR04MB4233.namprd04.prod.outlook.com. For more options, visit https://groups.google.com/d/optout.
