twiddle invoke "jboss.system:service=MainDeployer" deploy /some/path/myapp.ear

Note: apon a restart the application will not be deployed as it needs to be in server/xxx/deploy

    <!-- sql to call on an existing pooled connection when it is obtained from pool - the     OracleValidConnectionChecker is prefered-->
    <check-valid-connection-sql>select * from dual;</check-valid-connection-sql>

    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
      <type-mapping>Oracle9i</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

  public int getId() {
    return id;
  }

  public void setId(int id) {
    this.id = id;
  }

  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

  public int getMinutes() {
    return minutes;
  }

  public void setMinutes(int minutes) {
    this.minutes = minutes;
  }

  public float getPrice() {
    return price;
  }

  public void setPrice(float price) {
    this.price = price;
  }

  public String toString() {
    return "#" + id + ": " + name + " (" + minutes + "), " + price;
  }
}

# Place in the video.har\org\jbia\har directory

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
  "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
  "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="org.jbia.har.Video" table="Video">
    <id name="id" type="integer" column="id">
      <generator class="sequence">
        <param name="sequence">video_seq</param>
      </generator>
    </id>
    <property name="name" type="string" column="name"/>
    <property name="minutes" type="integer" column="runTime"/>
    <property name="price" type="float" column="price"/>
  </class>
</hibernate-mapping>

Note: here we are defining how the contents of the Video class are mapped to the table in the database, I have a sequence in Oracle called "video_seq" defined in Oracle

# Place in the video.har/META-INF directory

<?xml version="1.0" encoding="UTF-8"?>
<hibernate-configuration xmlns="urn:jboss:hibernate-deployer:1.0">
<session-factory name="java:/hibernate/jbia/VideoSF" bean="jbia.har:app=Video">
  <property name="datasourceName">java:jdbc/OracleDS</property>
  <property name="dialect">Oracle9idialect</property>
  <property name="hbm2ddlAuto">create-drop</property>
  <property name="showSqlEnabled">true</property>
  <depends>jboss:service=Naming</depends>
  <depends>jboss:service=TransactionManager</depends>
  <depends>jboss.jca:name=jdbc/OracleDS,service=DataSourceBinding</depends>
</session-factory>
</hibernate-configuration>

Note: this is not a data source but builds on the configured Oracle data source, there are number of hibernate properties see the table below

# Use a command similar to before to compile the java file
javac -classpath d:/jboss-dev/lib/servlet-api.jar;d:/jboss-dev/lib/hibernate3.jar;classes;. -d classes VideoServlet.java

# Once compiled place in the video.har\org\jbia\har directory

package org.jbia.har;

import java.io.IOException;
import java.util.List;

import javax.naming.InitialContext;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

/**
* Simple servlet used to illustrate working with a Hibernate archive. The
* servlet accepts user input for a new video, adds the video to the database,
* and then displays to the user all of the videos.
*/
public class VideoServlet extends HttpServlet {

   @Override
   protected void doGet(HttpServletRequest req, HttpServletResponse resp)
                                      throws ServletException, IOException {

     Session hs = null;
     try {
           InitialContext ctx = new InitialContext();
           SessionFactory hsf = (SessionFactory) ctx.lookup("java:/hibernate/jbia/VideoSF");
           hs = hsf.openSession();

           String strName = req.getParameter("name");
           String strMinutes = req.getParameter("minutes");
           String strPrice = req.getParameter("price");
           if ((strName != null) && (strMinutes != null) && (strPrice != null)) {
             Video video = new Video();
             video.setName(strName);
             video.setMinutes(Integer.parseInt(strMinutes));
             video.setPrice(Float.parseFloat(strPrice));
             hs.save(video);
             hs.flush();
           }

           Query qVideo = hs.createQuery("from org.jbia.har.Video order by name");
           List mvVideo = qVideo.list();
           req.setAttribute("videos", mvVideo);

           ServletContext sc = getServletContext();
           RequestDispatcher rd = sc.getRequestDispatcher("/index.jsp");
           rd.forward(req, resp);

     } catch (Throwable e) {
          e.printStackTrace();
          resp.setStatus(HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
     } finally {
          if (hs != null) {
            hs.close();
          }
     }
  }

  @Override
  protected void doPost(HttpServletRequest req, HttpServletResponse resp)
                                       throws ServletException, IOException {
    doGet(req, resp);
  }
}

# place in the video.war directory

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="f" uri="http://java.sun.com/jsp/jstl/fmt"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Hibernate Archive Example</title>
</head>

<body>  
  <h3>Input data for new video:</h3>
  <form action="video" method="post">
  <table class="input">
  <tr>
    <th>Name:</th>
    <td><input type="text" size="50" name="name" value="Monty Python and the Holy Grail" /></td>
    </tr>
    <tr>
    <th>Minutes:</th>
    <td><input type="text" name="minutes" value="91" /></td>
    </tr>
    <tr>
    <th>Price:</th>
    <td><input type="text" name="price" value="14.99" /></td>
    </tr>
    <tr>
    <td>&nbsp;</td>
    <td><input type="submit" value="submit" title="Add" /></td>
    </tr>
  </table>
  </form>

  <c:if test="${videos != null}">
    <h3>Available videos:</h3>
    <table class="list">
      <tr>
      <th>ID</th>
      <th>Name</th>
      <th>Minutes</th>
      <th>Price</th>
      </tr>
      <c:forEach var="video" items="${videos}">
        <tr>
        <td class="number">${video.id}</td>
        <%--
           c:out will filter special characters to prevent cross-site scripting
           attacks. We need to do it only for this attribute because it is the
           only one that is a string.
        --%>
        <td><c:out value="${video.name}" /></td>
        <td class="number">${video.minutes}</td>
        <td class="number">${video.price}</td>
        </tr>
      </c:forEach>
    </table>
  </c:if>

</body>
</html>

<servlet>
  <servlet-name>Video</servlet-name>
  <servlet-class>org.jbia.har.VideoServlet</servlet-class>
</servlet>

<servlet-mapping>
  <servlet-name>Video</servlet-name>
  <url-pattern>/video</url-pattern>
</servlet-mapping>

<welcome-file-list>
  <welcome-file>index.jsp</welcome-file>
</welcome-file-list>

</web-app>