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
(v6.3.15#6346)
