JReport supports all of the current mainstream databases as well as most databases which support ODBC or JDBC drivers. The following table lists the databases and JDBC drivers that have been tested with JReport. If you are using any of the databases listed below, you are recommended to use the corresponding driver version with JReport although any driver which the DBMS supplier recommends is also fine. Also, if you encounter problems when using a database or driver version that is not listed here, you can contact Jinfonet Support (support@jinfonet.com) for help.
|
Database
|
Version
|
Driver File Name
|
JDBC Driver
|
Example URL
|
|---|---|---|---|---|
| MS SQLServer | 2008 | sqljdbc.jar | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://<host>:33;DatabaseName=test |
| MS SQL Server | 2005 | sqljdbc.jar | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://<host>:1433;user=sa;password=1234;database=test |
| MS SQL Server | 2000 | msbase.jar; msutil.jar; mssqlserver.jar | com.microsoft.jdbc.sqlserver.SQLServerDriver | jdbc:microsoft:sqlserver://<host>:1433 |
| MS SQL Server | 2000 | Opta2000.jar | com.inet.tds.TdsDriver | jdbc:inetdae7:<host>:1433?database=test |
| MS SQL Server | 2000 | tds-1.0.3.jar | net.sourceforge.jtds.jdbc.Driver | jdbc:jtds:sqlserver://<host>:1433/test |
| Oracle | 11.2.0.1.0 (64bit) | classes12.jar; ojdbc5.jar; ojdbc6.jar | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@<host>:1521:orcl |
| Oracle | 11.1.0.6.0 (11g) | JDK1.5: ojdbc5.jar; JDK1.6: ojdbc6.jar | oracle.jdbc.OracleDriver | jdbc:oracle:thin:@<host>:1521:ora11g |
| Oracle | 10.1.0.2.0 (10g) | JDK1.2&1.3: classes12.zip; JDK1.4: ojdbc14.jar | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@<host>:1521:ora9i |
| Oracle | 9i | JDK1.2&1.3: classes12.zip; JDK1.4: ojdbc14.jar | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@<host>:1521:ora9i |
| DB2 | 9.7.200.358 | db2jcc4.jar | com.ibm.db2.jcc.DB2Driver | jdbc:db2://<host>:50000/test |
| DB2 | 9.1.0.356 | db2java.zip; db2jcc.jar; db2jcc_javax.jar; db2jcc_license_cu.jar; db2policy.jar | com.ibm.db2.jcc.DB2Driver | jdbc:db2://<host>:50000/test |
| DB2 | 8.2 | Db2jcc.jar; db2jcc_license_cu.jar (Linux, Unix and Windows); db2jcc_license_cisuz.jar (Linux, Unixand Windows, z/OS, OS/390,z/OS, iSeries etc) | com.ibm.db2.jcc.DB2Driver | jdbc:db2://<host>:50000/test |
| DB2 | 8.2 | Db2java.zip | com.ibm.db2.jdbc.app.DB2Driver | jdbc:db2:test |
| DB2 | 8.1 | Db2java.zip; db2jcc.jar | com.ibm.db2.jdbc.net.DB2Driver | jdbc:db2://<host>/test |
| DB2 | 8.1 | Db2java.zip | com.ibm.db2.jdbc.app.DB2Driver | jdbc:db2:test |
| RedBrick warehouse | redbrick.jar | redbrick.jdbc.RBWDriver | jdbc:rbw:protocol:<host>:5050/test/ | |
| Informix | 11.50.TC7DE | jdbc.jar | com.informix.jdbc.IfxDriver | jdbc:informix-sqli://<host>:9090/informixdatatype:INFORMIXSERVER=ol_informix |
| Informix | 9.40.TC1E1 | ifxjdbc.jar | com.informix.jdbc.IfxDriver | jdbc:informix-sqli://<host>:1527/Demo:INFORMIXSERVER=ol_informix |
| Informix | 9.30 | ifxjdbc.jar | com.informix.jdbc.IfxDriver | jdbc:informix-sqli://<host>:1526/stores_demo:informixserver=DBSC |
| MySQL | 5.5.24 (64bit) | mysql-connector-java-5.1.7-bin.jar | com.mysql.jdbc.Driver | jdbc:mysql://<host>:3306/test |
| MySql | mysql 5 | mysql-connector-java-5.0.4-bin.jar | com.mysql.jdbc.Driver | jdbc:mysql://<host>:3306/test |
| MySql | mysql-5.0.2-alpha-win | mysql-connector-java-3.1.5-gamma-bin.jar | com.mysql.jdbc.Driver | jdbc:mysql://<host>:3306/test |
| MySql | mysql-5.0.18-win32 | mysql-connector-java-5.0.3-bin.jar | com.mysql.jdbc.Driver | jdbc:mysql://<host>:3306/test |
| MySql | mysql-4.1.12-win32 | mysql-connector-java-3.1.10-bin.jar | com.mysql.jdbc.Driver | jdbc:mysql://<host>:3306/test |
| MySql | mysql 4 | mysql-connector-java-3.0.14-production-bin.jar | com.mysql.jdbc.Driver | jdbc:mysql://<host>:3306/test |
| HSQL | hsqldb.jar | org.hsqldb.jdbcDriver | jdbc:hsqldb:D:\JReport\Demo\db\SampleDB | |
| Sybase | 12.5 | jconn2.jar | com.sybase.jdbc2.jdbc.SybDriver | jdbc:sybase:Tds:<host>:5000/master |
| Sybase | 12.5 | jconn3d.jar | com.sybase.jdbc3.jdbc.SybDriver | jdbc:sybase:Tds:<host>:5000/master |
| PostGre SQL | 8.3.0 | postgresql-8.3-607.jdbc2.jar | org.postgresql.Driver | jdbc:postgresql://<host>:5432/postgres |
| PostGre SQL | 8.2.13 | postgresql-8.2-506.jdbc3.jar | org.postgresql.Driver | jdbc:postgresql://<host>:5432/postgres |
| PostGre SQL | 8.0 | postgresql-8.0-310.jdbc3.jar | org.postgresql.Driver | jdbc:postgresql://<host>:5432/test |
| Cache | Cache 4 | CacheDB.jar | com.intersys.jdbc.CacheDriver | jdbc:Cache://<host>:1972/samples |
| Derby | 10.8.1.2 | derby.jar; derbyclient.jar | org.apache.derby.jdbc.ClientDriver | jdbc:derby://<host>:1528/test |
| Derby | 10.5.3.0 | derby.jar; derbyclient.jar | org.apache.derby.jdbc.ClientDriver | jdbc:derby://<host>:1527/test |
| Derby | 10.5.1.1 | derby.jar | org.apache.derby.jdbc.EmbeddedDriver | jdbc:derby:D:\derby\demo\databases\toursdb |
Note: If you want to use the DB2 app connection, you need to install the client and configure the net address first.