hibernate-servlet

[nimesh hindocha]

Hi friends,
I am getting following exception and my cde is as given below.please any one could help to locate the fault.

org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:80)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:62)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at mypack.PdServlet.init(PdServlet.java:35)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at mypack.PdServlet.doPost(PdServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

   package mypack;

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

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;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class PdServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
	SessionFactory factory=null;

	public void init()
	{
		try
		{
			Configuration cfg = new Configuration();
			cfg.addClass(AccelProductId.class);

			factory = cfg.buildSessionFactory();
			System.out.println("factory ready");

		}
		catch(Exception e1)
		{
			e1.printStackTrace();
		}

	}
	
	public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
	{
		res.setContentType("text/html");
		PrintWriter out = res.getWriter(); 
		
		Transaction tr = null;
		try
		{
		Session session = factory.openSession();

		tr = session.beginTransaction();
		String action=req.getParameter("submit");
		if(action.equals("view product"))
			DisplayAll(out,session);
		else
			out.println("BAD INPUT");
		
		session.flush();
		session.close(); 

		}
		catch(Exception e1) 
		{
			e1.printStackTrace();
		}

	}

	private void DisplayAll(PrintWriter out, Session session) {
		try 
		{
			out.println("<html>");
			out.println("<table>");
			out.println("<tr><td>inst</td><td>cpiProdId</td><td>prodIdDesc</td></tr>");
			Query query=session.createQuery(" from AccelProductId p ");
			List list=query.list();
			Iterator iter=list.iterator();
			while(iter.hasNext())
			{
				AccelProductId t= (AccelProductId)iter.next();
				out.println("<tr><td>");
				out.println(t.getId().getInst());
				out.println("</td><td>");
				out.println(t.getId().getCpiProdId());
				out.println("</td><td>");
				out.println(t.getProdIdDesc());
				out.println("</td></tr>");
			}
			
		}
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	
		out.println("</table>");
		out.println("</html>");
		
	}


}
 

  <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!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>Insert title here</title>
</head>
<body>
<form action="PdServlet" method="POST">

        <input type="submit" value="Submit">
</form> 
</body>
</html>  

 <?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>hservtest</display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
    
    <display-name>PdServlet</display-name>
    
    <servlet-name>PdServlet</servlet-name>
    <servlet-class>mypack.PdServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>PdServlet</servlet-name>
    <url-pattern>/PdServlet</url-pattern>
  </servlet-mapping>
</web-app>   

Thanks..

[Vijitha Kumara]

nimesh hindocha wrote:I am getting following exception...

What is that?

[nimesh hindocha]

Hi
I want to know how to do hibernate configuration in this servlet based hibernate application.

[nimesh hindocha]

nimesh hindocha wrote:Hi
I want to know how to do hibernate configuration in this servlet based hibernate application.

[nimesh hindocha]

org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:80)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:62)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at mypack.PdServlet.init(PdServlet.java:35)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at mypack.PdServlet.doPost(PdServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

[Vijitha Kumara]

I suggest you start here. It's a complete example with servlet. You can ignore the Maven configurations if you already have the required jar files etc... Specially look for the hibeernate.cfg.xml and the hbm files where you need to setup with the appropriate values for your application.

[nimesh hindocha]

Hi,
How to configure when the application is deployed because apache tomcat looks in deployment descriptor that is web.xml.

so how i can direct it to hibernate.cfg.xml file from web.xml for configuration.

below is my configuration file. Please give some way.

 <?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.ibm.db2.jcc.DB2Driver</property>
        <property name="hibernate.connection.password">********</property>
        <property name="hibernate.connection.url">jdbc:db2://localhost:50000/LSSDEVL:retrieveMessagesFromServerOnGetMessage=true;</property>
        <property name="hibernate.connection.username">nimesh.hindocha</property>
        <property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property>
        <mapping resource="mypack/AccelProductId.hbm.xml" />
    </session-factory>
</hibernate-configuration>
   

[nimesh hindocha]

Hi,
I have understood the problem but i am unable to fix it..so anybody can help please.

[Vijitha Kumara]

..so how i can direct it to hibernate.cfg.xml file from web.xml for configuration....

You don't. In this example when you first hit the servlet hibernate will initialize. Just make sure you have the hibernate.cfg.xml file directly inside the WEB-INF/classes directory. Of course this is to test the hibernate and if you use in a real application you might bind the hibernate service to JNDI in the server startup, initialized in a listener etc...

[nimesh hindocha]

Thanks Vijitha for your reply.
I wanted to know if i keep hibernate.cfg.xml file directly inside the WEB-INF/classes do i have to write context path in server.xml file and i would also like to know second approach which you have mentioned

if you use in a real application you might bind the hibernate service to JNDI in the server startup, initialized in a listener etc...

again thanks for reply...

[nimesh hindocha]

Hi vijitha,
I have kept hibernate.cfg.xml file as said by you but i am getting the same exception again and i am giving server.xml file might be needed .I have attached the project structure and i am using eclipse.

     <?xml version="1.0" encoding="UTF-8"?>
<Context path="/PdServlet" docBase="/PdServlet">
<Resource name="jdbc/pullprod" scope="shareable" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/pullprod">

<parameter>
<name>factory</name>
<value>
	org.apache.commons.dbcp.BasicDataSourceFactory
</value>
</parameter>

<parameter>
<name>url</name>
<value>
	jdbc:db2://localhost:50000/LSSDEVL:retrieveMessagesFromServerOnGetMessage=true;
</value>
</parameter>

<parameter>
<name>driverClassName</name>
<value>
	com.ibm.db2.jcc.DB2Driver
</value>
</parameter>

<parameter>
<name>username</name>
<value>
nimesh.hindocha
</value>
</parameter>

<parameter>
<name>password</name>
<value>
*******	
</value>
</parameter>

<parameter>
<name>maxWait</name>
<value>2000</value>
</parameter>

<parameter>
<name>maxIdle</name>
<value>250</value>
</parameter>

<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
</ResourceParams>
</Context>   

I am waiting for your reply....

[Paul Sturrock]

nimesh hindocha wrote:Thanks Vijitha for your reply.
I wanted to know if i keep hibernate.cfg.xml file directly inside the WEB-INF/classes do i have to write context path in server.xml file and i would also like to know second approach which you have mentioned

if you use in a real application you might bind the hibernate service to JNDI in the server startup, initialized in a listener etc...

again thanks for reply...

Hibernate doesn't know anything about the container you deploy it in (or indeed if there is a container used at all) so context.xml (by which I assume you are referring to a Tomcat file?) is unrelated to Hibernate.

Your configuration file needs to be on the classpath. If you don't explicitly state where it is (see the Hibernate JavaDocs for the Configuration class) Hibernate looks in the default package.

The JNDI-bound SessionFactory Vijitha mentions is explained in the Hibernate documentation here.

The error message you are seeing:

org.hibernate.HibernateException: Hibernate Dialect must be explicitly set

suggest your configuration does not include a Dialect. Given the one you've posted does define one, I would double check you are using the one you think you are.