Skip to Content
avatar image
Former Member

JDBC connection not working for MS sql

Hi Team,

Hope all are doing well.

currently we are working on SAP PO 7.4 single stack.

we are using JDK version 16 and installed MS SQL 2000.

when we tried to send message to database we are getting below error.

Transmitting the message to endpoint <local> using connection IDoc_AAE_http://sap.com/xi/XI/System failed, due to: 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: Cannot establish connection with the registered driver. com.microsoft.jdbc.sqlserver.SQLServerDriver returns: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket..

: SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing sock



same drivers we used in SAP PI 7.11 and there we used JDK 13 and there we are able to send the message to same database successfully.


but in 7.4 we are getting error as above.


can you please check and guide me to fix the issue asap.


Thanks

Madhu T

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 04, 2016 at 12:05 PM

    Hi Madhu,

    Check this sap note to use right driver 1615198 - PI JDBC and JMS Adapter driver's JRE compatibility

    according to above note you need to deploy sqldriver4 jar file in your PI server. Did you deploy this jar file??


    MSSQL driver JREsqldriver121.4sqldriver5.0sqldriver4 6.0


    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Praveen,

      Thanks for your mail.

      we are now using same SQLDRIVER4 and along these we are using another sqljabc which is old version. my doubt even though latest drivers in system is it taking older versions?

      is system behave like this?

      Please confirm.

      Thanks

      Madhu T

  • Apr 05, 2016 at 04:10 AM

    The error says - Error Establishing Socket. Can you check if the Firewall ports to the TCP Port of your DB is open? You can do a Telnet command from the PI Server to confirm the same ( or your basis team can ).

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhavesh,

      Thanks for your mail.

      we are unable to connect to their host due to getting the error with drivers .

      Thanks

      Madhu