Postgres Pro
Downloads
Home   >   mailing lists

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

From Stefan Lindner
Subject Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15xpresentation)
Date
Msg-id 039C594113548C408DC0863499EAEB420A7FD122@BOSS2.visionetlocal.local
Whole thread Raw
Responses Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)  (Dave Cramer <pg@fastcrypt.com>)
Re: How not to use JDBC (JDBC Performance Scale 15x presentation)  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view

Dave,

 

I’ve tested both alternatives: setting within JDBC url and with <connection-properties> and both seem to work

 

But the documentation Christian Bjørnbak pointed to (https://jdbc.postgresql.org/documentation/94/connect.html) states

 

„The default is zero, meaning that in ResultSet will be fetch all rows at once“

 

So doing nothing should lead to maximum performance.

 

Stefan

 

Von: davecramer@gmail.com [mailto:davecramer@gmail.com] Im Auftrag von Dave Cramer
Gesendet: Donnerstag, 16. März 2017 01:11
An: Stefan Lindner
Cc: List
Betreff: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)

 

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: Dirk Olmes
Date:
Subject: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15xpresentation)
Next
From: Dave Cramer
Date:
Subject: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)