Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents

Supplied Database Connection Drivers

Styleclass
ClasstopLink

top

Database

Driver Version

Diaprism

 

CacheDB

2007.1.1.420

DB2

3.57.82

H2

 

HSQLDB

2.2.8

Actian

3.8.3

Sybase ASA/IQ

6.0.5

Pervasive PSQL

 

DB2/AS400

5.2

JTDS (MS SQL Server, Sybase ASE)

1.2.5

MySQL

5.1.18

Oracle

11.2.0.3

PostgreSQL

9.1-901

SQLite

3.7.2

Adding Database Connection Drivers

Styleclass
ClasstopLink

top

If you need to add additional connection drivers then:

  1. Copy your JDBC driver JAR file(s) into the Yellowfin/appserver/webapps/ROOT/WEB-INF/lib/ directory.
  2. If the DB Name is not in Yellowfin's database list (see below) you will need to edit the file Yellowfin/appserver/webapps/ROOT/WEB-INF/web.xml and add the class name for your driver to the list in the JDBCDrivers parameter.
    Note: if the database name is simply greyed out in the list you won't need to perform this step.
  3. You will then need to restart Yellowfin for the new driver to become available.

Updating the TCP/IP Port

Styleclass
ClasstopLink

top

The TCP/IP port is used for the connection from the browser. You may have to change the port number if you have another service running on the Yellowfin server which has a port conflict. Choose a Port number which is not being used by another service. Note: The port was initially configured during the installation process.

...

Code Block
xml
xml
linenumberstrue

<Server port="8085" shutdown="SHUTDOWN">		
  <Service name="Catalina">
    <Connector port="80"				
               maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               connectionTimeout="20000" disableUploadTimeout="true"
               URIEncoding="UTF-8"
               compression="on"
               compressionMinSize="2048"
               noCompressionUserAgents="gozilla, traviata"
               compressableMimeType="text/html,text/xml,text/plain"
               />

    <!-- Uncomment this for an SSL connector running on port 8443 (change
         the port as required). You will need to generate a certificate
         and save it in this directory as "tomcat.key" (change the
         keystoreFile and keystorePass values as required).
         See: http://tomcat.apache.org/tomcat-5.5-doc/ssl-howto.html -->
    <!--
    <Connector port="8443"				
               maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" disableUploadTimeout="true"
               acceptCount="100" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
               keystoreFile="${catalina.home}/conf/tomcat.key"
               keystorePass="password"
               />
    -->
    
    <!-- Uncomment this for an AJP connector, to connect tomcat to another
         web server such as Apache or IIS -->
    <!--
    <Connector port="8009" protocol="AJP/1.3" />	
    -->

    <Engine name="Catalina" defaultHost="localhost">
      <Host name="localhost" appBase="webapps"
       unpackWARs="true" autoDeploy="false"
       xmlValidation="false" xmlNamespaceAware="false">
      </Host>
    </Engine>
  </Service>
</Server>

 

horizontalrule
Styleclass
ClasstopLink

top