Postgres Pro
Downloads
Home   >   mailing lists

Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation) - Mailing list pgsql-jdbc

From Christian Bjørnbak
Subject Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)
Date
Msg-id CAAQEOty+2eZ06eZQAJhCJ8w_x1rh+uHJr9V5ht7SYn8vNJyigQ@mail.gmail.com
Whole thread Raw
In response to Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view
I believe that connection-property is not the right place to add a fetchSize.

Instead you would add properties to the connection-url in a querystring style maner like:



It has a defaultRowFetchSize. I don't know if that is what you are looking for?


Med venlig hilsen / Kind regards,

Christian Bjørnbak

Chefudvikler / Lead Developer
TouristOnline A/S
Islands Brygge 43
2300 København S
Denmark
TLF: +45 32888230
Dir. TLF: +45 32888235

2017-03-16 1:11 GMT+01:00 Dave Cramer <pg@fastcrypt.com>:
Stefan,

Reading the docs, there is something called connection-property that I would expect to be passed to the driver.

  • <connection-property> - used to configure the connections retrieved from the java.sql.Driver, e.g.

   <connection-property name="char.encoding">UTF-8</connection-property>


Let me know if that works and I'll update the docs
Dave



On 15 March 2017 at 18:29, Stefan Lindner <stefan.lindner@visionet.de> wrote:

Dear Dave,

 

how can we control FetchSize in a XML-Style DatasourceDefinition e.g. for Wildfly?

 

Stefan

 

Von: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Im Auftrag von Dave Cramer
Gesendet: Mittwoch, 15. März 2017 22:35
An: Jorge Solórzano
Cc: Vladimir Sitnikov; List
Betreff: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)

 

please provide feedback, I'm giving the same talk at pgconf in nyc

 


 

On 15 March 2017 at 17:29, Jorge Solórzano <jorsol@gmail.com> wrote:


Jorge Solórzano

 

 

On Wed, Mar 15, 2017 at 3:25 PM, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:

Is the presentation available online somewhere?

 

Vladimir

 

 



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)
Next
From: Dirk Olmes
Date:
Subject: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15xpresentation)