You are here: Installation > Advanced implementation > Deployment on an external database (RDBMS) > Configuring Oracle (and Oracle Express Edition)

Configuring Oracle (and Oracle Express Edition)

Oracle is a high-end database solution that provides a very robust and scalable data storage solution. And with the release of Oracle Express Edition, it is available at no cost, but it does have some limitations that should not impact PaperCut NG installations.

PaperCut NG supports Oracle versions 9.2 and higher. Oracle 8 (and earlier) are not supported because they did not support the TIMESTAMP datatype required by PaperCut NG.

Database driver

PaperCut NG does not ship with a driver for Oracle because Oracle does not allow us to redistribute the driver. Also, the recommended driver depends on the version of Oracle used. You can obtain these drivers from the Oracle website as described below.

To download the required version of the driver:

  1. Visit the Oracle web site here: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

  2. Select the appropriate Oracle version.

    The required file to download differs depending on the Oracle version.

  3. Download the relevant ojdbc.jar for your Oracle Database version.

  4. Copy the downloaded file into the [app-path]\server\lib-ext directory.

  5. Restart the service PaperCut Application ServerAn Application Server is the primary server program responsible for providing the PaperCut user interface, storing data, and providing services to users. PaperCut uses the Application Server to manage user and account information, manage printers, calculate print costs, provide a web browser interface to administrators and end users, and much more.. This allows PaperCut to find and load the driver.

Once the driver is installed into PaperCut NG, you can follow the standard upsizing procedure. For more information, see Upsize to an external database (RDBMS).


Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.