Configuring TIBCO JDBC Driver Connections
Configuring a TIBCO JDBC Oracle Connection
If you're using the TIBCO JDBC driver for Oracle, add the driver to the WebLogic jdbcdrivers.xml file as described in step 5in Procedure for Installing the WAR File for WebLogic
To use the driver, select DataDirect's Oracle Driver (Type4) from the menu after step 11 in Procedure for Installing the WAR File for WebLogic and enter the following properties:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
JNDI Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
URL | jdbc:tibcosoftware:oracle://localhost:1521;SID=ORCL | ||
Driver Class Name | tibcosoftware.jdbc.oracle.OracleDriver | ||
Properties | SID=ORCL user=jasperserver CatalogOptions=0 | SID=ORCL user=foodmart CatalogOptions=0 | SID=ORCL user=sugarcrm CatalogOptions=0 |
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jasperserver | foodmart | sugarcrm |
Test Table Name | DUAL | DUAL | DUAL |
Configuring a TIBCO JDBC DB2 Connection
If you're using the TIBCO JDBC driver for DB2, add the following information to the WebLogic jdbcdrivers.xml file, as described in step 5 in Procedure for Installing the WAR File for WebLogic
[/code] |
To use the driver, select the TIBCO driver for DB2 from the menu after step 11 in Procedure for Installing the WAR File for WebLogic and enter the following properties. For the URL, enter the value of the databaseName lower in the table. For example, for the jasperserver database, the URL is jdbc:tibcosoftware:db2://localhost:50000;databaseName=jsprsrvr;AlternateID=jsprsrvr
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
JNDI Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
URL | jdbc:tibcosoftware:db2://localhost:50000;databaseName=<databaseName>;AlternateId=<databaseName> | ||
Driver Class Name | tibcosoftware.jdbc.db2.DB2Driver | ||
Properties | user=db2inst1 alternateID=JSPRSRVR | user=db2inst1 alternateID=FOODMART | user=db2inst1 alternateID=SUGARCRM |
portNumber | 50000 | ||
databaseName | jsprsrvr | foodmart | sugarcrm |
alternateId | jsprsrvr | foodmart | sugarcrm |
serverName | localhost | ||
batchPerformance Workaround | true |
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jsprsrvr | foodmart | sugarcrm |
Test Table Name | JIREPORTJOB | ACCOUNT | ACCOUNTS |
Configuring a TIBCO JDBC SQL Server Connection
If you're using the TIBCO JDBC driver for SQL Server, add the following information to the WebLogic jdbcdrivers.xml file, as described in step 5 in Procedure for Installing the WAR File for WebLogic
[/code] |
To use the driver, select the TIBCO driver for SQL Server from the menu after step 11 in Procedure for Installing the WAR File for WebLogic and enter the following properties. For the URL, enter the value of the databaseName lower in the table. For example, for the jasperserver database, the URL is jdbc:tibcosoftware:sqlserver://localhost:1433;databaseName=jasperserver
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
JNDI Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
URL | jdbc:tibcosoftware:sqlserver://localhost:1433;databaseName=<databaseName> | ||
Driver Class Name | tibcosoftware.jdbc.sqlserver.SQLServerDriver | ||
Properties | user=sa | ||
databaseName | foodmart | jasperserver | sugarcrm |
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jsprsrvr | foodmart | sugarcrm |
Test Table Name | jireportjob | account | accounts |
Configuring Databases Using the Vendor's Driver
Use these settings to connect to a database other than PostgreSQL using the database vendor's driver.
Configuring a MySQL Connection
Database Setting | Value |
---|---|
Host | localhost |
Name or SID | jasperserver |
User | root |
Password | password |
Port | 3306 |
characterEncoding | UTF-8 |
autoReconnect | true |
tinyInt1isBit | false |
autoReconnectForPools | true |
Hibernate Dialect | MySQLInnoDBDialect |
Quartz Driver Delegate | StdJDBCDelegate |
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jsprsrvr | foodmart | sugarcrm |
Test Table Name | JIReportJob | account | accounts |
Configuring an Oracle Connection with the Vendor's Driver
To use the vendor's driver for Oracle, enter the following properties:
Database Setting | Value |
---|---|
Host | localhost |
Name or SID | Orcl |
User | jasperserver |
Password | password |
Port | 1521 |
Hibernate Dialect | OracleJICustomDialect |
Quartz Driver Delegate | StdJDBCDelegate |
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jasperserver | foodmart | sugarcrm |
Test Table Name | DUAL | DUAL | DUAL |
Configuring a DB2 Connection with the Vendor's Driver
To use the vendor's driver for DB2, enter the properties below.
Database Setting | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Host | localhost | ||
Name or SID | jsprsrvr | foodmart | sugarcrm |
currentSchema | JSPRSRVR | FOODMART | SUGARCRM |
User | db2inst1 | ||
Password | password | ||
Port | 50000 | ||
Hibernate Dialect | DB2JICustomDialect | ||
Quartz Driver Delegate | DB2v8Delegate |
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jsprsrvr | foodmart | sugarcrm |
Test Table Name | JIREPORTJOB | ACCOUNT | ACCOUNTS |
Configuring a SQL Server Connection with the Vendor's Driver
To use the vendor's driver for SQL Server, enter the following properties:
Database Setting | SQL Server |
---|---|
Host | localhost |
Name or SID | jasperserver |
User | sa |
Password | sa |
Port | 1433 |
Hibernate Dialect | SQLServerJICustomDialect |
Quartz Driver Delegate | StdJDBCDelegate
|
Enter the following for Test Table Name in step 19:
Parameter Name | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Name | JasperServerDataBase | FoodmartDataBase | SugarcrmDataBase |
User | jsprsrvr | foodmart | sugarcrm |
Test Table Name | jireportjob | account | accounts |
Recommended Comments
There are no comments to display.