On 09/03/2023 05:55, Poh Wei Xiang wrote:
Hi,
Glad to hear that this is going to be fixed.
Do you have a sample context format to work with connectionstring?
You just duplicate the current setting for url to connectionString. So
the configuration at the start of this thread becomes:
<?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"
connectionString="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>
Mark
Sent from Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Mark Thomas <ma...@apache.org>
Sent: Wednesday, 8 March 2023, 20:14
To: users@tomcat.apache.org <users@tomcat.apache.org>
Subject: Re: Encountered java.sql.sqlexception "the url cannot be null"
starting from tomcat 9.0.71
On 08/03/2023 11:58, Mark Thomas wrote:
Thanks,
I am able to recreate that stack trace. I am looking into the root cause
now.
Found it.
There was a change in Commons DBCP to use "connectionString" rather than
url internally and this was mistakenly applied to the lookup of the
"url" configuration setting in DriverAdapterCPDS.
I'll get this fixed for the April round of releases.
If you need a workaround, if you add a configuration setting for
connectionString="..." that has the same vaue as url="..." that should
get things working.
Mark
Mark
On 08/03/2023 09:03, Poh Wei Xiang wrote:
Hi,
java.sql.SQLException: The url cannot be null
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.tomcat.dbcp.dbcp2.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:396)
org.apache.tomcat.dbcp.dbcp2.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:1225)
org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolDataSource.registerPool(PerUserPoolDataSource.java:708)
org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolDataSource.getPooledConnectionAndInfo(PerUserPoolDataSource.java:614)
org.apache.tomcat.dbcp.dbcp2.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:206)
com.avaya.sce.runtime.jdbc.Database.open(Database.java:93)
org.apache.jsp.jsp.validate_002ddb_jsp._jspService(validate_002ddb_jsp.java:721)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:389)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Unknown Source)
With Regards,
Poh Wei Xiang
Senior Engineer
D: +65 6826 3865
A: 6 Serangoon North Ave 5, #03-16, Singapore 554910
W: www.nxg-c.com<http://www.nxg-c.com>
Service Helpdesk: +65 6842 2300
Service Email: serv...@nxg-c.com
Follow us:
NxGen Communications, a subsidiary of TeleChoice International
Limited, a company of ST Telemedia Pte Ltd
This email is intended solely for the use of the addressee and may
contain information that is confidential or subject to legal
professional privilege. If you receive this email in error, please
immediately notify the sender and delete the email.
-----Original Message-----
From: Mark Thomas <ma...@apache.org>
Sent: Wednesday, 8 March 2023 4:35 pm
To: users@tomcat.apache.org
Subject: Re: Encountered java.sql.sqlexception "the url cannot be
null" starting from tomcat 9.0.71
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
