hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Andre Pearce (IG) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1463) JDBC-PXF - support additional properties
Date Thu, 11 May 2017 22:27:04 GMT
Michael Andre Pearce (IG) created HAWQ-1463:

             Summary: JDBC-PXF - support additional properties
                 Key: HAWQ-1463
                 URL: https://issues.apache.org/jira/browse/HAWQ-1463
             Project: Apache HAWQ
          Issue Type: Sub-task
          Components: PXF
            Reporter: Michael Andre Pearce (IG)
            Assignee: Vineet Goel

2) Extra Properties
Some JDBC drivers will need many additional properties beyond the URL and this requires setting
it with a put to a Properties variable. An example of this is Oracle's defaultRowPrefetch
property that needs to be updated from the default of 10 which is designed for OLTP to something
larger like 2000 which is more ideal for data extracts.
Additionally, you will need the ability to set the isolation level which is done with setTransactionIsolation
on the Connection. I don't believe you can set this on the connection URL either. Many SQL
Server and DB2 database still don't use snapshot isolation and use dirty reads instead to
prevent blocking locks. The configuration file I suggested above will need an "extra properties"
variable that is a delimited list of key/value pairs so you can add multiple extra properties.

This message was sent by Atlassian JIRA

View raw message