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 4in Procedure for Installing the WAR File for WebLogic
To use the driver, select DataDirect's Oracle Driver (Type4) from the menu after step 10 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 | SID=ORCL user=foodmart | SID=ORCL user=sugarcrm |
Make sure Test Table Name is blank. If it says SQL Null, delete this.
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 4 in Procedure for Installing the WAR File for WebLogic
<Driver Database="DB2" Vendor="Tibco" Type="Type 4" Cert="true" DatabaseVersion="7.X and later" ForXA="false" ClassName="tibcosoftware.jdbc.db2.DB2Driver" URLHelperClassname="weblogic.jdbc.utils.WLDB2JDBC4DriverURLHelper"> <Attribute Name="DbmsName" Required="true" InURL="false"/> <Attribute Name="DbmsHost" Required="true" InURL="true"/> <Attribute Name="DbmsPort" Required="true" InURL="true" DefaultValue="50000"/> <Attribute Name="DbmsUsername" Required="true" InURL="false"/> <Attribute Name="DbmsPassword" Required="true" InURL="false"/> </Driver>[/code] |
To use the driver, select the TIBCO driver for DB2 from the menu after step 10 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=db2admin alternateID=JSPRSRVR | user=db2admin alternateID=FOODMART | user=db2admin alternateID=SUGARCRM |
portNumber | 50000 | ||
databaseName | jsprsrvr | foodmart | sugarcrm |
alternateId | jsprsrvr | foodmart | sugarcrm |
serverName | localhost | ||
batchPerformance Workaround | true |
Make sure Test Table Name is blank. If it says SQL Null, delete this.
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 4 in Procedure for Installing the WAR File for WebLogic
To use the driver, select the TIBCO driver for SQL Server from the menu after step 10 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 |
Make sure Test Table Name is blank. If it says SQL Null, delete this.
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 |
Hibernate Dialect | MySQLInnoDBDialect |
Quartz Driver Delegate | StdJDBCDelegate |
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 |
Configuring a DB2 Connection with the Vendor's Driver
To use the vendor's driver for DB2, enter the following properties:
Database Setting | JasperReports Server | Foodmart Example | Sugar CRM Example |
---|---|---|---|
Host | localhost | ||
Name or SID | jsprsrvr | foodmart | sugarcrm |
currentSchema | JSPRSRVR | FOODMART | SUGARCRM |
User | db2admin | ||
Password | password | ||
Port | 50000 | ||
Hibernate Dialect | DB2JICustomDialect | ||
Quartz Driver Delegate | DB2v8Delegate |
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 |
Recommended Comments
There are no comments to display.