How to Deploy the JDBC Drivers in PI7.31 java stack version only - SQL Server 2008 R2

[Former Member]

Hi,

Can you please provide me any guide or SAP OSS note to deploy the JDBC drivers in PI 7.31.

we have only java version. and we are planing to connect SQL Server 2008 R2.

we are not finding following sda file - com.sap.aii.adapter.lib.sda , in th installation process. Is it changed jdbc installation drivers process for PI 7.31

Regards,

Venu.

[Former Member · Accepted solution]

we installed following drivers -

Microsoft SQL Server JDBC Driver 4.0

and our SQL version is - SQL Server 2008 R2,

What is the correct version drivers I would need to consider for SQL Server 2008 R2 ?

but still I am seeing below error in my JDBC receiver  comm channel -

BC message processing failed; reason 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.microsoft.jdbc.sqlserver.SQLServerDriver returns: com.microsoft.jdbc.sqlserver.SQLServerDriver.

: SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

and installed the drivers as per SDN Article - Deploying JDBC drivers in PI 7.1x Systems

Appriciate your help.

Regards,

Venu.

[baskar_gopalakrishnan2 · Accepted solution]

>SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Your JDBC driver installation seems not completed successfully. Thats why you see class not found exception.

>What is the correct version drivers I would need to consider for SQL Server 2008 R2 ?

JDBC Driver 3.0 seems good enough. Please check this link

http://www.microsoft.com/en-us/download/details.aspx?id=21599

[Former Member · Accepted solution]

After I changed driver name like this- com.microsoft.sqlserver.jdbc.SQLServerDriver

and it showed me correct error in channel monitoring. The error is sqljdbc4.jar is not exits.

Then we removed sqljdbc.jar and installed sqljdbc4.jar ,then connection got established.

correct jar is - sqljdbc4.jar to connect MS SQL Server 2008 R2

[Former Member · Accepted solution]

Hi Venu,

I am also facing same JDBC connection issue and I tried the suggestion you have used for your connectivity, i.e sqljdbc4.jar and com.microsoft.sqlserver.jdbc.SQLServerDriver, but it is not working in my case and giving error no suitable driver found for connection string, let me know what extra configuration need to be done.

my connection string.....

JDBC Driver	com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection	jdbc:microsoft:sqlserver://server:port;databaseName=DEV;

[Former Member]

Hi,

Can any one please assist re:jdbc driver installation process

I have win20008r2server with mssql db i.e.731 PI system where I have to install JDBC driver

I have followed the below mentioned process:

1.Microsoft Download Center downloaded the  sqljdbc_3.0_1301.101_enu.exe for Windows.

2. This extracts the files under the directory sqljdbc_3.0 and gives you the sqljdbc.jar & sqljdbc4.jar file     (is sqljdbc4.jar is compatible version for 731 release?) in the sub-directory enu.

3.Added the sqljdbc4.jar file to the lib sub-directory of the sda file com.sap.aii.adapter.lib.sda (Note

  (1138877).

4. I found the above mentioned sda in SAPXI3RDPARTY00_0.sca\DEPLOYARCHIVES

5. Edited the file provider.xml which is in the server sub-directory of the sda file and add an entry for the sqljdbc4.jar file

like mentioned below

<?xml version="1.0"?>

-<provider-descriptor><display-name>XPI Adapter Library</display-name><component-name>com.sap.aii.adapter.lib</component-name><provider-name>sap.com</provider-name>-<references><reference provider-name="sap.com" strength="strong" type="library">engine.j2ee14.facade</reference></references>-<jars><jar-name>lib/com.sap.aii.adapter.lib_api.jar</jar-name>

<jar-name>lib/sqljdbc4.jar</jar-name></jars>

</provider-descriptor>

6. After that I used telnet for force deployment for deploying the com.sap.aii.adapter.lib.sda

   (after updating it with sqljdbc4.jar file and provider.xml).

7. I checked in system information page it is showing sda is updated.

8. And also in the mentioned location D:\usr\sap\SID\DVEBMGS00\j2ee\cluster\bin\ext

    its showing updated.

9.Now when I launched the application it s throwing an error

http://Host Name/AFTest/index.jsp?jvertaskfile=all&count=1&persist=true&mode=run

An internal error occurred: java.lang.NullPointerException: while trying to invoke the method java.net.URL.getProtocol() of a null object loaded from local variable 'jverUrl'

at com.sap.xi.sisyphus.web.jver.Util.getJverTasksets(Util.java:53)

at com.sap.xi.sisyphus.web.jver.JverDispatcher.executeTests(JverDispatcher.java:124)

at com.sap.xi.sisyphus.web.http.JverServlet.doGet(JverServlet.java:69)

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

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

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)

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

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

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

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

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:278)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)

at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)

at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

Could you please help me out how to overcome with the issue or any thing I missed during the deployment please correct me .....?????????

regards,

Akash

[Former Member]

HI Venu gopal,

We have the same situation, want  to install Ms SQL JDBC drivers on PI 7.31 Java only stack.

Could you please tell me how to deploy them?

[Former Member]

Hi,

I have deployed JDBC driver(sqljdbc4.0) according tohttp://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4... .

Driver deployed successfully and I have checked it in folder \usr\sap\xxx\DVEBMGS30\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib and it's found ok. But this adapter type  not showing in Communication Channel only RFC and SOAP are showing there. I have restarted the server also.

Can you tell me where the problem is?

[jorge_velasquez]

Hi,

Did you use SUM?

JSPM is not possible and i can't use command

go "-config=/jspm/forceMode=true" "-config=/jspm/deployVersionRule=updateAll"

On the other hand as I understand if PI 7.4 Do I have to add to SCA this one sqljdbc4.jar ?

Regards

[Former Member]

I have checked the following oss note - Note 1138877 - How to Deploy External Drivers JDBC/JMS Adapters

as per oss note following sda file -com.sap.aii.adapter.lib.sda.

not finding in PI 7.31 installation document(he is able to see- com.sap.aii.adapter.lib).

and our basis team is not able to find provider.xml file.

Can you please help on this.

[baskar_gopalakrishnan2]

I dont see any note for 7.31 yet. You might want to check MIchal's blog http://scn.sap.com/people/michal.krawczyk2/blog/2011/12/14/michals-pi-tips-jdbcjms-driver-deployment...

Also please rate this blog if you find it useful.

[Former Member]

I gone through this link with our basis team and this link did not help him. because we are not finding in PI 7.31 following sda file - com.sap.aii.adapter.lib.sda file from the server.

we download the relevant drivers but after that how to deploy those in PI 7.31.