...
| Anchor | ||||
|---|---|---|---|---|
|
| Table of Contents | ||
|---|---|---|
|
Supplied Database Connection Drivers
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
If you need to add additional connection drivers then:
- Copy your JDBC driver JAR file(s)
...
- into
...
- the
...
- Yellowfin/appserver/webapps/ROOT/WEB-INF/lib/
...
- directory.
...
- 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.
...
- You will then need to restart Yellowfin for the new driver to become available.
Updating the TCP/IP Port
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.
To update you port number open the server.xml file located in:
Yellowfin/appserver/conf/server.xml
...
There
...
are
...
two
...
ports
...
that
...
are
...
used
...
by
...
Yellowfin
...
by
...
default,
...
and
...
two
...
more
...
that
...
can
...
be
...
configured:
...
- The
...
- port
...
- that
...
- Tomcat
...
- listens
...
- on
...
- for
...
- shut
...
- down
...
- requests
...
- (used
...
- internally
...
- by
...
- Tomcat)
...
- (see
...
- line
...
- 1,
...
- below)
...
- The port that Tomcat listens on for HTTP browser connections (see line 3, below)
- The port that Tomcat listens on for HTTPS browser connections (see line 21, below)
- The port that Tomcat listens on for AJP connections (used when connecting Tomcat to IIS or Apache) (see line 35, below)
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<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>
{code}
\\
\\
{horizontalrule}
{styleclass: Class=topLink} [top|#top] {styleclass} |