|
||||
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.