Skip to Content
0
Jun 10, 2018 at 06:02 PM

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

608 Views Last edit Jun 14, 2018 at 04:35 PM 4 rev

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-73/ 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