Witam mam problem z działaniem aplikacji RESTowej powiązanej z MySQL. Od razu zaznacze, że dopiero się uczę programować i mogę mieć gdzieś jakiś głupi bład.
Aplikacja ma za zadanie zapisać treść strony którą otrzyma metodą POST. Metoda GET ma pobrać wszystkie zapisane strony z tabeli. Kod się kompiluje i wywołanie testowego endpointu /ja działa, ale gdy chcę użyć POST/GET otrzymuje z serwera status 500-GET, 405-POST. Samo zapisanie i wyciągnięcie z bazy działa z pominięciem reszty programu, więc gdzieś jest jakiś błąd między Hibernatem, a resztą aplikacji.
presistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1"
xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
<persistence-unit name="WebSaver" transaction-type="RESOURCE_LOCAL">
<class>pl.projekt.websaver.models.Website</class>
<properties>
<!-- Configuring The Database Connection Details -->
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
<property name="javax.persistence.jdbc.url"
value="jdbc:mysql://localhost/websaver?useSSL=false&characterEncoding=UTF-8&characterSetResults=UTF-8&clobCharacterEncoding=UTF-8"/>
<property name="javax.persistence.jdbc.user" value="websaver_user"/>
<property name="javax.persistence.jdbc.password" value="websaver!1"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
</properties>
</persistence-unit>
</persistence>
Website
@Entity
@Table(name = "WEBSAVER")
public class Website {
@Id
@Column(name = "ID")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@NotNull
@Column(name = "URL")
private String url;
@Column(name = "SITE")
@Lob
private String websiteContent;
public Website() {
}
public Website(String url, String websiteContent) {
this.url = url;
this.websiteContent = websiteContent;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public String getWebsiteContent() {
return websiteContent;
}
public void setWebsiteContent(String websiteContent) {
this.websiteContent = websiteContent;
}
@Override
public String toString() {
return "Website{" +
"id=" + id +
", url='" + url + '\'' +
", websiteContent='" + websiteContent + '\'' +
'}';
}
}
WebsiteDAO
@ApplicationScoped
public class WebsiteDao {
@PersistenceUnit(name = "WebSaver")
private EntityManager em;
public Website createWebsite(String url, String websiteContent) {
try {
em.getTransaction().begin();
Website website = new Website(url, websiteContent);
em.persist(website);
em.getTransaction().commit();
return website;
} catch (Exception e) {
em.getTransaction().rollback();
e.printStackTrace();
} finally {
em.close();
}
return null;
}
public List<Website> getAll() {
try {
em.getTransaction().begin();
List<Website> urlAll = em.createQuery("select w from Website w" , Website.class).getResultList();
em.getTransaction().commit();
return urlAll;
} catch (Exception e) {
em.getTransaction().rollback();
e.printStackTrace();
} finally {
em.close();
}
return null;
}
public Website getById(int id) {
try {
em.getTransaction().begin();
Website website = em.find(Website.class, id);
em.getTransaction().commit();
return website;
} catch (Exception e) {
em.getTransaction().rollback();
e.printStackTrace();
} finally {
em.close();
}
return null;
}
}
Webservice
@Path("/web")
@Produces(MediaType.APPLICATION_JSON)
@Consumes(MediaType.APPLICATION_JSON)
public class ApplicationWebservice {
@Inject
@SuppressWarnings("unused")
private WebsiteDao dao;
@GET
@Path("/ja")
public Response hej() {
return Response.ok("Cześc i czołem").build();
}
@GET
public Response listWebsites() {
return Response.ok(dao.getAll()).build();
}
@GET
@Path("{id}")
public Response getWebsiteById(@PathParam("id") @Min(0) Integer id) {
Website website = dao.getById(id);
if (website != null) {
return Response.ok(website).build();
}
return Response.status(Response.Status.NOT_FOUND).build();
}
@POST
@Path("{url}")
public Response addWebsite(@PathParam("url") String url) throws IOException {
String webContent;
Connection connect = Jsoup.connect(url);
Document document = connect.get();
webContent = document.html();
Website newWeb = dao.createWebsite(url, webContent);
return Response.ok(newWeb).build();
}
}
Aplikacja
@ApplicationPath("/websaver")
public class WebsaverApplication extends Application {
}
Error z serwera
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268)
at org.glassfish.jersey.internal.Errors.process(Errors.java:316)
at org.glassfish.jersey.internal.Errors.process(Errors.java:298)
at org.glassfish.jersey.internal.Errors.process(Errors.java:268)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:289)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:256)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:703)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:416)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:370)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:389)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:342)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:229)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1622)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:258)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:654)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:593)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:159)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:371)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:238)
at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:516)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:213)
at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:242)
at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:284)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:201)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:133)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:112)
at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:539)
at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:593)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:573)
at java.lang.Thread.run(Thread.java:748)
]]
Hibernate 
