Connect to OLAP database using jdbc4olap driver

조회 수: 5 (최근 30일)
Abdolkarim Mohammadi
Abdolkarim Mohammadi 2022년 8월 31일
편집: Abdolkarim Mohammadi 2022년 8월 31일

I am trying to connect to an OLAP database. I know that MATLAB cannot connect to multidimensional databases natively, and need JDBC drivers. I followed the instructions here. I have downloaded and properly registered the driver in the javaclasspath. Therefore, when I call the function javaclasspath, the six jar files for the driver are shown correctly at the end of the results.
D:\Program Files\MATLAB\R2022a\java\JDBC\activation-1.0.2.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\commons-codec-1.3.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\jdbc4olap-1.1.4.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\mssql-jdbc-11.2.0.jre18.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\saaj-api-1.3.jar
D:\Program Files\MATLAB\R2022a\java\JDBC\saaj-impl-1.3.jar
Then I open the Database Explorer app using the following function.
databaseExplorer ();
Next, I open the JDBC Data Source Configuration window and enter the details.

After clicking Test, I enter my credentials. But I get the following error messages in the JDBC Database Configuration window and Command window, respectively. I need to know which settings should be changed. Any help is appreciated.

Aug 31, 2022 8:29:57 AM com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
Aug 31, 2022 8:29:57 AM org.jdbc4olap.xmla.XmlaConn discover
INFO: Error in soap call: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
Aug 31, 2022 8:29:57 AM org.jdbc4olap.jdbc.OlapNonRegisteringDriver connect
INFO: Connect error

답변 (0개)

카테고리

Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

제품


릴리스

R2022a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by