Java Jersey RESTful 服务，错误 500
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19686602/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Jersey RESTful Service, Error 500
提问by Dimi
I am new to Restful web services. I want to access the Server via a Jersey Client. But I am getting a 500 error. What i am trying to do is submit an table name through the client end and retrieve the table contents as a JSON. Can anyone please find the error here?
我是 Restful Web 服务的新手。我想通过 Jersey 客户端访问服务器。但是我收到了 500 错误。我想要做的是通过客户端提交一个表名，并以 JSON 形式检索表内容。任何人都可以在这里找到错误吗？
This is my client end
这是我的客户端
public JSONObject loadTable(String tablename) throws ClientProtocolException, IOException {
pathParams.add("tablename", tablename);
JSONObject jsontable = service.path("access").path("loadtable").queryParams(pathParams).get(JSONObject.class);
return jsontable;
}
This is my Server end
这是我的服务器端
@Path("/loadtable")
@GET
@Produces(MediaType.APPLICATION_JSON)
@Consumes(MediaType.TEXT_PLAIN)
public JSONObject loadTable(@QueryParam("tablename") String tablename) throws Exception {
List<Pricing> pricing = new ArrayList<Pricing>();
try {
query = c.prepareStatement("select * from '" + tablename + "'");
ResultSet ets_rs = query.executeQuery();
while (ets_rs.next()) {
pricing.add(new Pricing(ets_rs.getString(1), ets_rs.getString(2), ets_rs.getString(3), ets_rs.getString(4), ets_rs.getString(5), ets_rs.getString(6)));
}
query.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (c != null) {
c.close();
}
}
JSONObject jsonTable = JsonConvert.getJsonFromPricing(pricing);
System.out.println(jsonTable);
return jsonTable;
}
The Pricing class in the Server end converts the Result set to a JSON.
Server 端的 Pricing 类将 Result 集转换为 JSON。
This is the StackTrace:
这是堆栈跟踪：
Exception in thread "AWT-EventQueue-0" com.sun.jersey.api.client.UniformInterfaceException: GET http://localhost:8080/ServerETS/resources/access/loadtable?tablename=prices returned a response status of 500
at com.sun.jersey.api.client.WebResource.handle(WebResource.java:563)
at com.sun.jersey.api.client.WebResource.get(WebResource.java:179)
at Link.ClientLink.loadTable(ClientLink.java:60)
at Interfaces.Pricing.loadTable(Pricing.java:112)
at Interfaces.Pricing.<init>(Pricing.java:32)
at Interfaces.MainMenu.panelPricing(MainMenu.java:1026)
at Interfaces.AdminData.btnAdminDataOKActionPerformed(AdminData.java:150)
at Interfaces.AdminData.accessCaused by: com.sun.jersey.api.MessageException: A message body writer for Java class org.json.simple.JSONObject, and Java type class org.json.simple.JSONObject, and MIME media type application/json was not found
... 33 more
0(AdminData.java:26)
at Interfaces.AdminData.actionPerformed(AdminData.java:70)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6288)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6053)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4651)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
at java.awt.EventQueue.accesspublic String loadTable(String tablename) throws ClientProtocolException, IOException {
pathParams.add("tablename", tablename);
ClientResponse response = service.path("access").path("loadtable").queryParams(pathParams).type(MediaType.APPLICATION_JSON).get(ClientResponse.class);
String responseString = response.getEntity(String.class);
return responseString;
}
0(EventQueue.java:84)
at java.awt.EventQueue.run(EventQueue.java:602)
at java.awt.EventQueue.run(EventQueue.java:600)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext.doIntersectionPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext.doIntersectionPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue.run(EventQueue.java:616)
at java.awt.EventQueue.run(EventQueue.java:614)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
And this is the GlassFish Server Log
这是 GlassFish 服务器日志
@Path("/loadtable")
@GET
@Produces(MediaType.APPLICATION_JSON)
public List<Pricing> loadTable(@QueryParam("tablename") String tablename) throws Exception {
List<Pricing> pricing = new ArrayList<Pricing>();
try {
query = c.prepareStatement("select * from " + tablename);
ResultSet ets_rs = query.executeQuery();
while (ets_rs.next()) {
pricing.add(new Pricing(ets_rs.getString(1), ets_rs.getString(2), ets_rs.getString(3), ets_rs.getString(4), ets_rs.getString(5), ets_rs.getString(6)));
}
query.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (c != null) {
c.close();
}
}
return pricing;
}
采纳答案by Dimi
Changed the Client End as follows
将客户端更改如下
@Produces(MediaType.APPLICATION_JSON)
@Consumes(MediaType.APPLICATION_JSON)
and the server end as follows,
和服务器端如下，
@GET
@Produces(MediaType.APPLICATION_JSON)
public Response loadTable(@QueryParam("tablename") String tablename) throws Exception {
// ...
Pricing pricing = ...
return Response.ok(pricing).build();
}
And Annotated Pricing with JAXB @XmlRootElement... worked like magic! Thanks @LutzHorn for the comments!
并使用 JAXB @XmlRootElement 注释定价......就像魔法一样！感谢@LutzHorn 的评论！
回答by tonga
Since you're trying to send the request data as JSON format, you may modify the MIME type of server consumed data type to JSON type:
由于您尝试将请求数据发送为 JSON 格式，您可以将服务器消费数据类型的 MIME 类型修改为 JSON 类型：
##代码##回答by tonga
Jersey can't serialize your response of a JSONObjectto JSON. Change your method to something like this:
Jersey 无法序列化您对JSONObjectJSON 的响应。将您的方法更改为如下所示：
Annotate Pricingwith JAXB @XmlRootElementand let JAXB do the conversion to JSON.
Pricing使用 JAXB 进行注释@XmlRootElement并让 JAXB 进行到 JSON 的转换。
