Hi again, Some database drivers might allow you to specify the default fetch size in connection URL or data source definition. For example, Oracle docs say they have a "defaultRowPrefetch" property for this. Of course, this is not specific to OpenJPA / JPA.
Greetings, Milosz > Hello, > > It seems that setting openjpa.FetchBatchSize implicitly enables large result > set support which is not suitable for your case. > > However, chances are you can execute Statement.setFetchSize(int) by extending > the DBDictionary you are using, although it needs some typing. As a guidance, > see PostgresDictionary.decorate method. It creates a wrapped Connection, > which in turn provides wrapped PreparedStatements where you can override > methods like executeQuery and inject a call to setFetchSize. Or do it in > prepareStatement method of your wrapped Connection. > > Let us know how it goes. > > Cheers, > Milosz > > > How do I set fetch size in JPA? I would like the cursor to read 2000 rows at > > once to speed up entity generation. Thanks for help! > > > > -- > > View this message in context: > > http://openjpa.208410.n2.nabble.com/Using-FetchPlan-setFetchBatchSize-feature-leads-to-java-io-NotSerializableException-tp6771824p6782493.html > > Sent from the OpenJPA Users mailing list archive at Nabble.com. > > >
