Data Sources describes two ways to configure data sources for the macros provided by SQL. This page focuses on application server based data source configurations. The data source is refenced using the dataSource (Data source name) parameter. The exact configuration of a data source is application server and database specific. The configuration must be done by a Conflunece administrator and the Confluence application server must be restarted for changes to be active. The configuration must be done very carefully as any errors will result the data source being unusable . Each database you need to access in Confluence needs to a have a data source configuration. These are the major elements of the configuration - Application server data source configuration - consult your application server documentation on how this is done and problem determination mechanisms. Note that the configuration may be specific to the application server version. For example, older Tomcat versions have some different configurations.
- JDBC driver specific for the database to be accessed - consult your database documentation and other sources for the best JDBC driver to use.
- Installation of JDBC driver on the application server
- Database access - consult your database documentation on how to configure your database for access
Various users have provided some examples that covers many standard situations. This page can be used to share that type of information as well as problem determination information. This is the best place to start especially if you are not an expert in this area. |