Discussion :

[Mr.fidel]

Bonjour,

je cherche à faire une connexion entre java et SSAS en passant par XMLA

voici mon code :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
import org.olap4j.*;
 
 
import java.io.FileNotFoundException; 
 
import java.sql.*;
//import org.olap4j.mdx.*;
 
public class ConnexionOlap {
 
 
	public static void main(String []args)throws SQLException,FileNotFoundException
	{ 
 
		System.out.println("Test avant");
		try
		{
			System.out.println("Test dedans");
 
			Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
 
			OlapConnection con = (OlapConnection)DriverManager.getConnection("jdbc:xmla:Server=http://localhost/xmla/msxisapi.dll;Catalog=AnalysisWindows");
 
 
			OlapWrapper wrapper = (OlapWrapper) con;
			OlapConnection olapConnection = wrapper.unwrap(OlapConnection.class);
			OlapStatement stmt = olapConnection.createStatement();
 
			System.out.println("Test avant requete");
 
 
			CellSet cellSet = stmt.executeOlapQuery("select {[Measures].[Etudiant Nombre]} on columns from [DatatestWindows]");
 
 
			System.out.println("Test après requête");
		}
		catch(Exception ex){ 
			//System.out.println("ERREUR"); 
			System.err.println("Erreur pendant la connexion"); 
			ex.printStackTrace();
 
 
		}
		System.out.println("Test Fin");
	}
}

voici le resutat :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
Test avant
Test dedans
Test avant requete
Erreur pendant la connexion
java.lang.RuntimeException: org.olap4j.OlapException: This connection encountered an exception while executing a query.
	at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(DeferredNamedListImpl.java:76)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.get(DeferredNamedListImpl.java:94)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.get(DeferredNamedListImpl.java:43)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.getCatalog(XmlaOlap4jConnection.java:377)
	at org.olap4j.driver.xmla.XmlaOlap4jStatement.executeOlapQuery(XmlaOlap4jStatement.java:257)
	at comAutres.ConnexionOlap.main(ConnexionOlap.java:35)
Caused by: org.olap4j.OlapException: This connection encountered an exception while executing a query.
	at org.olap4j.OlapExceptionHelper.createException(OlapExceptionHelper.java:29)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:610)
	at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getMetadata(XmlaOlap4jDatabaseMetaData.java:127)
	at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getDatasources(XmlaOlap4jDatabaseMetaData.java:932)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.getDataSourceInfo(XmlaOlap4jConnection.java:252)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.generateRequest(XmlaOlap4jConnection.java:749)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList(XmlaOlap4jConnection.java:585)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.populateList(DeferredNamedListImpl.java:102)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(DeferredNamedListImpl.java:71)
	... 5 more
Caused by: org.olap4j.driver.xmla.proxy.XmlaOlap4jProxyException: This proxy encountered an exception while processing the query.
	at org.olap4j.driver.xmla.proxy.XmlaOlap4jHttpProxy.getResponse(XmlaOlap4jHttpProxy.java:94)
	at org.olap4j.driver.xmla.proxy.XmlaOlap4jAbstractHttpProxy.get(XmlaOlap4jAbstractHttpProxy.java:165)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:599)
	... 12 more
Caused by: java.io.IOException: Server returned HTTP response code: 500 for URL: http://localhost/xmla/msxisapi.dll
	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at org.olap4j.driver.xmla.proxy.XmlaOlap4jHttpProxy.getResponse(XmlaOlap4jHttpProxy.java:78)
	... 14 more
Test Fin

Pouvez vous m'aider svp.

[FrancoisJehl]

http://localhost/xmla/msxisapi.dll

Tu es en 2000? Tu as testé la data pump en dehors d'Olap4j?

[Mr.fidel]

Je suis en SSAS 2008, IIS6 avec JDK1.6 et Eclipse europa sous Win XP :

voici mon code après modification :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
package comAutres;
 
import org.olap4j.*;
 
 
import java.io.FileNotFoundException; 
 
import java.sql.*;
//import org.olap4j.mdx.*;
 
public class ConnexionOlap {
 
 
	public static void main(String []args)throws SQLException,FileNotFoundException
	{ 
 
		System.out.println("Test avant");
		try
		{
 
 
			Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
 
			OlapConnection		
 
			con = (OlapConnection)DriverManager.getConnection("jdbc:xmla:Server=http://localhost/olap/msmdpump.dll;Catalog=datatest;Provider=SQLNCLI10.1;");
 
			OlapWrapper wrapper = (OlapWrapper) con;
 
			OlapConnection olapConnection = wrapper.unwrap(OlapConnection.class);
 
			OlapStatement stmt = olapConnection.createStatement();
 
 
 
			/*System.out.println(con.getCatalogs() );*/
 
 
 
			CellSet cellSet = stmt.executeOlapQuery("select {[Measures].[Etudiant Nombre]} on columns from [DatatestWindows]");
 
 
 
 
 
 
 
 
 
 
 
 
		}
		catch(Exception ex){ 
 
			System.err.println("Erreur pendant la connexion"); 
			ex.printStackTrace();
 
 
		}
 
	}
}

et voilà mon rapport d'erreur:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
Erreur pendant la connexion
java.lang.RuntimeException: org.olap4j.OlapException: This connection encountered an exception while executing a query.
	at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(DeferredNamedListImpl.java:76)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.get(DeferredNamedListImpl.java:94)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.get(DeferredNamedListImpl.java:43)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.getCatalog(XmlaOlap4jConnection.java:377)
	at org.olap4j.driver.xmla.XmlaOlap4jStatement.executeOlapQuery(XmlaOlap4jStatement.java:257)
	at comAutres.ConnexionOlap.main(ConnexionOlap.java:42)
Caused by: org.olap4j.OlapException: This connection encountered an exception while executing a query.
	at org.olap4j.OlapExceptionHelper.createException(OlapExceptionHelper.java:29)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:610)
	at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getMetadata(XmlaOlap4jDatabaseMetaData.java:127)
	at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getDatasources(XmlaOlap4jDatabaseMetaData.java:932)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.getDataSourceInfo(XmlaOlap4jConnection.java:252)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.generateRequest(XmlaOlap4jConnection.java:749)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList(XmlaOlap4jConnection.java:585)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.populateList(DeferredNamedListImpl.java:102)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(DeferredNamedListImpl.java:71)
	... 5 more
Caused by: org.olap4j.driver.xmla.proxy.XmlaOlap4jProxyException: This proxy encountered an exception while processing the query.
	at org.olap4j.driver.xmla.proxy.XmlaOlap4jHttpProxy.getResponse(XmlaOlap4jHttpProxy.java:94)
	at org.olap4j.driver.xmla.proxy.XmlaOlap4jAbstractHttpProxy.get(XmlaOlap4jAbstractHttpProxy.java:165)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:599)
	... 12 more
Caused by: java.io.IOException: Server returned HTTP response code: 405 for URL: http://localhost/olap/msmdpump.dll
	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at org.olap4j.driver.xmla.proxy.XmlaOlap4jHttpProxy.getResponse(XmlaOlap4jHttpProxy.java:78)
	... 14 more