![]() See this article for additional information.Ī comma-separated list of code or code-pro ( Code Pro Macro) parameters used when Show SQL is selected. Once the maximum active limit is reached, the next requested render of a SQL macro using the specific data source returns an error message instead of trying to connect to the database. Limit the number of actively executing SQL queries for a specific data source. Administrators can limit (or control) who can use this parameter through the use of our Macro Security for Confluence app.Requires that the target database and JDBC driver support the remote query timeout server configuration option (queryTimeout).By connection string - use this option if you want to specify additional parameters and you are comfortable with constructing a database URL.ĭepending on the setup type, you are prompted to enter the following information:ĭbUrl=jdbc: postgresql://localhost:5432/test | dbUser=confluence | dbPassword=confluence | dbDriver= | dbJar= postgresql-42.2.5.jarĭbUrl=jdbc: postgresql://localhost:5432/test ?currentSchema=jiraschema | dbUser=confluence | dbPassword=confluence | dbDriver= | dbJar= ĭbUrl=jdbc: mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true | dbUser=confluence | dbPassword=confluence | dbDriver= | dbJar= ĭbDriver=.SQLServerDriver | dbUrl=jdbc: sqlserver://localhost:2433 database=test integratedSecurity=false | dbUser=confluence | dbPassword=confluence | dbJar=./lib/mssql-jdbc-7.0.0.jre8.jar. ![]() Simple - this is the most straightforward way to connect to your database.The Add profile screen provides you with two setup type options: Click View and modify data source profiles (see: ) tab at the top.Scroll down to BOB SWIFT CONFIGURATION in the navigation pane to the left and click SQL (Pro Edition) (see: ).Select Manage apps from the CONFLUENCE ADMINISTRATION menu (cog icon: ) at the top right of your screen.Log in as a Confluence administrator with Global Permission.To add a new or extend an existing data source or global data source (defined in server.xml) profile: If you must downgrade the app version, passwords of all the profiles must be re-entered to ensure proper working of profiles. This encryption-decryption of profile passwords is not available if the app is downgraded from version 10.3 to a lower release version. All profile sensitive information (such as passwords) are now encrypted to provide enhanced security.
0 Comments
Leave a Reply. |