Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter

The & need to be replaced by &

Peter

On Sat, 4 Aug 2018, 22:47 Dave Cramer, <pg(at)fastcrypt(dot)com> wrote:

> Pretty sure this is a tomcat error .
>
> The connection string looks fine
>
> Dave Cramer
>
> davec(at)postgresintl(dot)com
> www.postgresintl.com
>
> On 30 July 2018 at 11:32, Didier Wiroth <didier(dot)wiroth(at)mesr(dot)etat(dot)lu>
> wrote:
>
>> Hello,
>> I'm trying to configure a postgres jndi resource in tomcat that needs to
>> connect via ssl and client certificate for authentication.
>> Unfortunately ... without success.
>>
>> The user is: esrde_aoo and authenticates with a certificate (no
>> password!).
>>
>> Here is the tomcat 8.5.31 (running on jre 1.8.0_152-b16) resource
>> configuration:
>> <Resource type="javax.sql.DataSource" auth="Container"
>> driverClassName="org.postgresql.Driver"
>> name="jdbc/pgrde"
>>
>> url="jdbc:postgresql://test.localhost:5432/esrde?user=esrde_aoo&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&sslcert=d:/apps/ssl/rde/esrde_aoo.crt&sslkey=d:/apps/ssl/rde/esrde_aoo.key"
>>
>> username="esrde_aoo"
>> />
>>
>> I tried many many different combination ... it always fails at the second
>> parameter.
>> org.apache.tomcat.util.digester.Digester.fatalError Parse Fatal Error at
>> line 21 column 79: The reference to entity "ssl" must end with the ';'
>> delimiter.
>> org.xml.sax.SAXParseException; systemId:
>> file:/D:/apps/web-data/tam/conf/db-context-ora12.xml; lineNumber: 21;
>> columnNumber: 79; The reference to entity "ssl" must end with the ';'
>> delimiter.
>> at
>> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
>> at
>> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1472)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(XMLScanner.java:913)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanAttribute(XMLDocumentFragmentScannerImpl.java:1548)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1315)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2784)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
>> at
>> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
>> at
>> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:841)
>> at
>> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770)
>> at
>> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
>> at
>> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
>> at
>> com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
>> at
>> org.apache.tomcat.util.digester.Digester.parse(Digester.java:1521)
>> at
>> org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:527)
>> at
>> org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:465)
>> at
>> org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:728)
>> at
>> org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:310)
>> at
>> org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94)
>> at
>> org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:395)
>> at
>> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:108)
>> at
>> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:140)
>> at
>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
>> at
>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
>> at
>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
>> at
>> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
>> at
>> org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
>> at
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>> at java.lang.Thread.run(Thread.java:748)
>>
>> I would really appreciate some help.
>>
>> Is my connection String correct?
>> Is this a tomcat or java bug?
>>
>> Thank you very much any hint/help!
>> Regards,
>> Didier
>>
>>
>

--

OpenTrainTimes Ltd. registered in England and Wales, company no. 
09504022.
Registered office: 13a Davenant Road, Upper Holloway, London N19
3NW