harshad kadam

ntumba lobo wrote:why are you using "property-ref" in your Employee mapping ?
It is not necessary to establish the one-to-one relationship unless you work with legacy database.
It could be the problem.

I reffered "property-ref" from this tutorial.

As per your advice i removed "property-ref" but didn't work for me. Problem persists.

hello,
i am beginner to hibernate. please guide me with one to one mapping.

DB table structure:

EMPLOYEE_MASTER ( ID DECIMAL NOT NULL, USER_NAME VARCHAR(100) NOT NULL, PASSWORD VARCHAR(100) NOT NULL, FIRST_NAME VARCHAR(100) NOT NULL, LAST_NAME VARCHAR(100) NOT NULL, PRIMARY KEY (ID) )

EMPLOYEE_CONTACT ( ID DECIMAL DEFAULT '0' NOT NULL, EMPLOYEE_ID DECIMAL, MOBILE VARCHAR(15), HOME VARCHAR(15), WORK VARCHAR(15), FAX VARCHAR(15), EMAIL VARCHAR(50), PRIMARY KEY (ID), CONSTRAINT EC_UK_EMPLOYEE UNIQUE (EMPLOYEE_ID) )

Employee.java

private long id; private String userName; private String password; private String firstName; private String lastName; private EmployeeContact employeeContact;

EmployeeContact.java
private long id; private Employee employee; private String mobile; private String home; private String work; private String fax; private String email;

Employee.hbm.xml
<hibernate-mapping> <class name="com.test.hibtutorial.model.Employee" table="EMPLOYEE_MASTER"> <id name="id" type="long"> <column name="ID" /> <generator class="increment" /> </id> <property name="userName" type="java.lang.String"> <column name="USER_NAME" /> </property> <property name="password" type="java.lang.String"> <column name="PASSWORD" /> </property> <property name="firstName" type="java.lang.String"> <column name="FIRST_NAME" /> </property> <property name="lastName" type="java.lang.String"> <column name="LAST_NAME" /> </property> <one-to-one name="employeeContact" class="com.test.hibtutorial.model.EmployeeContact" property-ref="employee" cascade="all"></one-to-one> </class> </hibernate-mapping>

EmployeeContact.hbm.xml
<hibernate-mapping> <class name="com.test.hibtutorial.model.EmployeeContact" table="EMPLOYEE_CONTACT"> <id name="id" type="long"> <column name="ID" /> <generator class="increment" /> </id> [b]<one-to-one name="employee" class="com.test.hibtutorial.model.Employee" constrained="true"></one-to-one>[/b] <property name="mobile" type="java.lang.String"> <column name="MOBILE" /> </property> <property name="home" type="java.lang.String"> <column name="HOME" /> </property> <property name="work" type="java.lang.String"> <column name="WORK" /> </property> <property name="fax" type="java.lang.String"> <column name="FAX" /> </property> <property name="email" type="java.lang.String"> <column name="EMAIL" /> </property> </class> </hibernate-mapping>

Here in EmployeeBean.java, i construct employee object

Employee employee = new Employee(); employee.setUserName("harshadkadam"); employee.setPassword("ferdelance"); employee.setFirstName("harshad"); employee.setLastName("kadam"); EmployeeContact employeeContact = new EmployeeContact(); employeeContact.setEmail("harshad.8811@gmail.com"); employeeContact.setFax("8811881188"); employeeContact.setHome("1188118811"); employeeContact.setMobile("8888111188"); employeeContact.setWork("8888111188"); employee.setEmployeeContact(employeeContact); EmployeeDaoImpl employeeDaoImpl = new EmployeeDaoImpl(); long result = employeeDaoImpl.save(employee);

Here in EmployeeDaoImpl.java i save the employee object


public long save(Employee employee) { long result = 0; Session session = HibernateUtil.currentSession(); try { session.beginTransaction(); result = (Long) session.save(employee); session.getTransaction().commit(); } catch (HibernateException e) { e.printStackTrace(); } finally { session.flush(); HibernateUtil.closeSession(); } return result; }


