Thread: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15xpresentation)
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
Dave Cramer
davec@postgresintl.com
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
Dave Cramer
davec@postgresintl.com
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
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
Dave Cramer
davec@postgresintl.com
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
Dave Cramer
davec@postgresintl.com
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
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
Dave Cramer
davec@postgresintl.com
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
Dave Cramer
davec@postgresintl.com
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