JDBC driver data source support
Up to 4.5.x, JDBC driver implementations for data sources had some limitations. For example, you could not set different connection properties, such as securityLevel, caCertFile, and loggerType. In 4.6, these data sources were removed, and improved data sources were added.
The improved
data sources are shown in the following table:
JDBC interface | Former implementation | New implementation | Remarks |
---|---|---|---|
javax.sql.DataSource
|
org.netezza.jdbc2.optional.
SimpleDataSource |
org.netezza.datasource.
NzDatasource |
Basic DataSource implementation. |
javax.sql.DataSource
|
org.netezza.jdbc2.optional.
PoolingDataSource |
org.netezza.datasource.
NzConnectionPool |
Basic DataSource implementation with connection pooling implemented inside it. Use the connections that are provided by this data source directly, as normal connections. The data source internally handles the pooling. Do not use this data source if your server or middleware vendor provides a connection pooling implementation. This data source is provided as a convenience only. |
javax.sql.ConnectionPool
DataSource |
org.netezza.jdbc2.optional.
ConnectionPool |
org.netezza.datasource.
NzConnectionPoolDatasource |
Basic ConnectionPoolDataSource implementation. |
IBM® Netezza® Release 7.1 added support for IBM DB2® 24:00:00 time support as an optional configuration for the database. However, JDBC has limited support for the 24:00:00 time format. If you use the 24:00:00 time support in your Netezza database, be aware that JDBC uses the value 23:59:59:999999 to represent the 00:00:00 time value of the next day.