Bonjour
J'ai un code en java qui récupère les informations d'une base de données (sous sql server 2005),ensuite crée un fichier xml et y insère les données.
Le problème est que lorsque j'exécute ma classe java (sous netbeans),j'ai le message d'erreur suivant:

run:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><Execute xmlns="urn:schemas-microsoft-comml-analysis"><Command><Statement>select {[Customer].[Gender Ctmer].[Gender Ctmer]} on columns,{[Measures].[Qty Sold]} on rows from Cube_CaseStudy1</Statement></Command><Properties><PropertyList><DataSourceInfo>saching-dnd-kkj;</DataSourceInfo><Catalog>dbCaseStudy1</Catalog><Format>Multidimensional</Format><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content></PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-ENV:Envelope>May 20, 2011 11:58:33 PM com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:146)
at olap.XMLAClient.main(XMLAClient.java:91)
Caused by: java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:140)
... 1 more
Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:344)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection$PriviledgedPost.run(HttpSOAPConnection.java:169)
... 3 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at sun.net.NetworkClient.doConnect(NetworkClient.java:163)
at sun.net.http://www.http.HttpClient.openServe...lient.java:394)
at sun.net.http://www.http.HttpClient.openServe...lient.java:529)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:233)
at sun.net.www.http.HttpClient.New(HttpClient.java:306)
at sun.net.www.http.HttpClient.New(HttpClient.java:323)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:837)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:778)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:703)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:881)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:301)
... 4 more

CAUSE:

java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:140)
at olap.XMLAClient.main(XMLAClient.java:91)
Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:344)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection$PriviledgedPost.run(HttpSOAPConnection.java:169)
... 3 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at sun.net.NetworkClient.doConnect(NetworkClient.java:163)
at sun.net.http://www.http.HttpClient.openServe...lient.java:394)
at sun.net.http://www.http.HttpClient.openServe...lient.java:529)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:233)
at sun.net.www.http.HttpClient.New(HttpClient.java:306)
at sun.net.www.http.HttpClient.New(HttpClient.java:323)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:837)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:778)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:703)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:881)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:301)
... 4 more

CAUSE:

java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:140)
at olap.XMLAClient.main(XMLAClient.java:91)
Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:344)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection$PriviledgedPost.run(HttpSOAPConnection.java:169)
... 3 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at sun.net.NetworkClient.doConnect(NetworkClient.java:163)
at sun.net.http://www.http.HttpClient.openServe...lient.java:394)
at sun.net.http://www.http.HttpClient.openServe...lient.java:529)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:233)
at sun.net.www.http.HttpClient.New(HttpClient.java:306)
at sun.net.www.http.HttpClient.New(HttpClient.java:323)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:837)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:778)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:703)
at sun.net.http://www.protocol.http.HttpURLConn...ction.java:881)
at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:301)
... 4 more
BUILD SUCCESSFUL (total time: 4 seconds)
Et voici ma classe java:

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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
 
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
 
 
 
package olap;
 
import javax.xml.soap.*;
import java.net.URL;
import java.io.*;
/**
 *
 * @author XO
 */
public class XMLAClient
{
 
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args)
    {
        FileOutputStream out;
        try
        {
         SOAPConnectionFactory soapConnectionFactory = SOAPConnectionFactory.newInstance();
 
         SOAPConnection soapConnection = soapConnectionFactory.createConnection();
         SOAPFactory soapFactory = SOAPFactory.newInstance();
 
         MessageFactory messageFactory = MessageFactory.newInstance();
 
         SOAPMessage message = messageFactory.createMessage();
         message.getMimeHeaders().addHeader("SOAPAction", "\"urn:schemas-microsoft-com:xml-analysis:Execute\"");
 
         SOAPHeader soapHeader = message.getSOAPHeader();
 
         SOAPBody soapBody = message.getSOAPBody();
 
         Name bodyName = soapFactory.createName("Execute", "", "urn:schemas-microsoft-com:xml-analysis");
 
         SOAPBodyElement bodyElement = soapBody.addBodyElement(bodyName);
 
         Name commandName = soapFactory.createName("Command");
 
         SOAPElement aucIDElement = bodyElement.addChildElement(commandName);
 
         Name statementName = soapFactory.createName("Statement");
 
         SOAPElement stateElement = aucIDElement.addChildElement(statementName);
 
         stateElement.addTextNode("select {[Customer].[Gender Ctmer].[Gender Ctmer]}  on columns,"+"{[Measures].[Qty Sold]} on rows from Cube_CaseStudy1");
 
         Name propertiesElementName = soapFactory.createName("Properties");
 
         SOAPElement propertiesElement = bodyElement.addChildElement(propertiesElementName);
 
         Name propertiesListName = soapFactory.createName("PropertyList");
 
         SOAPElement propertyListElement = propertiesElement.addChildElement(propertiesListName);
 
         Name dataSourceInfoName = soapFactory.createName("DataSourceInfo");
         SOAPElement dataSourceInfoElement = propertyListElement.addChildElement(dataSourceInfoName);
 
         dataSourceInfoElement.addTextNode("saching-dnd-kkj;");
 
         Name catalogName2 = soapFactory.createName("Catalog");
         SOAPElement catalogElement = propertyListElement.addChildElement(catalogName2);
 
         catalogElement.addTextNode("dbCaseStudy1");
 
         Name formatName = soapFactory.createName("Format");
 
         SOAPElement formatElement = propertyListElement.addChildElement(formatName);
         formatElement.addTextNode("Multidimensional");
 
         Name axisFormatName = soapFactory.createName("AxisFormat");
         SOAPElement axisFormatElement = propertyListElement.addChildElement(axisFormatName);
         axisFormatElement.addTextNode("TupleFormat");
 
         Name contentName = soapFactory.createName("Content");
         SOAPElement contentElement = propertyListElement.addChildElement(contentName);
         contentElement.addTextNode("Data");
 
         URL endpoint = new URL("http://localhost/xmla/Msxisapi.dll");
         message.saveChanges();
         message.writeTo(System.out);
 
         SOAPMessage  response = soapConnection.call(message, endpoint);
         SOAPBody soapBodyto = response.getSOAPBody();
 
         soapConnection.close();
 
         out = new FileOutputStream("myXMLdoc.xml");
         response.writeTo(out);
        }
 
        catch (Exception ex)
        {
         ex.printStackTrace();
        }
    }
 
}
Merci