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

  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!