Contents : Installing Project Reporter
Installing JDBC drivers for database access

If you want Project Reporter to load project data from a database such as Oracle or SQL Server, you may wish to install a JDBC driver for this purpose. 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 where ODBC is not supported.

The first step in installing a JDBC driver is to obtain the class files for the driver, and place them in the appropriate directory on the server where Project Reporter is running, relative to the directory containing the class files for the Project Reporter servlet. If you are using the Apache Tomcat server, which is included with some versions of Project Reporter, you can place the driver class files in expanded form in the WEB-INF/classes directory for the projectreporter web application, or in .jar form in the WEB-INF/lib directory.

Once you have put the driver class files in the correct location, you should restart the server and create a data source in Project Reporter to test the connection. For this step you will need information specific to your database installation, such as the name of the database host, the correct port number, a login ID and password, etc.

If the data source you create does not function properly, Project Reporter should display an error message that will help you diagnose the problem. The most common problems are that Project Reporter cannot access the driver classes (ClassNotFoundError), or that JDBC URL string, login ID, or password are not correct.