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 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 | 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 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=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 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 |
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.
Database Setting | MySQL | Oracle | DB2 | SQL Server |
---|---|---|---|---|
Host | localhost | localhost | localhost | localhost |
Name or SID | jasperserver | Orcl | jsprsrvr | jasperserver |
User | root | jasperserver | db2admin | sa |
Password | password | password | password | sa |
Port | 3306 | 1521 | 50000 | 1433 |
Hibernate Dialect | MySQLInnoDB | OracleJICustom | DB2JICustomDialect | SQLServerJI |
Quartz Driver Delegate | StdJDBCDelegate | StdJDBCDelegate | DB2v8Delegate | StdJDBCDelegate |
Recommended Comments
There are no comments to display.