FlexDeploy provides a file distribution for Tomcat which simplifies the installation process. This distribution contains Tomcat, the FlexDeploy WAR, and the base configurations, leaving only a few simple steps to complete the install. The distribution contains the following components.
...
| Code Block |
|---|
| language | xml |
|---|
| theme | RDark |
|---|
| title | Oracle |
|---|
|
<Resource name="jdbc/flexdbDS" auth="Container"
type="oracle.jdbc.pool.OracleDataSource"
factory="oracle.jdbc.pool.OracleDataSourceFactory"
url="**CONNECT_STRING**"
user="fd_admin"
password="**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"
testOnBorrow="true"
useLocalSessionState="true"
defaultAutoCommit="false"
/> |
| Code Block |
|---|
| language | xml |
|---|
| theme | RDark |
|---|
| title | Postgresql |
|---|
|
<Resource name="jdbc/flexdbDS" auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="org.postgresql.Driver"
url="**CONNECT_STRING**"
username="fd_admin"
password="**FD_ADMIN_PASSWORD**"
maxTotal="100"
maxIdle="20"
validationQuery="select 1"
testOnBorrow="true"
defaultTransactionIsolation="READ_COMMITTED"
useLocalSessionState="true"
defaultAutoCommit="false"
/> |
| Code Block |
|---|
| language | xml |
|---|
| theme | RDark |
|---|
| title | MySQL |
|---|
|
<Resource name="jdbc/flexdbDS" auth="Container"
type="javax.sql.DataSource"
username="fd_adminfactory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
password
url="**FDCONNECT_ADMIN_PASSWORDSTRING**"
driverClassNameusername="com.mysql.jdbc.Driverfd_admin"
urlpassword="**CONNECTFD_ADMIN_STRINGPASSWORD**"
maxTotal="100"
maxIdle="10"
initialSize="10"
validationQuery="SELECT 1"
testOnBorrow="true"
defaultTransactionIsolation="READ_COMMITTED"
useLocalSessionState="true"
defaultAutoCommit="false"
/> |
Step 5. (Optional) Modify Tomcat server.xml for port if necessary.
...
| Note |
|---|
| title | Note for Oracle XE Database |
|---|
|
After starting your server, check the <FlexDeploy Home>/apache-tomcat-flexdeploy/logs/flexdeploy.0.log file for the following error message: - ORA-12519, TNS:no appropriate service handler found
If present, increase the number of processes for the database - Using SQLPlus update processes setting.
- alter system set processes=200 scope=spfile;
- Stop Tomcat
- Restart the XE Database
- Start Tomcat
|
...