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 for Me (Login required).

Search for additional results

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