SAP JAVA JDBC connection with SQL Server no sapbiado in java.library.path

[Former Member]

Hello Everyone,

I am trying to setup the JDBC connection with SQL Server 2014 and 2000 using JDBC.

My current setup is:

SAP Netweaver JAVA 7.50 Based on HANA

SLES 12 SP02

I have tried with the following: SQL Server JDBC drivers from Microsoft and SAP and almost all of them are giving me the same error (described below).

I have followed the below guide to setup:

https://blogs.sap.com/2009/09/01/looking-for-jdbc-drivers-for-sql-server/ https://blogs.sap.com/2009/09/01/looking-for-jdbc-drivers-for-sql-server/

Mainly these one: https://wiki.scn.sap.com/wiki/display/BI/Configure+UD+Connect+in+NWA+for+7.3 https://blogs.sap.com/2014/11/11/ud-connection-integrating-an-external-db-on-bw-abap-73-via-bw-java-... https://wiki.scn.sap.com/wiki/display/SAPSQL/Remote+MS+SQL+Server+database+connections

Error I am getting is:

Cannot process an HTTP request to servlet [Control 1] in [TestJDBC_Web] web application. [EXCEPTION] java.lang.UnsatisfiedLinkError: no sapbiado in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1971) at java.lang.Runtime.loadLibrary0(Runtime.java:870) at java.lang.System.loadLibrary(System.java:1128)

Detailed Error:

Cannot process an HTTP request to servlet [Control 1] in [TestJDBC_Web] web application.
[EXCEPTION]
java.lang.UnsatisfiedLinkError: no sapbiado in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1971)
at java.lang.Runtime.loadLibrary0(Runtime.java:870)
at java.lang.System.loadLibrary(System.java:1128)
at com.sap.ip.bi.sdk.dac.connector.odbo.impl.Connection.<clinit>(Connection.java:122)
at com.sap.ip.bi.sdk.dac.connector.odbo.OdboManagedConnection.<init>(OdboManagedConnection.java:144)
at com.sap.ip.bi.sdk.dac.connector.odbo.OdboManagedConnectionFactory.createManagedConnection(OdboManagedConnectionFactory.java:90)
at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:401)
at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:295)
at com.sap.engine.services.connector.jca.ShareableConnectionManager.allocateConnection(ShareableConnectionManager.java:54)
at com.sap.ip.bi.sdk.dac.connector.odbo.OdboConnectionFactory.getConnectionEx(OdboConnectionFactory.java:148)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getConnection(JDBCModel.java:797)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getSystems(JDBCModel.java:76)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller.Control1.doGet(Control1.java:31)
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)

I dont know what I am missing. I tried ODBC setup using Microsoft ODBC client (SLES 12 SP02) before, but it was not working aswell.

Thanks

---- More Details ----

JRE Version tried in the system:

jre-8u171-linux-x64.rpm

before above, it was default OS java which is java-1_8_0-ibm - IBM Java(TM) Version 8 Runtime Environment

Checked with the following:

From SAP:

MSJDBC30SP70P_10-10012150

MSJDBC30SP50P_10-10012150

MSJDBC20SP00P0HF_1803-10012149

From Microsoft:

mssql-jdbc-6.4.0.jre7.jar

mssql-jdbc-6.4.0.jre8.jar mssql-jdbc-6.4.0.jre9.jar > received some compiler newer version error, hence tried with 8 and 7 (same issue)

Should I try by installing the below package available in yast?

This package contains the JDBC/ODBC bridge driver for java-1_7_1-ibm

Current JAVA installed in the OS is:

java -version

java version "1.8.0" Java(TM) SE Runtime Environment (build pxa6480sr4fp5-20170421_01(SR4 FP5)) IBM J9 VM (build 2.8, JRE 1.8.0 Linux amd64-64 Compressed References 20170419_344392 (JIT enabled, AOT enabled) J9VM - R28_20170419_1004_B344392 JIT - tr.r14.java_20170419_344392 GC - R28_20170419_1004_B344392_CMPRSS J9CL - 20170419_344392) JCL - 20170420_01 based on Oracle jdk8u131-b11

[oppancs]

Dear Zaman,

This error usually appears if there is compatibility inconsistency between JDK and JDBC Dirver.

AS you mentioned many versions of JVM and JDBC, please double check which JDBC driver should be used depending on your database as per SAP note:

1398807 - Microsoft SQL Server: JDBC driver support matrix

See "Microsoft JDBC driver versions for JDK" part.

Regards,
Barnabás Paksi