IBM PureData System for Analytics, Version 7.1

JDBC driver data source support

Up to 4.5.x, JDBC driver implementations for data sources had some limitations, such as not allowing users to set different connection properties, such as: securityLevel, caCertFile, loggerType. In 4.6, these data sources were removed and improved data sources are added, as shown in the following table:

Table 1. Data source support changes
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 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/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, note that JDBC uses the value 23:59:59:999999 to represent the 00:00:00 time value of the next day.