Configuring Other Database Connections

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

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 5 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>

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 5 in Procedure for Installing the WAR File for WebLogic

<Driver
    Database="SQL Server"
    Vendor="TIBCO"
    Type="Type 4"
    DatabaseVersion="7.0 and later"
    ForXA="false"
    Cert="true"
    ClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver"
    URLHelperClassname="weblogic.jdbc.utils.MSSQL2005JDBC4DriverURLHelper">
        <Attribute Name="DbmsName" Required="false" InURL="false"/>
        <Attribute Name="DbmsHost" Required="true" InURL="true"/>
        <Attribute Name="DbmsPort" Required="true" InURL="true"
DefaultValue="1433"/>
        <Attribute Name="DbmsUsername" Required="true" InURL="false"/>
        <Attribute Name="DbmsPassword" Required="true" InURL="false"/>
  </Driver>

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.

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

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

Feedback