IBM Support

Creating a READONLY JDBC connection

Question & Answer


Question

How do I create a READONLY JDBC connection?

Answer

You can set a JDBC connection to read-only by adding the following in the connection string: 

connection = DriverManager.getConnection("jdbc:netezza://nps_host/proddb1?loglevel=2;logDirPath=F:\\test_logs;readonly=true","admin","password"); 

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ168951

Document Information

Modified date:
17 October 2019

UID

swg21569418