webMethods Dynamic Business Orchestrator 10.1 | Configuring Dynamic Business Orchestrator | Configuring JDBC Connection Pool Aliases in Integration Server
 
Configuring JDBC Connection Pool Aliases in Integration Server
Use the following URL to configure a JDBC connection pool alias for MySQL Community Edition 5.7 on the Settings > JDBC Pools screen in Integration Server Administrator:
jdbc:mysql://&lt;server&gt;:&lt;3306|port>/<databaseName>?
relaxAutoCommit=true&useSSL=false&useLegacyDatetimeCode=false&serverTimezone
=integration_server_timezone
You must specify connection options for the relaxAutoCommit, useLegacyDatetimeCode, and serverTimezone parameters. For example, you can provide the connection options as follows:
jdbc:mysql://<server>:<3306|port>/databaseName?
relaxAutoCommit=true&useLegacyDatetimeCode=false&serverTimezone=PST
For more information about how to create a connection pool alias in Integration Server, see webMethods Integration Server Administrator’s Guide.
Copyright © 2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.