SAP PI 7.0 Compatibilty with JDK 1.5

[former_member185881]

Hi

Scenario is jdbc to idoc

Previously i was using SQL Server 2005 at the sender side and PI 7.0, everything was working fine.

Now i have updated SQL Server 2005 to SQL Server 2008

then i communication channel monitoring i got the error

Error during database connection to the database URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO': com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later.'

I have updated the JDBC drivers too which was latest available in microsioft website.

My SAP JDK version 1.4.

I found that SQL Server 2008 supports JDK5. So i need to know my PI 7.0 will support JDK5??? for this what are the thing i need to do.

Regards

Dheeraj Kumar

[rajasekhar_reddy14 · Accepted solution]

Hi,

PI7.1 required JDK 1.5,but not PI7.0

PI7.0 will run on JDK 1.5 version,download JDK1.5 from sun website,use it.uninstal 1.4.

Regards,

Raj

[former_member185881]

Hi All

PLEASE REFER THIS BLOG CREATED BY ME AND YOUR PROBLEM WILL BE SOLVED.

/people/dheeraj.kumar5/blog/2010/03/23/sql-server-2008-connectivity-with-sap-pi-70-possile

REGARDS

DHEERAJ KUMAR

[Former Member]

Hi Dheeraj,

As we know there is almost no difference between XI 3.0 & PI 7.0.... you can use the same JDK Version

i.e JDK 1.4.2_xxx...JDK 5 basically for PI 7.1....

Regds,

Pinangshuk.

[marksmyth]

Hi Dheeraj

JDK version 1.4 is the supported version with PI 7.0. As per note #723909 Java VM settings for J2EE 6.30/6.40/7.0 -

o 1. Java version

It should be the most actual one from the 1.4 family. J2EE Engine

6.40/7.0 is not supported on 1.3 or 1.5 Java plattform.

Regards

Mark

[former_member185881]

Hi

If i will update my PI 7.0 with EHP1 then JDK will be supported or not??????????

I want to connect SQL Server 2008 with PI 7.0 how can i do it???????

Regards

Dheeraj kumar

Edited by: Dheeraj Kumar on Mar 10, 2010 10:10 AM

[rajasekhar_reddy14]

Hi ,

You mean to say PI 7.0 not supporting SQL Server 2008,i dont think so.

When you upgraded your SQL Server,you have to deploy new driver files in PI,then only your scenario will work.download new drivers files and deploy the same.and remove old version SQL server files in PI.

i dont think its JDK issue.

Regards,

Raj

[former_member185881]

Hi Raja

I have already deployed new drivers and after deploying only i am getting error mentioned above.

In microsoft site also it is written for these new drivers for SAL SERVER 2008 you should have JDK5.

check out this link

http://www.microsoft.com/downloads/details.aspx?FamilyID=99B21B65-E98F-4A61-B811-19912601FDC9&displa...

what could be the workaround need solution please.

Regards

Dheeraj Kumar

[rajasekhar_reddy14]

Hi,

Have you contacted your BASIS team.may be they will help you.

Regards,

Raj

[Former Member]

can you send me JDK 1.4 for windows x64 because i faced problem to downloading it form java.sun.com