sheetsj’s avatarsheetsj’s Twitter Archive—№ 3,097

        1. Happy #Hacktoberfest! hacked a long-asked-for feature into @SpringData JPA - stored procs with multiple out params github.com/spring-projects/spring-data-jpa/pull/297
      1. …in reply to @sheetsj
        I'm never a fan of working with stored procedures, but sometimes at clients in legacy codebases you have no choice
    1. …in reply to @sheetsj
      I prefer @groovylang for simple StoredProc support, but sometimes you have to use Java
  1. …in reply to @sheetsj
    So for those times you have to use @java at least now StoredProcs are a little easier with github.com/spring-projects/spring-data-jpa/pull/297
    1. …in reply to @sheetsj
      Next up - adding support for single and multiple ResultSets - so Spring Data JPA can be on feature parity with Groovy jira.spring.io/browse/DATAJPA-1092
      1. …in reply to @sheetsj
        Disclaimer: This is not an endorsement to write stored procedures... They are awful. Replace them if you can! SOA-via-StoredProcedures is not a design pattern your organization wants to live with
        1. …in reply to @sheetsj
          For comparison, here is the super clean Groovy approach to handle the complicated stored proc with multiple out params and multiple result sets docs.groovy-lang.org/latest/html/api/groovy/sql/Sql.html#callWithAllRows-groovy.lang.GString-groovy.lang.Closure-
          1. …in reply to @sheetsj
            And the full clean Groovy SQL approach to using an injected Datasource setup by Spring, including Spock test gist.github.com/jeffsheets/c52f7f67d0408cc1be27a39d5b459951
            1. …in reply to @sheetsj
              🎉 w00t! my PR made it in to the last RC1 release spring.io/blog/2019/06/17/spring-data-moore-rc1-and-lovelace-sr9-released Stored Procs with multiple out params are now supported by @SpringData JPA!