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.
Contents[hide ] |
Acquire the Database Driver Package
JasperReports Server redistributes a MysqL 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.
- 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/
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:
- 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
- Postgresql: postgresql-8.1-407.jdbc3.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: <Catalina_home>/common/lib
- Tomcat6: <Catalina_home>/lib
- JBoss5: <jboss_home>/server/all/lib
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 <tomcat_home>/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
1. Log into JasperServer's web site. http://localhost:8080/jasperserver-pro
2. Go to View | Repository.
3. Click the second icon called Add Resource and select Data Source.
4. Choose a data source type and click next.
5. Provide any Name,Label,and Description.
6. If you selected the JDBC connection type,you will typically enter values such as these samples:
jTDS (for Microsoft sql Server)
- driver: net.sourceforge.jtds.jdbc.Driver
- url: jdbc:jtds:sqlserver://host:1433/yourDatabase
Microsoft sql Server
- url: jdbc:sqlserver://host:1433;databaseName=yourDatabase
Oracle (thin driver)
- driver: oracle.jdbc.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
7. Click Test and it should succeed.
Troubleshooting
If it doesn't succeed,save anyway and restart the JasperReports Server and watch for any exceptions.
