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