Hi,
I am encountering an issue validating my application database connectivity, it
throws java.sql.SQLException: The url cannot be null upon validation.
The application is developed using Avaya’s Orchestration designer (Eclipse) and
database validation works until 9.0.70.
I hope someone can shed some light on how to resolve this issue as from time to
time, the customer will require us to upgrade tomcat to resolve vulnerability
issues.
Below is the context file for the application.
<?xml version="1.0" encoding="utf-8" standalone="no"?>
<Context docBase="./HDB_AVMS" path="/HDB_AVMS" reloadable="true">
<Resource auth="Container"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
factory="org.apache.tomcat.dbcp.dbcp2.cpdsadapter.DriverAdapterCPDS"
name="jdbc/AVMSCPDS"
type="org.apache.tomcat.dbcp.dbcp2.cpdsadapter.DriverAdapterCPDS"
url="jdbc:sqlserver://localhost:1433;databaseName=HDB_AVMS"/>
<Resource auth="Container" dataSourceName="java:/comp/env/jdbc/AVMSCPDS"
defaultMaxActive="10" defaultMaxIdle="5" defaultMaxWait="10000"
factory="org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolDataSourceFactory"
logAbandoned="true" name="jdbc/AVMS" removeAbandoned="true"
removeAbandonedTimeout="300" testOnBorrow="false"
type="org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolDataSource"
validationQuery="select 1 from AnyTable"/>
</Context>
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
