JDBC adapter not working -- PI 7.1

[Former Member]

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

[Former Member]

Hi,

Sometimes, re-activating the communication channel too works.

Regards,

Priyanka

[Former Member]

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

[ajjunit84]

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

[Former Member]

Dear sid,

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

Regards,

[Former Member]

Hi,

Check your JDBC Adapter settings in Visual administrator.

Thanks

[Former Member]

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