SQL JDBC driver deployed on SAP PI 7.0

[Former Member]

Hi,

I wanted to know the version of sql jdbc driver deployed on SAP PI 7.0.

Is there any where on VA can we check this?

Also, note 1085539 was implemented to get this details but getting error as below

Exception Occurred : com.microsoft.jdbc.base.BaseDatabaseMetaData.getJDBCMajorVersion()I

-

---

Exception Stack Trace : java.lang.AbstractMethodError: com.microsoft.jdbc.base.BaseDatabaseMetaData.getJDBCMajorVersion()I

at com.sap.util.TestJDBCUtil.testDriverManagerConnect(TestJDBCUtil.java:62)

at com.sap.tests.TestJDBCConnectionServlet.processRequest(TestJDBCConnectionServlet.java:41)

at com.sap.tests.TestJDBCConnectionServlet.doPost(TestJDBCConnectionServlet.java:74)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

-

---

Details entered were:

Class: com.microsoft.jdbc.sqlserver.SQLServerDriver

JDBC URL: jdbc:microsoft:sqlserver://aaaaaa:xxxx;DatabaseName=uat_stage

Username:

Password:

which is same as it was in CC which is working fine.

regards anirudh.

[Former Member]

try like this in CC

JDBC driver ---com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection - jdbc:sqlserver://aaaaa:xxxx;DatabaseName=abcd

[Former Member]

hI.

Wich version SQL Server do you Use? Sql 2008.. or Sql 2005.. The first only works with PI 7.1 the other version works with PI 7.0 because JDK 1.4 is not compatible.

[Former Member]

Hi Vyas,

Can you please check the path mentioned in this thread:

Regards,

---Satish

[Former Member]

Hi,

It depends on what version of JRE are you using in your PI server.

See the following link:

[|]

Regards

Ivan