using hibernate 3.0
Mapping for the tables in my hbm files
Code:
<class name="com.aztecsoft.obopay.crm.entity.Member" table="MEMBER" >
<id name="id" type="java.lang.Long">
<column name="ID" precision="24" scale="0" /><!--
<generator class="assigned" />
--><generator class="sequence" >
<param name="sequence">SEQ_MEMBERNUM</param>
</generator>
</id>
<property name="memberType" type="java.lang.String">
<column name="MEMBER_TYPE" length="10" not-null="true" />
</property>
<property name="firstName" type="java.lang.String">
<column name="FIRST_NAME" length="16" not-null="true" />
</property>
<property name="lastName" type="java.lang.String">
<column name="LAST_NAME" length="16" not-null="true" />
</property>
<property name="middleName" type="java.lang.String">
<column name="MIDDLE_NAME" length="16" />
</property>
<property name="loginId" type="java.lang.String">
<column name="LOGIN_ID" length="16" />
</property>
<property name="pwd" type="java.lang.String">
<column name="PWD" length="16" />
</property>
<property name="email" type="java.lang.String">
<column name="EMAIL" length="64" unique="true" />
</property>
<property name="address" type="java.lang.String">
<column name="ADDRESS" />
</property>
<property name="city" type="java.lang.String">
<column name="CITY" length="64" />
</property>
<property name="state" type="java.lang.String">
<column name="STATE" length="64" />
</property>
<property name="pinCode" type="java.lang.String">
<column name="PIN_CODE" length="20" />
</property>
<property name="fax" type="java.lang.String">
<column name="FAX" length="20" />
</property>
<property name="createdDt" type="java.util.Date">
<column name="CREATED_DT" length="7" not-null="true" />
</property>
<property name="createdBy" type="java.lang.String">
<column name="CREATED_BY" length="15" />
</property>
<property name="status" type="java.lang.String">
<column name="STATUS" length="1" not-null="true" />
</property>
<property name="modifiedDt" type="java.util.Date">
<column name="MODIFIED_DT" length="7" />
</property>
<property name="modifiedBy" type="java.lang.String">
<column name="MODIFIED_BY" length="15" />
</property>
<set name="deviceinfos" inverse="true">
<key>
<column name="ID" precision="24" scale="0" not-null="true" unique="true" />
</key>
<one-to-many class="com.aztecsoft.obopay.crm.entity.DeviceInfo" />
</set>
<set name="memberDeviceses" inverse="true" cascade="all">
<key>
<column name="MEMBER_ID" precision="24" scale="0" not-null="true" />
</key>
<one-to-many class="com.aztecsoft.obopay.crm.entity.MemberDevices" />
</set>
<set name="memberBankDtlses" inverse="true">
<key>
<column name="MEMBER_ID" precision="24" scale="0" not-null="true" />
</key>
<one-to-many class="com.aztecsoft.obopay.crm.entity.MemberBankDtls" />
</set>
<property name="isBillpayDisclaimer" type="java.lang.String">
<column name="IS_BILLPAY_DISCLAIMER" length="1" />
</property>
</class>
<class name="com.aztecsoft.obopay.crm.entity.MemberDevices" table="MEMBER_DEVICES">
<composite-id name="id" class="com.aztecsoft.obopay.crm.entity.MemberDevicesId" >
<key-many-to-one name="member" class="com.aztecsoft.obopay.crm.entity.Member" >
<column name="MEMBER_ID" precision="24" scale="0" />
</key-many-to-one>
<key-property name="deviceNum" type="java.lang.String" >
<column name="DEVICE_NUM" length="20" />
</key-property>
</composite-id>
<property name="flag" type="java.lang.String">
<column name="FLAG" length="1" />
</property>
<property name="comments" type="java.lang.String">
<column name="COMMENTS" length="100" />
</property>
</class>
Method that is getting called
Code:
public Object acceptChanges(final Long customerId, final String logId, final String isException) throws Exception {
HibernateCallback action = new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
session.connection().setAutoCommit(false);
BankUser bankUserObject = (BankUser) getObject(BankUser.class, logId);
BankCustomer bankCustomer = (BankCustomer) getObject(BankCustomer.class, customerId);
String status = bankCustomer.getStatus();
Long memberId = bankCustomer.getMemberId();
Long bankId = bankCustomer.getBankMaster().getBankId();
Criteria criteria = session.createCriteria(MemberBankDtls.class);
Member member = new Member();
member.setId(memberId);
BankMaster bankMaster = new BankMaster();
bankMaster.setBankId(bankId);
criteria.add(Restrictions.eq("id.member", member));
criteria.add(Restrictions.eq("id.bankMaster", bankMaster));
MemberBankDtls memberBankDtls = (MemberBankDtls) criteria.uniqueResult();
String accountStatus = memberBankDtls.getAccountStatus();
if (isException.equals("N")) {
// APPROVE BY THE CHECKER
// Check if the reference id is already registered for that bank - in MEMBER related tables
String query = "SELECT MEMBER_ID FROM MEMBER_BANK_DTLS WHERE BANK_ID = "+bankCustomer.getBankMaster().getBankId()+" AND INTERNAL_ACCOUNT_NUMBER= '"+bankCustomer.getReferenceId()+"' AND MEMBER_ID != " + memberId;
logger.info(query);
boolean isMemberAvailable = false;
boolean isExistingMemActive = false;
boolean isException = false;
ResultSet rs = (session.connection().createStatement().executeQuery(query));
if(rs.next())
{
isMemberAvailable = true;
long existingMemberId = rs.getLong("MEMBER_ID");
String inactiveUserDuration = resbundle.getString("inactiveUserDurationInDays");
query = "SELECT ID FROM MEMBER WHERE ID=" + existingMemberId + " AND CREATED_DT > SYSDATE-" + inactiveUserDuration;
ResultSet rset = session.connection().createStatement().executeQuery(query);
if (rset.next()) {
isExistingMemActive = true;
}
if (!isExistingMemActive) {
query = "SELECT ID FROM AUDITEVENT WHERE MEMBERID=" + existingMemberId + " AND TIMESTAMP > SYSDATE-" + inactiveUserDuration;
rset = session.connection().createStatement().executeQuery(query);
if (rset.next()) {
isExistingMemActive = true;
}
}
}
if(isMemberAvailable == true)
{
if (isExistingMemActive) {
logger.info("ReferenceId for the specified bank is already registered");
throw new ConstraintViolationException("ReferenceId for the specified bank is already registered",new SQLException("ReferenceId for the specified bank is already registered"),"Email ID");
} else {
isException = true;
bankCustomer.setStatus("X");
bankCustomer.setUploadStatus("X");
bankCustomer.setErrorCodes("REF101");
bankCustomer.setBankUserByCheckerId(bankUserObject);
bankCustomer.setCheckerTimestamp(new java.util.Date());
}
}
// Check if the mobile number is already registered for this bank in MEMBER related tables
query = "SELECT mbd.MEMBER_ID as MEMBER_ID FROM MEMBER_BANK_DTLS mbd WHERE mbd.ACCOUNT_STATUS!='ACDISBLD' AND mbd.BANK_ID='" + bankCustomer.getBankMaster().getBankId() + "' AND mbd.DEVICE_NUMBER = '" + bankCustomer.getMobileNumber() + "' AND mbd.MEMBER_ID != " + memberId;
logger.info(query);
isMemberAvailable = false;
rs = (session.connection().createStatement().executeQuery(query));
if(rs.next())
{
isMemberAvailable = true;
}
if(isMemberAvailable == true)
{
if (isExistingMemActive) {
logger.info("Mobile Number is already registered for this bank");
throw new ConstraintViolationException("Mobile Number is already registered for this bank",new SQLException("Mobile Number is already registered for this bank"),"Email ID");
} else {
if (isException) {
// Multiple exceptions - mark it as an error
bankCustomer.setStatus("E");
bankCustomer.setUploadStatus("E");
bankCustomer.setErrorCodes("BE4444");
bankCustomer.setBankUserByCheckerId(bankUserObject);
bankCustomer.setCheckerTimestamp(new java.util.Date());
} else {
isException = true;
bankCustomer.setStatus("X");
bankCustomer.setUploadStatus("X");
bankCustomer.setErrorCodes("MOB100");
bankCustomer.setBankUserByCheckerId(bankUserObject);
bankCustomer.setCheckerTimestamp(new java.util.Date());
}
}
}
// EXCEPTION: Check if the mobile number is already registered for any other bank in MEMBER related tables
query = "SELECT mbd.MEMBER_ID FROM MEMBER_BANK_DTLS mbd WHERE mbd.BANK_ID!='" + bankCustomer.getBankMaster().getBankId() + "' AND mbd.DEVICE_NUMBER = '" + bankCustomer.getMobileNumber() + "' AND mbd.MEMBER_ID != " + memberId+"AND mbd.ACCOUNT_STATUS != 'ACDISBLD'";
logger.info(query);
rs = (session.connection().createStatement().executeQuery(query));
if(rs.next())
{
if (isException) {
// Multiple exceptions - mark it as an error
bankCustomer.setStatus("E");
bankCustomer.setUploadStatus("E");
bankCustomer.setErrorCodes("BE4444");
bankCustomer.setBankUserByCheckerId(bankUserObject);
bankCustomer.setCheckerTimestamp(new java.util.Date());
} else {
String queryStr = "SELECT mbd.MEMBER_ID FROM MEMBER_BANK_DTLS mbd WHERE mbd.BANK_ID!='" + bankCustomer.getBankMaster().getBankId() + "' AND mbd.DEVICE_NUMBER = '" + bankCustomer.getMobileNumber() + "' AND mbd.MEMBER_ID != " + memberId + " and mbd.FIRST_NAME='" + bankCustomer.getFirstName() + "' and mbd.LAST_NAME='" + bankCustomer.getLastName() + "' and mbd.MIDDLE_NAME";
if (bankCustomer.getMiddleName() == null)
queryStr = queryStr + " IS NULL";
else
queryStr = queryStr + "='" + bankCustomer.getMiddleName() + "'";
ResultSet rset = session.connection().createStatement().executeQuery(queryStr);
if (rset.next()) {
logger.debug("Names matched");
bankCustomer.setStatus("A");
long matchedMemId = rset.getLong(1);
String sqlQuery = "UPDATE MEMBER_BANK_DTLS SET MEMBER_ID=" + matchedMemId + " ,MODIFIED_BY='"+ memberBankDtls.getModifiedBy() + "' ,MODIFIED_DT =SYSDATE ,MODIFICATION_FLAG= " + null + ", DEVICE_NUMBER='" + bankCustomer.getMobileNumber() + "' WHERE MEMBER_ID=" + memberBankDtls.getId().getMember().getId() + " AND BANK_ID = " + memberBankDtls.getId().getBankMaster().getBankId();
logger.info("The SQLQuery Entered is ---- "+sqlQuery);
session.connection().createStatement().executeUpdate(sqlQuery);
memberBankDtls.setDeviceNum(bankCustomer.getMobileNumber());
} else {
logger.debug("Names did not match");
isException = true;
bankCustomer.setStatus("X");
bankCustomer.setUploadStatus("X");
bankCustomer.setErrorCodes("MOB101");
bankCustomer.setBankUserByCheckerId(bankUserObject);
bankCustomer.setCheckerTimestamp(new java.util.Date());
}
}
}
}
if (isException.equals("Y") || !bankCustomer.getStatus().equals("X")) {
memberBankDtls.setModificationFlag(null);
memberBankDtls.setModifiedBy(logId);
memberBankDtls.setModifiedDt(new java.util.Date());
memberBankDtls.setMicrCode(bankCustomer.getCustomerNumber());
memberBankDtls.setFirstName(bankCustomer.getFirstName());
memberBankDtls.setMiddleName(bankCustomer.getMiddleName());
memberBankDtls.setLastName(bankCustomer.getLastName());
memberBankDtls.setEmail(bankCustomer.getEmailId());
memberBankDtls.setClassType(bankCustomer.getClassOfUser());
if (bankCustomer.getTypeOfAccount() != null)
memberBankDtls.setTypeOfAccount(new Integer(bankCustomer.getTypeOfAccount()));
memberBankDtls.setAddress(bankCustomer.getAddress());
memberBankDtls.setCity(bankCustomer.getCity());
memberBankDtls.setState(bankCustomer.getState());
memberBankDtls.setPinCode(bankCustomer.getPinCode());
memberBankDtls.setFax(bankCustomer.getFax());
memberBankDtls.setBankCustomerRefId(bankCustomer.getBankCustomerRefId());
memberBankDtls.setDateOfBirth(DateUtil.convertStringToDate(bankCustomer.getDateOfBirth(), "yyyy-MM-dd"));
memberBankDtls.setPanCardNumber(bankCustomer.getPanCardNumber());
memberBankDtls.setBankAccNumber(bankCustomer.getBankAccNumber());
if (!memberBankDtls.getInternalAccountNumber().equals(bankCustomer.getReferenceId())) {
memberBankDtls.setInternalAccountNumber(bankCustomer.getReferenceId());
memberBankDtls.setMpinStatus("MPINPEND");
memberBankDtls.setMpinAuthCount(new Long(0));
}
memberBankDtls.setDeviceNum(bankCustomer.getMobileNumber());
if (accountStatus.equals("ACDISBLD")) {
memberBankDtls.setAccountStatus("ACACTVNC");
BankUserActivityId bankUserActivityId = new BankUserActivityId();
bankUserActivityId.setModifiedDate(new java.util.Date());
bankUserActivityId.setBankUser(bankUserObject);
bankUserActivityId.setCustomerId(memberId);
BankUserActivity buAct = new BankUserActivity();
buAct.setReferenceId(memberBankDtls.getInternalAccountNumber());
buAct.setFirstName(memberBankDtls.getFirstName());
buAct.setLastName(memberBankDtls.getLastName());
buAct.setEmailId(memberBankDtls.getEmail());
buAct.setMobileNumber(memberBankDtls.getDeviceNum());
buAct.setStatusFrom("D");
buAct.setStatusTo("A");
buAct.setBankMaster(memberBankDtls.getId().getBankMaster());
buAct.setId(bankUserActivityId);
buAct.setMember(member);
buAct.setComments("Activated");
session.saveOrUpdate(buAct);
}
session.saveOrUpdate(memberBankDtls);
String oldMobileNumber = null;
String newMobileNumber = bankCustomer.getMobileNumber();
Set mobileNumbers = memberBankDtls.getId().getMember().getMemberDeviceses();
Iterator iter = mobileNumbers.iterator();
while (iter.hasNext()) {
MemberDevices devices = (MemberDevices) iter.next();
if (devices.getFlag().equals("A")) {
oldMobileNumber = devices.getId().getDeviceNum();
System.out.println("OLD MOB NUM *" + oldMobileNumber + "*");
System.out.println("NEW MOB NUM *" + newMobileNumber + "*");
break;
}
}
if (!newMobileNumber.equals(oldMobileNumber)) {
if (accountStatus.equals("ACDISBLD")) {
ResourceBundle resourcebundle = ResourceBundle.getBundle("resources");
String flag = resourcebundle.getString("customer.member.devices.flag");
String processortype = resourcebundle.getString("customer.member.device.info.processortype");
String applicationtype = resourcebundle.getString("customer.member.device.info.applicationtype");
MemberDevicesId devicesId = new MemberDevicesId();
devicesId.setDeviceNum(newMobileNumber);
devicesId.setMember(member);
MemberDevices devices = new MemberDevices();
devices.setId(devicesId);
devices.setFlag(flag);
session.saveOrUpdate(devices);
DeviceInfo deviceInfo = new DeviceInfo();
//deviceInfo.setMember(member);
deviceInfo.setId(member.getId());
deviceInfo.setApplicationtype(applicationtype);
deviceInfo.setConnectionkey(null);
deviceInfo.setDevicekey(newMobileNumber);
deviceInfo.setDevicenumber(newMobileNumber);
deviceInfo.setProcessortype(processortype);
session.saveOrUpdate(deviceInfo);
} else {
// If its an exception, disable the existing member that conflicted with this mobile number
if (status.equals("X")) {
criteria = session.createCriteria(MemberDevices.class);
criteria.add(Restrictions.eq("id.deviceNum", newMobileNumber));
criteria.add(Restrictions.eq("flag", "A"));
MemberDevices device = (MemberDevices) criteria.uniqueResult();
if (device != null) {
device.setFlag("D");
session.saveOrUpdate(device);
Long memId = device.getId().getMember().getId();
criteria = session.createCriteria(MemberBankDtls.class);
criteria.add(Restrictions.eq("id.member.id", memId));
List memberBankDtlss = criteria.list();
Iterator it = memberBankDtlss.iterator();
while (it.hasNext()) {
MemberBankDtls mbd = (MemberBankDtls)it.next();
mbd.setAccountStatus("ACDISBLD");
session.saveOrUpdate(mbd);
}
}
String query = "DELETE FROM DEVICE_AUTHCODE WHERE MOBILE_NUMBER='" + newMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "DELETE FROM DEVICEINFO WHERE DEVICENUMBER='" + newMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "DELETE FROM LOGIN_INFO WHERE MOBILENUMBER='" + newMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "DELETE FROM MEMBER_OPT_IN WHERE MEMBER_PHONE_NUM='" + newMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "DELETE FROM MOBILEINFO WHERE DEVICENUMBER='" + newMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
}
criteria = session.createCriteria(MemberDevices.class);
criteria.add(Restrictions.eq("id.member", member));
criteria.add(Restrictions.eq("id.deviceNum", oldMobileNumber));
MemberDevices memberDevices = (MemberDevices) criteria.uniqueResult();
memberDevices.setFlag("D");
session.saveOrUpdate(memberDevices);
memberDevices = new MemberDevices();
MemberDevicesId id = new MemberDevicesId();
id.setMember(member);
id.setDeviceNum(newMobileNumber);
memberDevices.setId(id);
memberDevices.setFlag("A");
session.saveOrUpdate(memberDevices);
// Update the old mobile number with new mobile number in related tables as well
String query = "UPDATE DEVICE_AUTHCODE SET MOBILE_NUMBER='" + newMobileNumber + "' WHERE MOBILE_NUMBER='" + oldMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "UPDATE DEVICEINFO SET DEVICENUMBER='" + newMobileNumber + "', DEVICEKEY='" + newMobileNumber + "' WHERE DEVICENUMBER='" + oldMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "UPDATE LOGIN_INFO SET MOBILENUMBER='" + newMobileNumber + "' WHERE MOBILENUMBER='" + oldMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "UPDATE MEMBER_OPT_IN SET MEMBER_PHONE_NUM='" + newMobileNumber + "' WHERE MEMBER_PHONE_NUM='" + oldMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "UPDATE MOBILEINFO SET DEVICENUMBER='" + newMobileNumber + "' WHERE DEVICENUMBER='" + oldMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "UPDATE VELOCITY_SWITCH_ERRORS SET DEVICE_NUMBER='" + newMobileNumber + "' WHERE DEVICE_NUMBER='" + oldMobileNumber + "'";
session.connection().createStatement().executeUpdate(query);
query = "UPDATE MEMBERBILLERS SET MOBILENUMBER='" + newMobileNumber + "' WHERE MEMBERID=" + memberId;
session.connection().createStatement().executeUpdate(query);
}
}
bankCustomer.setStatus("A");
}
bankCustomer.setModifiedBy(logId);
bankCustomer.setModifiedDate(new java.util.Date());
bankCustomer.setBankUserByCheckerId(bankUserObject);
bankCustomer.setCheckerTimestamp(new java.util.Date());
if ("X".equals(status)) {
bankCustomer.setExceptionActionTaken("APPROVE");
}
session.saveOrUpdate(bankCustomer);
session.connection().commit();
return bankCustomer.getStatus();
}
};
return getHibernateTemplate().execute(action);
}
Full stacktrace of the exception
Quote:
org.springframework.orm.hibernate3.HibernateSystemException: a different object with the same identifier value was already associated with the session: [com.aztecsoft.obopay.crm.entity.MemberDevices#com.aztecsoft.obopay.crm.entity.MemberDevicesId@66408d]; nested exception is org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: [com.aztecsoft.obopay.crm.entity.MemberDevices#com.aztecsoft.obopay.crm.entity.MemberDevicesId@66408d]
Caused by: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: [com.aztecsoft.obopay.crm.entity.MemberDevices#com.aztecsoft.obopay.crm.entity.MemberDevicesId@66408d]
at org.hibernate.engine.StatefulPersistenceContext.checkUniqueness(StatefulPersistenceContext.java:578)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performUpdate(DefaultSaveOrUpdateEventListener.java:284)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:223)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:89)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1202)
at $Proxy135.saveOrUpdate(Unknown Source)
at com.aztecsoft.obopay.crm.dao.hibernate.CustomerDAOHibernate$11.doInHibernate(CustomerDAOHibernate.java:3354)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
at com.aztecsoft.obopay.crm.dao.hibernate.CustomerDAOHibernate.acceptChanges(CustomerDAOHibernate.java:3389)
at com.aztecsoft.obopay.crm.manager.impl.CustomerManagerImpl.saveAcceptChanges(CustomerManagerImpl.java:137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy129.saveAcceptChanges(Unknown Source)
at com.aztecsoft.obopay.crm.controller.member.AcceptEditChangesController.onSubmit(AcceptEditChangesController.java:48)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)
at org.springframework.web.servlet.mvc.AbstractFormController.handleInvalidSubmit(AbstractFormController.java:656)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:257)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:857)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:475)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:440)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6987)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
when setting showsql=true the hibernate statements
[quote]
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankuserac0_.CUSTOMER_ID as CUSTOMER2_1_, bankuserac0_.USER_ID as USER1_1_, bankuserac0_.MODIFIED_DATE as MODIFIED3_1_, bankuserac0_.USER_ID as USER1_6_0_, bankuserac0_.CUSTOMER_ID as CUSTOMER2_6_0_, bankuserac0_.MODIFIED_DATE as MODIFIED3_6_0_, bankuserac0_.BANK_ID as BANK4_6_0_, bankuserac0_.MEMBER_ID as MEMBER5_6_0_, bankuserac0_.STATUS_FROM as STATUS6_6_0_, bankuserac0_.STATUS_TO as STATUS7_6_0_, bankuserac0_.COMMENTS as COMMENTS6_0_, bankuserac0_.FIRST_NAME as FIRST9_6_0_, bankuserac0_.LAST_NAME as LAST10_6_0_, bankuserac0_.MOBILE_NUMBER as MOBILE11_6_0_, bankuserac0_.EMAIL_ID as EMAIL12_6_0_, bankuserac0_.REFERENCE_ID as REFERENCE13_6_0_ from BANK_USER_ACTIVITY bankuserac0_ where bankuserac0_.CUSTOMER_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as EXCEPTION39_5_0_ from BANK_TEMP_UPLOAD_CUSTOMER bankcustom0_ where bankcustom0_.FILE_ID=?
Hibernate: select bankuserac0_.CUSTOMER_ID as CUSTOMER2_1_, bankuserac0_.USER_ID as USER1_1_, bankuserac0_.MODIFIED_DATE as MODIFIED3_1_, bankuserac0_.USER_ID as USER1_6_0_, bankuserac0_.CUSTOMER_ID as CUSTOMER2_6_0_, bankuserac0_.MODIFIED_DATE as MODIFIED3_6_0_, bankuserac0_.BANK_ID as BANK4_6_0_, bankuserac0_.MEMBER_ID as MEMBER5_6_0_, bankuserac0_.STATUS_FROM as STATUS6_6_0_, bankuserac0_.STATUS_TO as STATUS7_6_0_, bankuserac0_.COMMENTS as COMMENTS6_0_, bankuserac0_.FIRST_NAME as FIRST9_6_0_, bankuserac0_.LAST_NAME as LAST10_6_0_, bankuserac0_.MOBILE_NUMBER as MOBILE11_6_0_, bankuserac0_.EMAIL_ID as EMAIL12_6_0_, bankuserac0_.REFERENCE_ID as REFERENCE13_6_0_ from BANK_USER_ACTIVITY bankuserac0_ where bankuserac0_.CUSTOMER_ID=?
Hibernate: select bankcustom0_.FILE_ID as FILE3_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_1_, bankcustom0_.CUSTOMER_ID as CUSTOMER1_5_0_, bankcustom0_.MAKER_ID as MAKER2_5_0_, bankcustom0_.FILE_ID as FILE3_5_0_, bankcustom0_.CHECKER_ID as CHECKER4_5_0_, bankcustom0_.BANK_ID as BANK5_5_0_, bankcustom0_.REFERENCE_ID as REFERENCE6_5_0_, bankcustom0_.MICR_CODE as MICR7_5_0_, bankcustom0_.FIRST_NAME as FIRST8_5_0_, bankcustom0_.MIDDLE_NAME as MIDDLE9_5_0_, bankcustom0_.MOBILE_NUMBER as MOBILE10_5_0_, bankcustom0_.EMAIL_ID as EMAIL11_5_0_, bankcustom0_.CLASS_OF_USER as CLASS12_5_0_, bankcustom0_.TYPE_OF_ACCOUNT as TYPE13_5_0_, bankcustom0_.ADDRESS as ADDRESS5_0_, bankcustom0_.PIN_CODE as PIN15_5_0_, bankcustom0_.PHONE as PHONE5_0_, bankcustom0_.FAX as FAX5_0_, bankcustom0_.MAKER_TIMESTAMP as MAKER18_5_0_, bankcustom0_.CHECKER_TIMESTAMP as CHECKER19_5_0_, bankcustom0_.STATUS as STATUS5_0_, bankcustom0_.MODIFIED_DATE as MODIFIED21_5_0_, bankcustom0_.MODIFIED_BY as MODIFIED22_5_0_, bankcustom0_.LAST_NAME as LAST23_5_0_, bankcustom0_.ADDRESS_TYPE as ADDRESS24_5_0_, bankcustom0_.CITY as CITY5_0_, bankcustom0_.STATE as STATE5_0_, bankcustom0_.COUNTRY as COUNTRY5_0_, bankcustom0_.BANK_CUSTOMERREF_ID as BANK28_5_0_, bankcustom0_.PANCARD_NUMBER as PANCARD29_5_0_, bankcustom0_.DATE_OF_BIRTH as DATE30_5_0_, bankcustom0_.BANK_ACCOUNT_NUMBER as BANK31_5_0_, bankcustom0_.REF_ONE as REF32_5_0_, bankcustom0_.REF_TWO as REF33_5_0_, bankcustom0_.REF_THREE as REF34_5_0_, bankcustom0_.ERROR_CODES as ERROR35_5_0_, bankcustom0_.UPLOAD_STATUS as UPLOAD36_5_0_, bankcustom0_.MODIFICATION_FLAG as MODIFIC37_5_0_, bankcustom0_.MEMBER_ID as MEMBER38_5_0_, bankcustom0_.EXCEPTION_ACTION_TAKEN as
Login
FAQ
Search
