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:

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

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 Tibco"
    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;sendTimestampEscapeAsString=false;databaseName=jasperserver

Enter the following for Test Table Name in step 19:

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

Configuring an Oracle Connection with the Vendor's Driver

To use the vendor's driver for Oracle, enter the following properties:

Enter the following for Test Table Name in step 19:

Configuring a DB2 Connection with the Vendor's Driver

To use the vendor's driver for DB2, enter the properties below.

Enter the following for Test Table Name in step 19:

Configuring a SQL Server Connection with the Vendor's Driver

To use the vendor's driver for SQL Server, enter the following properties:

Enter the following for Test Table Name in step 19: