Skip to Content
author's profile photo Former Member
Former Member

Error while importing external definition for jdbc look up

Hi,

For jdbc look up I am trying to import meta data of table but I am getting the following error:

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.mysql.jdbc.Driver returns: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server..

: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server

Error processing request in sax parser: Error when executing statement for table/stored proc. 'metadataRequest'

Could you please help to solve this issue.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Posted on Feb 17, 2014 at 08:06 AM

    Hi,

    You can test your JDBC connection using guidelines stated in SAP note 1085539 - XI JDBC/FTP connection test and XML validation application. As far as I know, to import a DB table, a working connection is required šŸ˜Š

    Regards,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2014 at 08:42 AM

    And

    Can you check authorization of user id used in JDBC receiver communication channel ? and also check driver compatibility.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 17, 2014 at 08:11 AM

    Hi Brahmaji,

    Did You check the following thread that may help:

    http://scn.sap.com/thread/3216155

    Regards

    GB

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 17, 2014 at 08:37 AM

    Hi Brahmaji,

    You should to check your jdbc connection. Please, try to check it with the tool provide by SAP in this note: 1085539 - XI JDBC/FTP connection Test and XML Validation Application

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2014 at 08:41 AM

    change the URL as like

    URL follows:

    jdbc:mysql://<host>/<DBName>?sessionVariables=sql_Mode=ANSI

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2014 at 09:02 AM

    Hi,

    Thanks for your suggestions,

    I did file-jdbc scenario in that receiver jdbc channel is working fine,details of that channel I have provided while importing external definition.

    and I also tried as vamshi said but still getting the error.

    can any one help me to get out of this problem.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 17, 2014 at 09:09 AM

    Hi,

    May be there isn't enough pool resources. Check this note 1473299 - Setting Maximum Concurrency and poolWaitingTime in File/Jdbc

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.