Re: not fetching all query results

Radim,

As per our docs
http://jdbc.postgresql.org/documentation/91/query.html#fetchsize-example

You need to do the select inside a transaction

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Tue, Jul 17, 2012 at 3:49 PM, Radim Kolar <hsn@filez.com> wrote:
> with 5m result set you can set fetchsize to any value it has no effect
>
> @GrabConfig(systemClassLoader = true)
> @Grab(group='postgresql', module='postgresql', version='8.3-603.jdbc4')
> @Grab(group='commons-lang', module='commons-lang', version='2.6')
>
> import groovy.sql.Sql
> import org.apache.commons.lang.math.RandomUtils
>
> def sql=Sql.newInstance("jdbc:postgresql://localhost/grails", "postgres",
> "postgres")
> sql.setCacheStatements(true)
>
> /*
> sql.withTransaction {
> for (i in 1..5000000 ) {
>   sql.executeUpdate("insert into public.test (a) values (?)",
> [RandomUtils.nextLong()])
> }
> }
> */
>
> def c = sql.getConnection()
> def s = c.createStatement()
> s.setFetchSize(100000)
> def r = s.executeQuery("select * from public.test")
> def cnt = 0
> while (r.next()) {
>  cnt++
> }
>
> println "${cnt} rows."
>
> sql.close()
>
>