Configuring nsqjdbcmk.properties – meshIQ

The information below will help you configure the nsqjdbcmk.properties file needed to create management (apwmq) and permit database tables in Postgre, DB2, Oracle, MSSQL and MySQL. The Database URL entries discussed can easily be used as a reference to configure the WorkGroup Expert.

nsqjdbcmk.properties file
nsqjdbcmk.apwmq.data_source and nsqjdbcmk.permits.data_source	MySQL: jdbc:mysql://<host-name or IP>:3306/<schema-name> jdbc:mysql://192.168.1.69:3306/nastel_apwmq
	MSSQL: jdbc:sqlserver://<host-name or IP>:1433;databaseName=<db-name> jdbc:sqlserver://192.168.1.69:1433;databaseName=nastel_apwmq
	Oracle: jdbc:oracle:thin:@<host-name or IP>:1521:<SID> jdbc:oracle:thin:@192.168.1.69:1521:sid_nastel jdbc:oracle:thin://<host-name or IP>:1521/<servicename> jdbc:oracle:thin://192.168.1.69:1521/srvname_nastel
	DB2: jdbc:db2://<host-name or IP>:50000/<db-name> jdbc:db2:///192.168.1.69:50000/M6WMQ
	POSTGRE: jdbc:postgresql://<host-name or IP>:5432/<db-name>?searchpath=<db-name> jdbc:postgresql://192.168.1.69:5432/nastel_apwmq?searchpath=nastel_apwmq

nsqjdbcmk.apwmq.driver_class and nsqjdbcmk.permits.driver_class	MySQL: com.mysql.jdbc.Driver
	MSSQL: com.microsoft.sqlserver.jdbc.SQLServerDriver
	Oracle: oracle.jdbc.driver.OracleDriver
	DB2: com.ibm.db2.jcc.DB2Driver
	POSTGRE: org.postgresql.Driver

NOTE: JDBC jars bundled with the AutoPilot package are located in: <AP_HOME>/nastel/AutoPilotM6/lib
You can also download the JDBC driver from the appropriate database provider.

On the Create Workgroup Server Expert – General dialog box, edit the Database URL properties using the required format displayed above.