Discussion :

[siham-gh]

salut

voici le 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
package test;
 
import java.io.FileNotFoundException;
import java.sql.DriverManager;
import java.sql.SQLException;
 
import org.olap4j.CellSet;
import org.olap4j.OlapConnection;
import org.olap4j.OlapStatement;
import org.olap4j.OlapWrapper;
 
 
public class Test {
 
    public static void main(String[] args) throws SQLException,FileNotFoundException{ 
     try{
            Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
            System.out.println("le pilot est chargé");
            OlapConnection connexion=(OlapConnection)DriverManager.getConnection ("jdbc:xmla:Server=http;//localhost/olap/msmdpump.dll;Catalog=Adventure Works DW");     
            OlapWrapper wrapper=(OlapWrapper)connexion;
            OlapConnection olapConnection = wrapper.unwrap(OlapConnection.class);
            OlapStatement stmt = olapConnection.createStatement();
            System.out.println("la connexion à la base est bien determinée");  
            CellSet cellSet =stmt .executeOlapQuery(                                      
                    "SELECT {[Measures].[Unit Sales]} ON COLUMNS,\n"
                    + "  {[Product].Members} ON ROWS\n}" + "FROM [Sales]");          
                  }                                                        
                                  catch(Exception ex){                              
                                System.err.println("Erreur pendant la connexion"); ex.printStackTrace();
 
                            }                                                  
 
                        }                                                  
 
}

et m'affiche l'erreur suivant:

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
le pilot est chargé
Erreur pendant la connexion
org.olap4j.OlapException: Error while creating connection
	at org.olap4j.driver.xmla.XmlaHelper.createException(XmlaHelper.java:35)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.<init>(XmlaOlap4jConnection.java:187)
	at org.olap4j.driver.xmla.FactoryJdbc4Impl$XmlaOlap4jConnectionJdbc4.<init>(FactoryJdbc4Impl.java:394)
	at org.olap4j.driver.xmla.FactoryJdbc4Impl.newConnection(FactoryJdbc4Impl.java:40)
	at org.olap4j.driver.xmla.XmlaOlap4jDriver.connect(XmlaOlap4jDriver.java:180)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at test.Test.main(Test.java:19)
Caused by: java.net.MalformedURLException: no protocol: http
	at java.net.URL.<init>(Unknown Source)
	at java.net.URL.<init>(Unknown Source)
	at java.net.URL.<init>(Unknown Source)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.<init>(XmlaOlap4jConnection.java:185)
	... 6 more

[Marc Polizzi]

Sans doute "http:" au lieu de "http;" dans l'URL du serveur.

[siham-gh]

Ok ,elle marche bien

[siham-gh]

J'ai corrige la connexion mais reste le problème avec le requête

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
le pilot est chargé
la connexion à la base est bien determinée
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xerces/parsers/DOMParser
	at org.olap4j.driver.xmla.XmlaOlap4jUtil.getParser(XmlaOlap4jUtil.java:94)
	at org.olap4j.driver.xmla.XmlaOlap4jUtil.parse(XmlaOlap4jUtil.java:69)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.executeMetadataRequest(XmlaOlap4jConnection.java:692)
	at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getMetadata(XmlaOlap4jDatabaseMetaData.java:131)
	at org.olap4j.driver.xmla.XmlaOlap4jDatabaseMetaData.getDatasources(XmlaOlap4jDatabaseMetaData.java:985)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.getDataSourceInfo(XmlaOlap4jConnection.java:272)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.generateRequest(XmlaOlap4jConnection.java:831)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList(XmlaOlap4jConnection.java:648)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.populateList(DeferredNamedListImpl.java:101)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.getList(DeferredNamedListImpl.java:69)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.get(DeferredNamedListImpl.java:93)
	at org.olap4j.driver.xmla.DeferredNamedListImpl.get(DeferredNamedListImpl.java:37)
	at org.olap4j.driver.xmla.XmlaOlap4jConnection.getCatalog(XmlaOlap4jConnection.java:411)
	at org.olap4j.driver.xmla.XmlaOlap4jStatement.executeOlapQuery(XmlaOlap4jStatement.java:277)
	at test.Test.main(Test.java:26)
Caused by: java.lang.ClassNotFoundException: org.apache.xerces.parsers.DOMParser
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	... 15 more