Populate a mysql database using POST method of RESTful Web Services

[Jack Rooney]

I am trying to create a restful webservice with Hibernate3/JPA that will be used populate a mysql db. I want to know how the post annotation will look like. I am new to Rest web services. I appreciate all your help and time.

This is my Stock class.

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
 
@Entity
@Table(name = "stock", catalog = "hib", uniqueConstraints = {
		@UniqueConstraint(columnNames = "STOCK_NAME"),
		@UniqueConstraint(columnNames = "STOCK_CODE") })
public class Stock implements java.io.Serializable {

	private static final long serialVersionUID = 1L;
	
	private Integer stockId;
	private String stockCode;
	private String stockName;
 
	public Stock() {
	}
 
	public Stock(String stockCode, String stockName) {
		this.stockCode = stockCode;
		this.stockName = stockName;
	}
 
	@Id
	@GeneratedValue(strategy = IDENTITY)
	@Column(name = "STOCK_ID", unique = true, nullable = false)
	public Integer getStockId() {
		return this.stockId;
	}
 
	public void setStockId(Integer stockId) {
		this.stockId = stockId;
	}
 
	@Column(name = "STOCK_CODE", unique = true, nullable = false, length = 10)
	public String getStockCode() {
		return this.stockCode;
	}
 
	public void setStockCode(String stockCode) {
		this.stockCode = stockCode;
	}
 
	@Column(name = "STOCK_NAME", unique = true, nullable = false, length = 20)
	public String getStockName() {
		return this.stockName;
	}
 
	public void setStockName(String stockName) {
		this.stockName = stockName;
	}
 
}

This is my HibernateUtil class .

    import org.hibernate.SessionFactory;
    import org.hibernate.cfg.AnnotationConfiguration;
    
    public class HibernateUtil {
    	private static final SessionFactory sessionFactory = buildSessionFactory();
    	
    	private static SessionFactory buildSessionFactory() {
    		try {
    			// Create the SessionFactory from hibernate.cfg.xml
    			return new AnnotationConfiguration().configure().buildSessionFactory();
    
    		} catch (Throwable ex) {
    			// Make sure you log the exception, as it might be swallowed
    			System.err.println("Initial SessionFactory creation failed." + ex);
    			throw new ExceptionInInitializerError(ex);
    		}
    	}
    
    	public static SessionFactory getSessionFactory() {
    		return sessionFactory;
    	}
    
    	public static void shutdown() {
    		// Close caches and connection pools
    		getSessionFactory().close();
    	}
    }

This is my hibernate.cfg.xml file.

    <?xml version="1.0" encoding="utf-8"?>
    <!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
        <session-factory>
            <property name="hibernate.bytecode.use_reflection_
             optimizer">false</property>
            <property name="hibernate.connection.driver_class">
             com.mysql.jdbc.Driver</property>
            <property name="hibernate.connection.url">
             jdbc:mysql://localhost:3306/hib</property>
            <property name="hibernate.connection.username">root</property>
            <property name="hibernate.connection.password">password</property>
            <property name="hibernate.dialect">org.hibernate.dialect.
            MySQLDialect</property>
            <property name="show_sql">true</property>
            <mapping class="com.hib.common.Stock"></mapping>
        </session-factory>
    </hibernate-configuration>

Here is my App class which will have the POST annotation.I know my implementation of the App class is incorrect. But I have been trying to look at a lot of tutorials,but couldnt understand what to do to post to the database.

    import javax.ws.rs.GET;
    import javax.ws.rs.POST;
    import javax.ws.rs.Path;
    
    import javax.ws.rs.Produces;
    import javax.ws.rs.core.MediaType;
    import javax.ws.rs.core.Response;
    
    import org.hibernate.classic.Session;

    import com.hib.persistence.HibernateUtil;

public class App {

	@POST
	@Path("/save")
	@Produces(MediaType.APPLICATION_JSON)
	public void savePersonInDatabase() {
		System.out.println("\n\n\tInside savePersonInDatabase\n");
		Session session = HibernateUtil.getSessionFactory().openSession();
		session.beginTransaction();
		Stock stock = new Stock();
		stock.setStockCode("ORCL");
		stock.setStockName("Oracle");
               	session.save(stock);
		session.getTransaction().commit();
	}
}

Kindly help me out.

Thanks.

[Praful Thakare]

so whats is happening with this code? are you able to hit the webservice but record is not saved? are you getting any error? which framework are you using?
should @Path("/save") be @Path(value ="/save") and [b] @Produces(MediaType.APPLICATION_JSON) be [b] @Produces({ MediaType.APPLICATION_JSON) }) [b] ?
how have you defined your rest handler in web.xml? what is the url used to invoke this service?

[Jack Rooney]

Hello Praful,

Thanks for responding. In my code, I dont know if the POST annotation that I have written is correct or not. My URI is this : http://localhost:8080/HibernateApp/rest/save. When i run this on the localhost:8080, it gives me an error saying that "The specified HTTP method is not allowed for the requested resource." I am developing this using Hibernate3/JPA. Here is my web.xml .

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
                      http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
  version="3.0"
  metadata-complete="true">
	<display-name>HibernateApp</display-name>
	<servlet>
		<servlet-name>Jersey REST Service</servlet-name>
		<servlet-class>com.sun.jersey.spi.container.servlet.
                 ServletContainer</servlet-class>
		<init-param>
			<param-name>com.sun.jersey.config.property.packages</param-name>
			<param-value>com.hib.resource</param-value>
		</init-param>
		<init-param>
			<param-name>com.sun.jersey.api.json.POJOMappingFeature</param-name>
			<param-value>true</param-value>
		</init-param>
		<init-param>
			<param-name>org.codehaus.jackson.jaxrs</param-name>
			<param-value>com.hib.resource</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>Jersey REST Service</servlet-name>
		<url-pattern>/rest/*</url-pattern>
	</servlet-mapping>
</web-app>

Thanks for you time.
Regards,
Achal

[Praful Thakare]

okay can you send complete error line? I suspect it says something like

The specified HTTP method is not allowed for the requested resource for content type application/xml, application/bla bla bla

also try to invoke the rest call with setting header value of Content-Type to application/json or application/xml

I think your configuration is correct since you are not getting 404 which mean url is mapped to service but its just problem with mapping correct method.

how are you invoking the serivce? just pasting url in browser? to add headers I would suggest use RestClient a add-on for firefox.

let me know how it goes.

-P

[Jack Rooney]

Hi Praful,

Here is the complete error :

HTTP Status 405 - Method Not Allowed

type Status report

message Method Not Allowed

description The specified HTTP method is not allowed for the requested resource.

I dont understand what you mean by the content type. Kindly let me know.

Thanks,
Regards,
Jack

[Praful Thakare]

http://localhost:8080/HibernateApp/rest/save. When i run this on the localhost:8080

do you mean you simply paste the above url in browser? if so then it will request for get method you have to mention that you want to invoke post.

again, try firefox restclient where you can select method before sending the request.