Project Reporter Help: JDBC data sources

Contents : Administering Project Reporter : Managing data sources and projects
JDBC data sources

You should use a JDBC data source if your projects are saved in a database such as Oracle, Microsoft Access, or SQL Server, and the Project Reporter server is running on a non-Windows platform, such as Linux.

To create a data source using a third-party JDBC database driver that you have previously configured, enter the driver class name and URL string (you may need to consult your database administrator for this information). For example, when using Oracle's JDBC driver, for "JDBC driver class name" you would enter:

oracle.jdbc.driver.OracleDriver

and for "JDBC URL string" you would enter:

jdbc:oracle:thin:@mydbhost:1521:orcl

where mydbhost is the name of the host running the Oracle server.

JDBC drivers can be used for better performance and reliability than ODBC on Windows platforms, or when the Project Reporter server is running on a non-Windows platform.