Web service ne fonctionne pas

**infoworld2013** · 09/05/2014, 16h01

Je suis entrain de développer un web service avec Axis2, la méthode du web service qui prend en paramètre un int et retourne un int, marche normalement sous forme d'application java, or quand je veux créer un web service à partir de cette classe ca me donne ClassNotFoundException: com.mysql.jdbc.Driver sachant que le driver JDBC est déjà inclu parmis les librairies.

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
 
package com.test;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
 
 
 
 
import com.utils.Connexion;
 
 
public class Price 
{
 
	public int getBook(int ISBN) 
	{
		int price = 0;
		ResultSet res = null;
		try {
			Statement st = Connexion.getConnection1().createStatement();
			String req = "select * from book where ISBN = + ISBN";
			 res = st.executeQuery(req);
		    if (res.next()) {
		     price = res.getInt(3);
		     System.out.println(price);
		    }
		    res.close();
		} 
		catch (Exception e) 
		{
			System.out.println("Error in fetching data" + e);
		}
		return price;
 
	}
 
}

Voici la classe de connexion:

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
 
package com.utils;
 
import java.sql.Connection;
import java.sql.DriverManager;
 
public class Connexion {
 
 
	public Connexion() {
		super();
		// TODO Auto-generated constructor stub
	}
 
	public  static Connection getConnection1() 
	{
		Connection con = null;
		try 
		{
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager
					.getConnection("jdbc:mysql://localhost:3306/ws","root","");
		} 
		catch (Exception e) 
		{
			System.out.println("Error in connection" + e);
		}
		return con;
	}
 
}

voici les erreurs de la console :

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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
 
mai 09, 2014 2:53:53 PM org.apache.catalina.core.AprLifecycleListener init
Infos: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jre7\bin;D:\Documents\StagePFE\JEE6_outils\eclipse;;.
mai 09, 2014 2:53:53 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
Avertissement: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:MyFirstWebService' did not find a matching property.
mai 09, 2014 2:53:53 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
Avertissement: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:TestAxis2' did not find a matching property.
mai 09, 2014 2:53:53 PM org.apache.coyote.AbstractProtocol init
Infos: Initializing ProtocolHandler ["http-bio-8080"]
mai 09, 2014 2:53:53 PM org.apache.coyote.AbstractProtocol init
Infos: Initializing ProtocolHandler ["ajp-bio-8009"]
mai 09, 2014 2:53:53 PM org.apache.catalina.startup.Catalina load
Infos: Initialization processed in 802 ms
mai 09, 2014 2:53:53 PM org.apache.catalina.core.StandardService startInternal
Infos: Démarrage du service Catalina
mai 09, 2014 2:53:53 PM org.apache.catalina.core.StandardEngine startInternal
Infos: Starting Servlet Engine: Apache Tomcat/7.0.47
[ERROR] Unable to find config file.  Creating new servlet engine config file: /WEB-INF/server-config.wsdd
[WARN] Web application uses org.apache.axis2.transport.http.AxisAdminServlet; please update web.xml to use org.apache.axis2.webapp.AxisAdminServlet instead
[INFO] Clustering has been disabled
[INFO] Deploying module: addressing-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/addressing-1.6.2.mar
[INFO] Deploying module: jaxws-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/axis2-jaxws-mar-1.6.2.mar
[INFO] Deploying module: metadataExchange-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/mex-1.6.2.mar
[INFO] Deploying module: mtompolicy-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/mtompolicy-1.6.2.mar
[INFO] Deploying module: ping-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/ping-1.6.2.mar
[INFO] Deploying module: script-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/scripting-1.6.2.mar
[INFO] Deploying module: soapmonitor-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/modules/soapmonitor-1.6.2.mar
[INFO] Deploying Web service: FirstWebService - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/services/FirstWebService/
[INFO] Deploying Web service: Price - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/services/Price/
[INFO] Deploying Web service: version-1.6.2.aar - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MyFirstWebService/WEB-INF/services/version-1.6.2.aar
[WARN] Web application uses org.apache.axis2.transport.http.AxisAdminServlet; please update web.xml to use org.apache.axis2.webapp.AxisAdminServlet instead
[INFO] Clustering has been disabled
[INFO] Deploying module: addressing-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/addressing-1.6.2.mar
[INFO] Deploying module: jaxws-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/axis2-jaxws-mar-1.6.2.mar
[INFO] Deploying module: metadataExchange-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/mex-1.6.2.mar
[INFO] Deploying module: mtompolicy-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/mtompolicy-1.6.2.mar
[INFO] Deploying module: ping-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/ping-1.6.2.mar
[INFO] Deploying module: script-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/scripting-1.6.2.mar
[INFO] Deploying module: soapmonitor-1.6.2 - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/modules/soapmonitor-1.6.2.mar
org.apache.axis2.deployment.DeploymentException: The following error occurred during schema generation: null
	at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:432)
	at org.apache.axis2.deployment.repository.util.ArchiveReader.buildServiceGroup(ArchiveReader.java:101)
	at org.apache.axis2.deployment.repository.util.ArchiveReader.processServiceGroup(ArchiveReader.java:178)
	at org.apache.axis2.deployment.ServiceDeployer.deploy(ServiceDeployer.java:82)
	at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
	at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:813)
	at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
	at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:377)
	at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254)
	at org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:142)
	at org.apache.axis2.deployment.WarBasedAxisConfigurator.loadServices(WarBasedAxisConfigurator.java:283)
	at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:95)
	at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:584)
	at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:454)
	at org.apache.axis2.webapp.AxisAdminServlet.init(AxisAdminServlet.java:60)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.axis2.deployment.DeploymentException: The following error occurred during schema generation: null
	at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:396)
	... 26 more
