Re: How not to use JDBC (JDBC Performance Scale 15x presentation)

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:

<connection-url>jdbc:postgresql://
mydb.host.example.com:5432/mydb?ssl=true&amp;sslfactory=org.postgresql.ssl.NonValidatingFactory&amp;assumeMinServerVersion=9.6
</connection-url>

See possible properties on
https://jdbc.postgresql.org/documentation/94/connect.html

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(at)fastcrypt(dot)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
>
>
>
> Dave Cramer
>
> davec(at)postgresintl(dot)com
> www.postgresintl.com
>
> On 15 March 2017 at 18:29, Stefan Lindner <stefan(dot)lindner(at)visionet(dot)de>
> wrote:
>
>> Dear Dave,
>>
>>
>>
>> how can we control FetchSize in a XML-Style DatasourceDefinition e.g. for
>> Wildfly?
>>
>>
>>
>> Stefan
>>
>>
>>
>> *Von:* pgsql-jdbc-owner(at)postgresql(dot)org [mailto:pgsql-jdbc-owner(at)postg
>> resql.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
>>
>>
>>
>>
>> Dave Cramer
>>
>> davec(at)postgresintl(dot)com
>>
>> www.postgresintl.com
>>
>>
>>
>> On 15 March 2017 at 17:29, Jorge Solórzano <jorsol(at)gmail(dot)com> wrote:
>>
>> https://github.com/davecramer/presentations
>>
>>
>> Jorge Solórzano
>>
>>
>>
>>
>>
>> On Wed, Mar 15, 2017 at 3:25 PM, Vladimir Sitnikov <
>> sitnikov(dot)vladimir(at)gmail(dot)com> wrote:
>>
>> Is the presentation available online somewhere?
>>
>>
>>
>> Vladimir
>>
>>
>>
>>
>>
>
>