omkar prem

Hi
I want to be a part of the iksacn project
thanks
prem

Any have any solution of this problem

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

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

yes commons-validator.jar is added

Hi,

I am using a struts validation framework in a simple application. when i run the application i got exception

ValidatorResources not found in application scope under key "org.apache.commons.validator.VALIDATOR_RESOURCES"

i have already included the validator plugin in struts-config.xml and commans jars in my class path.

my UserForm class is extending the ValidatorForm.

UserForm
public class UserForm extends ValidatorForm implements Serializable{ String usrName; String usrPwd; public String getUsrName() { return usrName; } public void setUsrName(String usrName) { this.usrName = usrName; } public String getUsrPwd() { return usrPwd; } public void setUsrPwd(String usrPwd) { this.usrPwd = usrPwd; } }

register.jsp
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%> <%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%> <html:html> <head> <title>My JSP 'register.jsp' starting page</title> </head> <body> <html:form action="/usrValidate" onsubmit="return validateUserform(this);"> User Name :<html:text property="usrName" /> User Password :<html :-P assword property="usrPwd" /> <html:submit /> </html:form> <html:javascript formName="userform" dynamicJavascript="false" staticJavascript="false"/> </body> </html:html>

validator.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE form-validation PUBLIC "-//Apache Software Foundation//DTD Commons Validator Rules Configuration 1.0//EN" "http://jakarta.apache.org/commons/dtds/validator_1_0.dtd"> <form-validation> <formset> <form name="userform"> <field property="usrName" depends="required,mask,minlength"> <arg0 key="logform.usrName"/> <arg1 name="minlength" key="${var:minlength}" resource="false"/> <var> <var-name>mask</var-name> <var-value>^\w+$</var-value> </var> <var> <var-name>minlength</var-name> <var-value>5</var-value> </var> </field> <field property="usrPwd" depends="required,mask,minlength"> <arg0 key="logform.usrPwd"/> <arg1 name="minlength" key="${var:minlength}" resource="false"/> <var> <var-name>mask</var-name> <var-value>^\w+$</var-value> </var> <var> <var-name>minlength</var-name> <var-value>5</var-value> </var> </field> </form> </formset> </form-validation>

struts-config.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd"> <struts-config> <data-sources /> <form-beans> <form-bean name="userform" type="com.nbsl.validate.UserForm"></form-bean> </form-beans> <global-exceptions /> <global-forwards /> <action-mappings> <action path="/usrValidate" type="com.nbsl.validate.UserAction" name="userform" input="pages/register.jsp" scope="request" validate="true"> <forward name="success" path="/pages/success.jsp" /> <forward name="failure" path="/pages/failure.jsp" /> </action> </action-mappings> <message-resources parameter="com.nbsl.struts.ApplicationResources" /> <plug-in className="org.apache.struts.validator.ValidatorPlugIn"> <set-property property="pathnames" value="/WEB-INF/validator-rules.xml, /WEB-INF/validation.xml"/> </plug-in> </struts-config>

where the problem exist i am unable to trace.

Regard's
Omkar

Hi All,

I have to get data from two column of table. My table name is Employee_Det the fields in the table are ID,Name,Age,Deg. the query i am using to fetch ID and Name are as followes

Query qr = session.createSQLquery("select e.id,e.name from Employee_det as e").addEntity("e",empl.class)

but this query gives an error. I have to do this by using addEntity() method



Prem

Hi,

I want to use Union clause(in native query) in hibernate.How i can do this.

Regards
Prem