Caused by: java.lang.NullPointerException
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:606)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaforFieldsandProperties(DefaultSchemaGenerator.java:732)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:623)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaforFieldsandProperties(DefaultSchemaGenerator.java:732)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:623)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaforFieldsandProperties(DefaultSchemaGenerator.java:732)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:623)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaTypeforNameCommon(DefaultSchemaGenerator.java:1092)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaForType(DefaultSchemaGenerator.java:996)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.processMethods(DefaultSchemaGenerator.java:413)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:273)
	at org.apache.axis2.deployment.util.Utils.fillAxisService(Utils.java:468)
	at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:388)
	... 26 more
[ERROR] The GetPrice service, which is not valid, caused The following error occurred during schema generation: null
org.apache.axis2.deployment.DeploymentException: The following error occurred during schema generation: null
	at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:432)
	at org.apache.axis2.deployment.repository.util.ArchiveReader.buildServiceGroup(ArchiveReader.java:101)
	at org.apache.axis2.deployment.repository.util.ArchiveReader.processServiceGroup(ArchiveReader.java:178)
	at org.apache.axis2.deployment.ServiceDeployer.deploy(ServiceDeployer.java:82)
	at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
	at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:813)
	at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
	at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:377)
	at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254)
	at org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:142)
	at org.apache.axis2.deployment.WarBasedAxisConfigurator.loadServices(WarBasedAxisConfigurator.java:283)
	at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:95)
	at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:584)
	at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:454)
	at org.apache.axis2.webapp.AxisAdminServlet.init(AxisAdminServlet.java:60)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.axis2.deployment.DeploymentException: The following error occurred during schema generation: null
	at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:396)
	... 26 more
Caused by: java.lang.NullPointerException
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:606)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaforFieldsandProperties(DefaultSchemaGenerator.java:732)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:623)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaforFieldsandProperties(DefaultSchemaGenerator.java:732)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:623)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaforFieldsandProperties(DefaultSchemaGenerator.java:732)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:623)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaTypeforNameCommon(DefaultSchemaGenerator.java:1092)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchemaForType(DefaultSchemaGenerator.java:996)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.processMethods(DefaultSchemaGenerator.java:413)
	at org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator.generateSchema(DefaultSchemaGenerator.java:273)
	at org.apache.axis2.deployment.util.Utils.fillAxisService(Utils.java:468)
	at org.apache.axis2.deployment.ServiceBuilder.populateService(ServiceBuilder.java:388)
	... 26 more
[INFO] org.apache.axis2.deployment.DeploymentException: The following error occurred during schema generation: null
[INFO] Deploying Web service: Price - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/services/Price/
[INFO] Deploying Web service: version-1.6.2.aar - file:/C:/Users/hp/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/TestAxis2/WEB-INF/services/version-1.6.2.aar
mai 09, 2014 2:54:04 PM org.apache.coyote.AbstractProtocol start
Infos: Starting ProtocolHandler ["http-bio-8080"]
mai 09, 2014 2:54:04 PM org.apache.coyote.AbstractProtocol start
Infos: Starting ProtocolHandler ["ajp-bio-8009"]
mai 09, 2014 2:54:04 PM org.apache.catalina.startup.Catalina start
Infos: Server startup in 10902 ms
Error in connectionjava.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Error in fetching datajava.lang.NullPointerException

et voici une capture de l'erreur que j'obtiens:

**infoworld2013** · 09/05/2014, 17h18

Pas de réponses ?

Web service ne fonctionne pas

Services Web Java

Discussions similaires

Partager

Partager