The problem is one to one mapping. The EmployeeContact object gets saved except employee_id. EMPLOYEE_ID remains null in EMPLOYEE_CONTACT table. Please guide me where the configuration is fallen short.

Hello,
I have one simple login service implemented in a servlet.
if(jsnObj.has("username") && jsnObj.has("password")) { String username = jsnObj.getString("username"); String password = jsnObj.getString("password"); UserMaster userMaster = userMasterDao.getUserMasterByUserNamePassword(username, password); if(userMaster != null && userMaster.getId() != 0) { request.getSession().setAttribute("user_id", userMaster.getId()); sessionId = request.getSession().getId(); //PLEASE_SEE_HERE } Date loggedInDate = new Date(); String loggedInDateStr = Util.DateToString(loggedInDate, "dd-MM-yyyy"); loginServiceJsonString = loginServiceBuildJson.loginJson(userMaster, sessionId, callback, loggedInDateStr); }

here i get the session id for this servlet context. To authenticate user later in other service, i have other method which matches the session id generated at after login, with currentSessId = request.getSession(false).getId();
if(op.equals("validate_sessid")) { authServiceBean = new AuthServiceBean(); String currentSessId = request.getSession(false).getId(); System.out.println("CURRENT_SESS_ID_AT_VALIDATE:\t"+currentSessId); String validateSession = authServiceBean.validateSession(request, param, callback, currentSessId); out.println(validateSession); }
where, validateSession method matches currentSessId with sessionId dat was generated at login time (which comes through URL request).

This approach is working fine when i access the this servlet through ip, means
http://192.168.5.9:8080/MyProj/MyServlet?_service=login&_param={%27username%27:%27admin%27,%20%27password%27:%27admin%27}

But when i access application through domain, it is creating new session Id every time i make the request.
http://local.myproj.com/MyServlet?_service=login&_param={%27username%27:%27admin%27,%20%27password%27:%27admin%27}


Please advice me what is going wrong here?

the properties "updatedUserId.officerName" & "logSheet.status" are not being resolved!

I am using criteria to select some records from DB with restrictions on it. I have one table say A & its pojo A.java, its field mapped with other table B. (many-to-one).
When i use criteria with restriction, the id (which is the primary key of ) of other class is mapped in the property field. But when i give some other variable from B.java, it gives "could not resolve property" excepion.
Why this happens?

here is the code:

session.beginTransaction(); Criteria criteria = session.createCriteria(LogSheetLog.class); if(filters.getFromDate() != null && filters.getToDate() == null) { criteria.add(Restrictions.ge("dateTime", Util.StringToDate(filters.getFromDate(), "dd-MMM-yyyy"))); } if(filters.getToDate()!=null && filters.getFromDate() == null) { criteria.add(Restrictions.le("dateTime", Util.StringToDate(filters.getToDate(), "dd-MMM-yyyy"))); } if(filters.getToDate()!=null && filters.getFromDate() != null) { criteria.add(Restrictions.between("dateTime", Util.StringToDate(filters.getFromDate(), "dd-MMM-yyyy"), Util.StringToDate(filters.getToDate(), "dd-MMM-yyyy"))); } if(filters.getAttendedBy()!=null) { criteria.add(Restrictions.like("updatedUserId.officerName", filters.getAttendedBy(), MatchMode.ANYWHERE)); } if(filters.getStatus()!=null) { criteria.add(Restrictions.eq("logSheet.status", filters.getStatus())); } criteria.addOrder(Order.desc("dateTime")); dailyWorkReport = criteria.list(); session.getTransaction().commit();

yes..it worked.. i had written [!callback.equals(null)] i changed it to [callback != null]. resolved.

in servlet i am taking value from URL String callback = request.getParameter("_callback"); problem is &_callback can be there or not, i am getting nullPointerException if &_callback is not there in URL. I tried to catch the exception but didn't work. is there any way to check whether request.getParameter() is null or not? if it is null, i want to execute a part of code and if not, other part.

i am using hibernate. Is it possible to write a system file containing database information which will reflect to hibernate.cfg.xml ??