Example SQL JDBC connection string for autosys SQL jobs

Products

• CA Workload Automation AE - System Agent (AutoSys)

Issue/Introduction

Is there an example JDBC connection string for SQL Server SQL jobs

Resolution

db.connectionPool.maxSize=5
db.default.password=real_password_in_encrypted
db.default.url=jdbc:sqlserver://SQLserverHostname.Company.Com\SQLServerInstanceName:1433;databaseName=DatabaseNameInClearText;
db.default.user=autosys
db.out.format.paramSeparator=|
db.out.format.valueSeparator==
db.persistance.connectionKeySeparator=#
db.trig.log.table=dbo.CYB_TRIG_LOG
db.trig.namePrefix=CYB_
db.trig.pollingInterval.ms=10000
db.trig.processMissingTriggers=false
db.trig.propfile=dbtrigSqlServer
jdbc.drivers=com.microsoft.sqlserver.jdbc.SQLServerDriver:sun.jdbc.odbc.JdbcOdbcDriver
plugins.start_internal_7=database

Additional Information

db_connection_pool.log would have entries like this:

## Instance name of SQL server was ITSM,  database with the tables was  AEDB,  DB user was autosys

10/20/2021 14:22:59.286-0400 4 DatabasePlugin.database Internal Thread.DbConnection.<init>[:101] - New connection jdbc:sqlserver://sqlserver-hostname.company.com\ITSM:1433;databaseName=AEDB;#autosys
10/20/2021 14:22:59.287-0400 5 DatabasePlugin.database Internal Thread.DbConnection.connectToDb[:165] - Connecting to sqlserver-hostname.company.com\ITSM:1433;databaseName=AEDB;#autosys#12343323543535345435345
10/20/2021 14:22:59.288-0400 5 DatabasePlugin.database Internal Thread.DbConnection.connectToDb[:169] - conTimeout>>30
10/20/2021 14:22:59.341-0400 5 DatabasePlugin.database Internal Thread.DbConnection.connectToDb[:179] - Connection established
10/20/2021 14:22:59.343-0400 4 DatabasePlugin.database Internal Thread.DbConnection.connectToDb[:183] - AutoCommit set
10/20/2021 14:22:59.410-0400 5 DatabasePlugin.Thread-24.DbConnectionPool.returnConnection[:150] - freeConnections.size()>> 0maxSize>>5