Available in PaperCut NG and PaperCut MF.

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/MF installations.

PaperCut NG/MF 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/MF.

Database driver

PaperCut NG/MF 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.

NOTE

Are you running Oracle 9i or above?

If so, we recommend you go to the server.properties file, located in [apppath]\server on the PaperCut NG/MF 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., and change the database URL
from:
database.driver=oracle.jdbc.driver.OracleDriver
to:
database.driver=oracle.jdbc.OracleDriver

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 Server. This allows PaperCut to find and load the driver.

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