These instructions are for installing FlexDeploy on an existing Tomcat server. If you are installing a new server, see Installing FlexDeploy with included Tomcat for a simplified installation which includes the Tomcat 8.5.11 server. If you wish to use an existing Tomcat server, or to use a different version of Tomcat, please continue with this installation.
...
Open context.xml for editing. It is located in the <TOMCAT_HOME>/conf folder. Add one of the following into your context.xml depending on your database type.
...
Tip |
---|
title | Example JDBC URL (CONNECT_STRING) |
---|
|
- Oracle
- Localhost XE connection will look like this. jdbc:oracle:thin:@localhost:1521:XE
- SID based JDBC URL Syntax - jdbc:oracle:thin:@HOSTNAME:PORT:SID
- Service Name based JDBC URL Syntax - jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME
|
Code Block |
---|
language | xml |
---|
theme | RDark |
---|
title | Oracle |
---|
|
<Resource name="jdbc/flexdbDS" auth="Container" |
...
type="oracle.jdbc.pool.OracleDataSource" |
...
factory="oracle.jdbc.pool.OracleDataSourceFactory" |
...
...
**CONNECT_STRING**"
user="fd_admin" |
...
...
...
PASSWORD**"
connectionCachingEnabled="true" |
...
connectionCacheProperties="{InitialLimit=0, MinLimit=0, MaxLimit=100, ConnectionWaitTimeout=60, InactivityTimeout=60, AbandonedConnectionTimeout=60, PropertyCheckInterval=30}" |
...
validationQuery="select 1 from dual" |
...
...
useLocalSessionState="true" |
...
defaultAutoCommit="false" |
...
Code Block |
---|
language | xml |
---|
theme | RDark |
---|
title | Postgresql |
---|
|
<Resource name="jdbc/flexdbDS" auth="Container" |
...
type="javax.sql.DataSource" |
...
driverClassName="org.postgresql.Driver" |
...
...
**CONNECT_STRING**"
username="fd_admin" |
...
...
...
PASSWORD**"
maxTotal="100" |
...
...
validationQuery="select 1" |
...
...
useLocalSessionState="true" |
...
defaultAutoCommit="false" |
...
Code Block |
---|
language | xml |
---|
theme | RDark |
---|
title | MySQL |
---|
|
<Resource name="jdbc/flexdbDS" auth="Container" |
...
type="javax.sql.DataSource" |
...
...
...
...
PASSWORD**"
driverClassName="com.mysql.jdbc.Driver" |
...
...
**CONNECT_STRING**"
maxTotal="100" |
...
...
...
validationQuery="SELECT 1" |
...
...
useLocalSessionState="true" |
...
defaultAutoCommit="false" |
...
Configure Tomcat Environment
...