Simple - this is the most straightforward way to connect to your database.The Confluence setup wizard will provide you with two setup options: JDBC is the recommended method for connecting to your database. The Confluence setup wizard will guide you through the process of connecting Confluence to your database. Restart Confluence then go to your browser to continue the setup process.jar file in your /confluence/WEB-INF/lib directory. The driver file will be called something like ojdbc8.jar Head to Database JDBC Drivers and download the appropriate driver.To make your database driver available to Confluence: Download and install the Oracle thin driverĭue to licensing restrictions, we're not able to bundle an Oracle driver with Confluence.

When you create a user, specify the tablespace for the table objects as shown above.Ĭheck out the Confluence Installation Guide for step-by-step instructions on how to install Confluence on your operating system. That permission can cause problems with other schemas. Confluence requires only these privileges so you should grant specific privileges to the user. create table , create sequence, and create trigger shouldn't be assigned as part of a role.ĭo not grant the user the select any table permission. It is very important that the user is granted the exact privileges indicated above. Create user identified by default tablespace quota unlimited on

Oracle 11g documentation