SAP Knowledge Base Article - Preview

2810220 - JDBC Adapter PostgreSQL: Unable to locate a suitable JDBC driver to establish a connection. Check if the connection URL is correct.

Symptom

You have a JDBC Adapter communication channel connecting with PostgreSQL Database and the channel is failing with the error below:

com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection. Check if the connection URL is correct.

If you collect the 1514898 - XPI Inspector for troubleshooting XI, you can see errors related to the JDBC URL.

org.postgresql.Driver parseURL
WARNING: JDBC URL must contain a / at the end of the host or port
[EXCEPTION]
com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection. Check if the connection URL is correct.
at com.sap.aii.af.lib.util.concurrent.AbstractResourcePool.getResource(AbstractResourcePool.java:160)
at com.sap.aii.adapter.jdbc.XI2JDBC.processMessage(XI2JDBC.java:386)
at com.sap.aii.adapter.jdbc.XI2JDBC.dispatchMessage(XI2JDBC.java:258)
at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:215)
at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:290)
at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


Read more...

Environment

  • SAP NetWeaver
  • SAP Process Integration

Product

SAP NetWeaver all versions ; SAP Process Integration all versions

Keywords

Process Integration, PI, Process Orchestration, PO, NetWeaver, XI, AEX, jdbc driver, postgresql-42.2.5.jar, postgresql-42.2.6.jar , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.