Add Oracle Data Source in JasperServer

 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: \common\lib (for example: C:/Program Files (x86)/jasperreports-server-4.0/apache-tomcat/lib )
• Tomcat6: \lib (for example: /var/lib/tomcat6/lib)
• JBoss5: \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 /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:

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.