Discussion :

[soumti84]

Bonjour à tous
j'ai crée un service web sous netbeans qui se connecte à une BD mysql mais je suis pas arrivé à le déployer, glassfish server 3 m'affiche le message suivant

Code :

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

1
2
 
java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException

voila le code su service

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
 
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
 
package me.org;
 
import com.mysql.jdbc.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebService;
import java.util.*;
 
/**
 *
 * @author mahmoud
 */
@WebService()
public class SchoolByCountryWS {
String url="jdbc:mysql://localhost/relation";
String login="root";
String pwd="";
ResultSet rs=null;
Connection cn=null;
Statement st=null;
List<SchoolByCountryOutputRow> outputs=new ArrayList<SchoolByCountryOutputRow>();
    /**
     * Web service operation
     */
    @WebMethod(operationName = "SchoolByCountryWS")
    public List<SchoolByCountryOutputRow> SchoolByCountryWS(@WebParam(name = "Country")
    String Country)   throws ClassNotFoundException, SQLException {
try {
Class.forName("com.mysql.jdbc.Driver");
cn=DriverManager.getConnection(url,login,pwd);
 
st=     (Statement) cn.createStatement();
String sql="SELECT * from school where country='"+Country+"';";
rs=st.executeQuery(sql);
 
        while(rs.next()){
           // if (Dataa.School[i].getCountry().equals(Country)){
               SchoolByCountryOutputRow row= new  SchoolByCountryOutputRow();
              // row.setSSN(SSN);
               row.setCode(rs.getString("code"));
               row.setTuitionFees(rs.getString("tuitionfees"));
               row.setReputation(rs.getString("reputation"));
               row.setAddress(rs.getString("adr"));
               row.setCountry(rs.getString("country"));
                row.setProb(rs.getString("prob"));
               //row.setCountry(Country);
               //int aux=Integer.parseInt(Data.School[i][2]);
               //float val=(aux-5000)/(25000-5000);
              //row.setRanking(String.valueOf(val));
               outputs.add(row);
            }
 
 
 
}
 catch (Exception e) {
        System.out.println("error: " + e.toString());
    }
     return outputs;
    }
 
 
}

Merci d'avance

[soumti84]

le problème de déploiement est résolu mais en testant le service je reçois encore un message d'erreur

Code :

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

1
2
3
 
Exceptions details : null
com.sun.tools.ws.wscompile.AbortException at com.sun.tools.ws.processor.modeler.wsdl.JAXBModelBuilder.bind(JAXBModelBuilder.java:144) at com.sun.tools.ws.processor.modeler.wsdl.WSDLModeler.buildJAXBModel(WSDLModeler.java:2244) at com.sun.tools.ws.processor.modeler.wsdl.WSDLModeler.internalBuildModel(WSDLModeler.java:191) at com.sun.tools.ws.processor.modeler.wsdl.WSDLModeler.buildModel(WSDLModeler.java:137) at com.sun.tools.ws.wscompile.WsimportTool.buildWsdlModel(WsimportTool.java:381) at com.sun.tools.ws.wscompile.WsimportTool.run(WsimportTool.java:198) at com.sun.tools.ws.wscompile.WsimportTool.run(WsimportTool.java:179) at com.sun.tools.ws.util.WSToolsObjectFactoryImpl.wsimport(WSToolsObjectFactoryImpl.java:60) at com.sun.tools.ws.spi.WSToolsObjectFactory.wsimport(WSToolsObjectFactory.java:88) at org.glassfish.webservices.monitoring.WebServiceTesterServlet.wsImport(WebServiceTesterServlet.java:626) at org.glassfish.webservices.monitoring.WebServiceTesterServlet.initializePort(WebServiceTesterServlet.java:522) at org.glassfish.webservices.monitoring.WebServiceTesterServlet.doGet(WebServiceTesterServlet.java:169) at org.glassfish.webservices.monitoring.WebServiceTesterServlet.invoke(WebServiceTesterServlet.java:104) at org.glassfish.webservices.JAXWSServlet.doGet(JAXWSServlet.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at javax.servlet.http.HttpServlet.service(HttpServlet.java:770) at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1542) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:281) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161) at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231) at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195) at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849) at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746) at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045) at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228) at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90) at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79) at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54) at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59) at com.sun.grizzly.ContextTask.run(ContextTask.java:71) at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532) at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513) at java.lang.Thread.run(Thread.java:722)

SVP aidez moi à connaître l'erreur. Merci