Purpose
Excerpt |
---|
Show information about datasources available to Confluence and JDBC drivers used to connect to them. |
It will also help to figure out which values can be used in Macro database-structure.
Available sinceWarning |
---|
This macro was added in version 5.3.3 of the PlantUML Plugin und removed in version 2023.3 (with the Confluence 8 support) |
Parameter
All parameters are optional.
Name | Description |
---|---|
datasources | Name of datasources to show information about.
Datasources must be configured by a Confluence administrator before they can be used. A short guide is given below. |
attributes | Names of attributes to show
see http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html |
Sample Images
Sample Code
Code Block |
---|
{database-info} {database-info:datasources=support,confluence|attributes=DatabaseProductName,TableTypes} |
Macro Browser
REST API
The functions of this macro are also available via REST.
Configuring a datasource
- Edit fileĀ
atlassian-confluence-<version>/conf/server.xml
Add each datasource as resource below the following lines
Code Block <Context path="" docBase="../confluence" reloadable="false"> <Manager pathname=""/>
The configuration depends on the type of database. Some examples:
Code Block <!-- PostgreSQL --> <Resource name="jdbc/name_of_datasource" auth="Container" type="javax.sql.DataSource" username="to_be_replaced" password="to_be_replaced" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://dbserver.company.com:5432/dbname" validationQuery="Select 1"/> <!-- Oracle --> <Resource name="jdbc/name_of_datasource" auth="Container" type="javax.sql.DataSource" username="to_be_replaced" password="to_be_replaced" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@//dbserver.company.com:1521/dbname" connectionProperties="SetBigStringTryClob=true" validationQuery="select 1 from dual" /> <!-- MySQL --> <Resource name="jdbc/name_of_datasource" auth="Container" type="javax.sql.DataSource" username="to_be_replaced" password="to_be_replaced" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://dbserver.company.com:3306/dbname?useUnicode=true&characterEncoding=utf8" defaultTransactionIsolation="READ_COMMITTED" validationQuery="select 1"/> <!-- Microsoft SQL Server --> <Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource" username="to_be_replaced" password="to_be_replaced" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://<host>:1433;database=<database-name>" validationQuery="select 1"/>
- Confluence comes with JDBC drivers for PostgreSQL and MS SQL Server.
If you want to connect to other databases than an appropriate JDBC driver must be obtained and placed inatlassian-confluence-<version>/lib
Restart Confluence