JasperReports Server can connect to just about any data source. JasperReports Server comes standard with connection wizards for JDBC, JNDI, and Bean (Java bean) data sources. Jaspersoft also offers an extensible environment for including custom data sources in screens etc. Check the JasperServer Users Guide for details.
Acquire the Database Driver Package
JasperReports Server redistributes a Postgres database driver. If you need to connect to another database, you will need to acquire the appropriate driver and add it the application server's classpath.
Here are some links that may assist. Check with your DBA to ensure you are using the correct driver.
- MySQL driver: http://dev.mysql.com/downloads/connector/j/
- jTDS driver for SQL Server and Sybase: http://jtds.sourceforge.net/
- Microsoft SQL Server: http://msdn.microsoft.com/en-us/data/aa937724.aspx
- Oracle: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
- PostgreSQL: http://jdbc.postgresql.org/
- Pervasive: http://www.pervasivedb.com/psqlv11/Pages/Default.aspx
Extract the downloaded files to an easily accessed location. For example, c:jdbc or /usr/share. Locate the actual driver name. You will copy it to the classpath in the next step. Sample driver names include:
- MySQL: mysql-connector-java-5.1.18-bin.jar
- jTDS: jtds-1.2.2.jar
- Microsoft SQL Server: sqljdbc4.jar (for JDK 1.6/6.0), sqljdbc.jar (JDK 1.5/5.0)
- Oracle: ojdbc14.jar, ojdbc6.jar
- PostgreSQL: postgresql-8.1-407.jdbc3.jar
- Pervasive: jpscs.jar, pvjdbc2.jar, and pvjdbc2x.jar
Copy the Driver to the Classpath
You need to copy the driver (the .jar file) to the classpath.
In general it's best to copy the driver to the application server's shared library location. Refer to your application server documentation for exact locations. Sample locations include:
- Tomcat5: commonlib (for example: C:/Program Files ( x86)/jasperreports-server-4.0/apache-tomcat/lib )
- Tomcat6: lib ( for example: /var/lib/tomcat6/lib )
- JBoss5: serveralllib
Optional JNDI Configuration
You can define a JNDI connection in your application server. The database drivers must be in the application server's shared library classpath (see the previous section).
The technique you use to define the JNDI connection will vary by application server. For Tomcat, you can define the JNDI connection within JasperReports Server by editing /webapps/jasperserver-pro/META-INF/context.xml. Use the sample configurations as a guide.
Restart JasperReports Server
Restart the application server. If you installed JasperReports Server using the Windows installer, there is a shortcut in the start menu to restart it.
Define the Data Source in JasperReports Server
- Log into JasperServer's web site. http://localhost:8080/jasperserver-pro
- Go to View | Repository.
- Click the second icon called Add Resource and select Data Source.
- Choose a data source type and click next.
- Provide any Name, Label, and Description.
- If you selected the JDBC connection type, you will typically enter values such as these samples:
MySQL Connector/J
- driver: com.mysql.jdbc.Driver
- url: jdbc:mysql://localhost:3306/sakila
jTDS (for Microsoft SQL Server)
- driver: net.sourceforge.jtds.jdbc.Driver
- url: jdbc:jtds:sqlserver://host:1433/yourDatabase
- url: jdbc:jtds:sqlserver://host:1433/yourDatabase;intance=yourInstance
Microsoft SQL Server
- driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
- url: jdbc:sqlserver://host:1433;databaseName=yourDatabase
Oracle (thin driver)
- driver: oracle.jdbc.OracleDriver or oracle.jdbc.driver.OracleDriver
- url: jdbc:oracle:thin:@host:1521:your_db_instance_name
- example url: jdbc:oracle:thin:@remotehost:1521:orcl
- example url: jdbc:oracle:thin:@localhost:1521:xe
PostgreSQL
- driver: org.postgresql.Driver
- url: jdbc:postgresql://host:5432/yourDatabase
Pervasive
- driver: com.pervasive.jdbc.v2.Driver
- url: jdbc:pervasive://localhost:1583/DEMODATA
Troubleshooting
If it doesn't succeed, save anyway and restart the JasperReports Server and watch for any exceptions.
Recommended Comments
There are no comments to display.