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

                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
                  Permalink On twitter.com Twitter logo sheetsj’s avatar ♻️ 1 Retweets ❤️ 8 Favorites Mood +2 🙂
              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
                Permalink On twitter.com Twitter logo sheetsj’s avatar Mood +2 🙂
            1. …in reply to @sheetsj
              I prefer @groovylang for simple StoredProc support, but sometimes you have to use Java
              Permalink On twitter.com Twitter logo sheetsj’s avatar Mood +2 🙂
          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
            Permalink On twitter.com Twitter logo sheetsj’s avatar Mood 0
        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
          Permalink On twitter.com Twitter logo sheetsj’s avatar ❤️ 1 Favorite Mood +2 🙂
      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
        Permalink On twitter.com Twitter logo sheetsj’s avatar ❤️ 2 Favorites Mood -1 🙁
    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-
      Permalink On twitter.com Twitter logo sheetsj’s avatar ♻️ 2 Retweets ❤️ 2 Favorites Mood +5 🙂
  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
    On twitter.com Twitter logo sheetsj’s avatar ♻️ 1 Retweets ❤️ 1 Favorite Mood +2 🙂
    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!
      Permalink On twitter.com Twitter logo sheetsj’s avatar ❤️ 4 Favorites Mood +5 🙂