On 08/03/2023 03:50, Poh Wei Xiang wrote:
Hi,
I am encountering an issue validating my application database connectivity, it
throws java.sql.SQLException: The url cannot be null upon validation.
Full stack trace please.
Mark
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org