Skip to Content
avatar image
Former Member

JDBC adapter not working -- PI 7.1

Hi,

I am working on PI 7.1, SP 7, OS: Windows 2003 SP2 64 bit.

I have Proxy to JDBC scnarios. The DB is SQL 2005.

Now I had deployed the database drivers for SQL 2005 (sqljdbc.jar) as per the note 1138877.

When i tried to execute the JDBC receiver scenario it says in CC monitoring:

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: JDBC Adapter configuration not initialized: null

Whereas when I try to execute the JDBC sender scenario it says in CC monitoring:

Error during database connection to the database URL 'jdbc:sqlserver://<host>:1433;databaseName=Dialog_test' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://<host>:1433;databaseName=Dialog_test': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

After analysis I understand that the JDBC drivers are not deployed correctly.

Now when I try to redeploy the JDBC drivers, it is not allowing me to do so. The SDA file (com.sap.aii.adapter.lib.sda) is not detecting in JSPM (even if I use the force mode to start JSPM).

The JSPM 7.1 is on SP7.

I have already refered following notes:

1. 1138877

2. 1123333

3. 891895

Note: I have previously deployed the JDBC drivers succesfully on PI 7.1 with SP4.

Your inputs in this regards would be highly appreciated.

Regards,

Siddhesh S.Tawate

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jan 28, 2009 at 06:54 AM

    Hi

    Check JDBC Drivers if it is supporting JDK Vers 1.4 , if u have installed of higher version then it wud be problem it wonot supported.

    This is with PI 7.0 i am not sure with PI 7.1

    Still try it , guys any update on the above

    Srini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 28, 2009 at 07:26 AM

    Hi,

    Check your JDBC Adapter settings in Visual administrator.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30, 2009 at 06:04 AM

    Dear sid,

    better option is generate new ,Blank SDA file using driver tool and then try to deploy driver.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30, 2009 at 06:22 AM

    Hi

    for Error JDBC Adapter configuration not initialized: null

    perform Full CPA cache refresh using PIDIRUSER

    also could be these reasons

    1. Firewall ports are open to connect to database and proper auhentication is used.

    2 Wrong user name or password in JDBCadapter .

    3 Full CPA cache refresh is performed.

    4. JDBC dirvers were not installed correctly in XI

    5. Channel status is active in communication channel.

    6. Check all the connection parameters to connect your database in your CC is correct or not.

    Regards

    Abhishek

    Edited by: Abhishek Agrahari on Jan 30, 2009 7:25 AM

    Add comment
    10|10000 characters needed characters exceeded

    • HI All,

      I am also facing the same issue.

      Have added drivers for adapter framework as per note 1138877 .

      The file com.sap.aii.adapter.lib.sda is in EPS/in directory ,but JSPM is not detecting.

      Platform is Win 2003 MS SQL ,PI 7.1 SP 15 .

      Java version "1.6.0_12".

      Pls suggest.

      Regards

      Ajay

  • avatar image
    Former Member
    Dec 07, 2010 at 05:23 AM

    Hi,

    Sometimes, re-activating the communication channel too works.

    Regards,

    Priyanka

    Add comment
    10|10000 characters needed characters exceeded