That was why I asked about a connection pool. With a connection pool, it won't get dropped as long as it is active. but inactive connections go back into the pool. You can use a connection pool without having the overhead of having to create a connection everytime you need to make a call and without having to manage the connections yourself.
Owen Rubel 415-971-0976 [email protected] On Thu, Apr 30, 2015 at 10:56 AM, Henson Sturgill <[email protected]> wrote: > Thanks Owen, and Dinko. > > I was just asking how connections were made. My goal was to keep a single > connection open and test it, a growing number of minutes between tries, to > see when/if the connection was being dropped. But since the connection is > made on each execution, my code will most likely never fail. > > Thanks so much, > Henson > > On Thu, Apr 30, 2015 at 1:04 AM Owen Rubel <[email protected]> wrote: > >> Just in case you are asking about connection pools, you can use grails >> datasource for defining the pool. >> >> here's a good thread on that... >> >> >> http://stackoverflow.com/questions/12291930/connection-pooling-and-prepared-statements-with-groovy-sql-sql-or-jdbc-in-grails >> >> >> On Wed, Apr 29, 2015 at 8:22 PM, Dinko Srkoč <[email protected]> >> wrote: >> >>> >>> On 29 Apr 2015 23:10, "Henson Sturgill" <[email protected]> wrote: >>> > >>> > Been playing around with a hosted Oracle database that *seems* to be >>> dropping connections. I made the following script to test (call to >>> Sql.newInstance() not shown) but I'm curious -- does Groovy create the >>> connection to the database on newInstance(), or every time eachRow() is >>> called? >>> > >>> >>> Every time eachRow is called, and the connection is closed upon >>> consuming the dataset. >>> >>> Cheers, >>> Dinko >>> >>> > --- Example Code --- >>> > >>> > String query = "select count(*) cnt from spriden where >>> upper(spriden_last_name) = 'STURGILL'" >>> > int minuteDelay = 0 >>> > >>> > while (minuteDelay <= 120) { >>> > Thread.sleep(1000 * 60 * minuteDelay); // Sleep increasing number >>> of minutes >>> > Date date = new Date(); >>> > sql.eachRow(query) { >>> > println "After ${minuteDelay} minutes - ${it.cnt} (${date})" >>> > } >>> > minuteDelay += 5; >>> > } >>> > >>> > --- End Example --- >>> > >>> > Thanks so much you wonderful programmers! >>> >>
