REQUIREMENTS
...
Installation Steps
- Make sure Tomcat server is stopped at this point. If running using shutdown.sh or shutdown.bat script.
- Download latest Oracle JDBC driver from https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19c-downloads.html
...
-Requires ons.jar and ucp.jar of the same version as the JDBC driver (downloaded from the same site as ojdbc8.jar)
-context.xml must be updated to use the UCP JDBC driver
Steps to convert from JDBC to UCP driver:
-Stop Tomcat using shutdown script
-In the apache home/lib directory, remove the current ojdbc jar file (like ojdbc6.jar or ojdbc6dms.jar)
...
- . For example, ojdbc8-full.tar.gz.
- Remove ojdbc jar files like ojdbc*.jar or ojdbc*dms.jar from <FlexDeploy Home>/apache-tomcat-flexdeploy/lib.
- Copy ojdbc8.jar, ons.jar
...
- anducp.jar from
...
- download archive to <FlexDeploy Home>/apache-tomcat-flexdeploy/lib.
- Update <FlexDeploy Home>/apache-tomcat-flexdeploy/conf/context.xml as shown below. Make sure to take backup of existing context.xml file.
-Update the context.xml to look something like this:
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<Resource name="jdbc/flexdbDS" auth="Container" |
...
type="oracle.ucp.jdbc.PoolDataSource" |
...
factory="oracle.ucp.jdbc.PoolDataSourceImpl" |
...
connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource" |
...
minPoolSize="0" |
...
maxPoolSize="100" |
...
initialPoolSize="0" |
...
autoCommit="false" |
...
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST= |
...
**HOSTNAME**)(PORT= |
...
**PORT**)))(CONNECT_DATA=(SERVICE_NAME= |
...
**SERVICE_NAME**)))" |
...
user="fd_admin" |
...
password=" |
...
**FD_ADMIN_PASSWORD**" fastConnectionFailoverEnabled="true" |
...
connectionCachingEnabled="true" |
...
connectionCacheProperties="{InitialLimit=0, MinLimit=0, MaxLimit=100, ConnectionWaitTimeout=60, InactivityTimeout=60, AbandonedConnectionTimeout=300, PropertyCheckInterval=30}" |
...
validationQuery="select 1 from dual" |
...
testOnBorrow="true"/> |
...
- Replace **HOSTNAME** with database host name
...
- .
- Replace **PORT** with database listener port.
...
- Replace **SERVICE_NAME
...
- ** with database service name
...
- .
- Replace **FD_ADMIN_PASSWORD** with password of fd_admin.
Key Points
...
-URL must be in the format listed in the example, the JDBC short format of host:sid:port should not be used.
...