Unable to locate a suitable JDBC driver to establish a connection - PI 7.11

[Former Member]

Hi there,

I'm starting developing in a new PI 7.11 environment and Basis Team already deploy the drivers sucessfully.

But, when I'm testing JDBC interface with SQL Sever 2008 I get the error below:

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: 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:

I already tested conexion using Telnet from PI server in por 1433 and its working fine.

I logged in the SQL Server 2008 database using SQL Client from my desktop and its also working fine.

My communication channel is filled as bellow:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://<hostname>:<port=1433>;DatabaseName=<database>

Can anyone help me about this problem ?

Thanks in advance

[Former Member]

I fixed the SQL driver in communication channel and error changes:

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish connection:: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect

The Conexion was wrong, now fixed is:

Connection: jdbc:sqlserver://<hostname>:<port=1433>;DatabaseName=<database>

Edited by: Regis Ferrato on May 11, 2011 10:42 PM

[Former Member]

Please ensure the JDBC drivers were deployed carrying out the steps from the OSS note below:

[Note 1138877 - PI 7.1 : How to Deploy External Drivers JDBC/JMS Adapters|https://websmp230.sap-ag.de/sap(bD1wdCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1138877]

Then use the tool from the OSS note below for testing the JDBC connection to the database.

[Note 1085539 - XI JDBC/FTP connection Test and XML Validation Application|https://websmp230.sap-ag.de/sap(bD1wdCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1085539]

[baskar_gopalakrishnan2]

>>Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish connection:: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect

Check whether there is any firewall issue to reach database port. The error shows connection timed out. Your database connection string is right. Also you fixed jdbc driver issue. This is purely network connectivity issue.

Suggestion:

Can you check using SQLPLus or Toad or some client tool and test the database connectivity by doing some sql statement test?

Also check PI server and sql server are in the same firewall or any network issues between them.

[Former Member]

Hi

Connection timed out..this means there is a some port blocking between PI and Table. Ask network team to check you can ping the data base from PI system. If not open the ports between PI and Database

Regards

Monika