How to use MBean in HibernateAnnotation

[omkar prem]

Hi,

i want to know how we can use MBean in hibernate Annotation.

please tell me any example or any tutorial.

Thank's & regard's
Omkar

[Jaikiran Pai]

"Omkar",

Please check your private message for a message from JavaRanch.

[Jaikiran Pai]

Originally posted by omkar:
i want to know how we can use MBean in hibernate Annotation.

Could you please tell us more about what you are trying to do? That will help us in pointing you to the right examples.

[omkar prem]

Hi Jai

i have to use mbean with hibernate annotation in my project,basicaly i have used mbean with hibernate core in the same project.which is to be changed on hibernate annotation and mbean. the project is based on struts.

1 i have created har file which contains jboss-service.xml and hibernate-ds.xml

 <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE server>
 
<!-- Generated file - Do not edit! -->
 
<server>
   <mbean code="org.hibernate.jmx.HibernateService" name="jboss.jca:service=dv.HibernateFactory">
       <attribute name="JndiName">java:/mbean/dv.HibernateFactory</attribute>
       <attribute name="Datasource">java:/jdbc/mm.rpt.SQLServerDS</attribute>
       <attribute name="Dialect">org.hibernate.dialect.SQLServerDialect</attribute>
       <attribute name="ShowSqlEnabled">true</attribute>
       
       <attribute name="UserTransactionName">UserTransaction</attribute>
       <attribute name="TransactionStrategy">org.hibernate.transaction.JTATransactionFactory</attribute>
       <attribute name="TransactionManagerLookupStrategy">org.hibernate.transaction.JBossTransactionManagerLookup</attribute>
   </mbean>
 </server>
   

above is my jboss-service.xml

<?xml version="1.0" encoding="UTF-8"?>
 
<datasources>
  
  <local-tx-datasource>
    <jndi-name>jdbc/mm.rpt.SQLServerDS</jndi-name>
    <connection-url>jdbc:jtds:sqlserver://3.209.5.249:1433/test</connection-url>
    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
    <user-name>test</user-name>
    <password>test</password>
<metadata>
        <type-mapping>SQLServer</type-mapping>
    </metadata> 

  </local-tx-datasource>
 
</datasources>    

above is my hibernateannotation-ds.xml

This is my POJO class

 package com.nbsl;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityResult;
import javax.persistence.Id;
import javax.persistence.SqlResultSetMapping;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
 
import org.hibernate.annotations.NamedNativeQuery;
 

@Entity
@SqlResultSetMapping( name="implict", entities=@EntityResult(entityClass=com.nbsl.CityDetail.class))
@NamedNativeQuery( name="implicitSample", query="select c.CityID CityID, c.CityName CityName from City c", resultSetMapping = "implict")
//@Table( name="City" )
/*
 *Defining  the Unique constrants
 */
@Table( name = "City", uniqueConstraints = {@UniqueConstraint(columnNames={"CityId"}) } )
 
public class CityDetail {
@Id
//@Column(name="CityId")
String CityId;
//@Column(name="CityName")
String CityName;
@Column
public String getCityId() {
return CityId;
}
public void setCityId(String cityId) {
CityId = cityId;
}
@Column
public String getCityName() {
return CityName;
}
public void setCityName(String cityName) {
CityName = cityName;
}
}   

This is my servlet which Access the database through JNDI

 
package com.nbsl;
 
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
 
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
 
public class Dbconnection extends HttpServlet {
 
public Dbconnection() {
super();
}
 

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

List list = null;
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Session newSession = getSession();
try {
System.out.println("****************************");
list = newSession.getNamedQuery("implicitSample").list();
System.out.println("List Size"+list.size());
CityDetail cityDetail1 ;
for(int i=0;i<list.size();i++){
cityDetail1 = (CityDetail)list.get(i);
System.out.println("City ID :"+cityDetail1.getCityId()+" City Name :"+cityDetail1.getCityName());
}
} catch (Exception e) {
     e.printStackTrace();
   }
newSession.close();
out.flush();
out.close();
}
 

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
 
doGet(request,response);
}

public Session getSession(){
InitialContext ctx;
Session hsession = null;;
try {
ctx = new InitialContext();
SessionFactory factory  = (SessionFactory)ctx.lookup("java:/mbean/omkar.HibernateFactory");
factory.openSession();
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return hsession;
}

}
   

the error which is comming is

  10:38:39,546 ERROR [STDERR] org.hibernate.MappingException: Named query not known: implicitSample
at org.hibernate.impl.AbstractSessionImpl.getNamedQuery(AbstractSessionImpl.java:70)
at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1260)
at com.nbsl.Dbconnection.doGet(Dbconnection.java:34)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Unknown Source)  

i think that ihave to configure the pojo but how i could do because i am getting the sessionfectory object through

  SessionFactory factory  = (SessionFactory)ctx.lookup("java:/mbean/prem.HibernateFactory");  

and i will configure it through

 SessionFactory factory1 = new AnnotationConfiguration().configure().addPackage("com.nbsl").addAnnotatedClass(CityDetail.class).buildSessionFactory();   

tell me any solution.

Thank's & Regard's

Omkar Rai

[omkar prem]

Any have any solution of this problem