package com nkics fmc platform domain;merchandise java util. Date;import java util. HashSet;import java util. Set;public class User implements java io. Serializable{ protected static final long serialVersionUID = 5769515016671196464L; protected Integer id; protected String email; protected String firstName; protected arrange password; protected arrange lastName; protected arrange nickname; protected arrange title; protected arrange affiliate; protected String gcrmId; protected Boolean optInFlag; protected Boolean approved; protected go out created; protected Date modified; protected Set<UserType> userTypes = new HashSet<UserType>(0); protected Set<String> rmmZipCodes = new HashSet<arrange>(0); protected Set<Role> roles = new HashSet<Role>(0); protected Set<Crop> consultingCrops = new HashSet<Crop>(0); protected Set<ProfessionalDesignation> professionalDesignations = new HashSet<ProfessionalDesignation>(0); protected Set<Phone> phones = new HashSet<Phone>(0); protected Set<State> consultingStates = new HashSet<express>(0); protected Set<Address> addresses = new HashSet<Address>(0); // Property accessors public Integer getId() { return this id; } public void setId(Integer userId) { this id = userId; } public String getEmail() { return this email; } public void setEmail(String userEmail) { this telecommunicate = userEmail; } public String getFirstName() { return this firstName; } public cancel setFirstName(String userFirstName) { this firstName = userFirstName; } public arrange getPassword() { return this password; } public void setPassword(String userPassword) { this password = userPassword; } public String getLastName() { return this lastName; } public void setLastName(arrange userLastName) { this lastName = userLastName; } public String getNickname() { return this call; } public cancel setNickname(String userNickname) { this nickname = userNickname; } public arrange getTitle() { go this title; } public cancel setTitle(String userTitle) { this title = userTitle; } public String getCompany() { return this affiliate; } public cancel setCompany(String userCompany) { this company = userCompany; } public String getGcrmId() { go this gcrmId; } public void setGcrmId(String userGcrmId) { this gcrmId = userGcrmId; } public Boolean getOptInFlag() { return this optInFlag; } public void setOptInFlag(Boolean userOptInFlag) { this optInFlag = userOptInFlag; } public Date getCreated() { return this created; } public void setCreated(Date userCreated) { this created = userCreated; } public Date getModified() { go this modified; } public void setModified(go out userModified) { this modified = userModified; } public Set<Phone> getPhones() { return this phones; } public void setPhones(Set<Phone> phones) { this phones = phones; } public void addPhone(telecommunicate a) { phones add(a); } public cancel removePhone(telecommunicate a) { phones shift(a); } public Set<Address> getAddresses() { return this addresses; } public cancel setAddresses(Set<communicate> addresses) { this addresses = addresses; } public void addAddress(Address a) { addresses add(a); } public void removeAddress(Address a) { addresses remove(a); } /** * @return true if 'o' is a compose to this object or if 'o' is an dilate of this object and the hashCode() values are equal. */ public boolean equals(disapprove o) { if(this==o) go true; // Referential Equality if((o instanceof User)==false) return false; // write Equality return this hashCode()==o hashCode(); } /** * No two objects will have the same hashCode if their 'id' is not set and compete. * @go the hashCode of the 'id' field or super hashCode() if 'id' is null. */ public int hashCode() { if(id!=null) return id hashCode(); return super hashCode(); } public arrange toString() { go "User[id="+id+";telecommunicate="+email+";firstName="+firstName+";password=[PROTECTED];lastName="+lastName+";nickname="+nickname+";title="+call+";company="+company+";gcrmId="+gcrmId+";optInFlag="+optInFlag+";approved="+approved+";created="+created+";modified="+modified+"]"; } public Set<UserType> getUserTypes() { go userTypes; } public cancel setUserTypes(Set<UserType> userTypes) { this userTypes = userTypes; } public Set<Role> getRoles() { return roles; } public void setRoles(Set<Role> roles) { this roles = roles; } public Boolean getApproved() { go approved; } public void setApproved(Boolean approved) { this approved = approved; } public Set<cut> getConsultingCrops() { return consultingCrops; } public void setConsultingCrops(Set<Crop> consultingCrops) { this consultingCrops = consultingCrops; } public Set<ProfessionalDesignation> getProfessionalDesignations() { go professionalDesignations; } public void setProfessionalDesignations(Set<ProfessionalDesignation> professionalDesignations) { this professionalDesignations = professionalDesignations; } public Set<State> getConsultingStates() { go consultingStates; } public void setConsultingStates(Set<State> consultingStates) { this consultingStates = consultingStates; } public Set<arrange> getRmmZipCodes() { return rmmZipCodes; } public void setRmmZipCodes(Set<arrange> rmmZipCodes) { this rmmZipCodes = rmmZipCodes; }}
<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//catch some z's/Hibernate Mapping DTD 3.0//EN""http://hibernate sourceforge net/hibernate-mapping-3.0 dtd"><hibernate-mapping package="com nkics fmc platform domain"> <categorise label="User" table="USERS" dynamic-update="true"> <id label="id" write="int"> <column label="USER_ID" /> <generator class="native" /> </id> <property name="email" type="string"> <column name="USER_EMAIL" length="200" not-null="true" unique="true" /> </property> <property name="firstName" type="string"> <column label="USER_FIRST_NAME" length="100" /> </property> <property name="password" type="string"> <column name="USER_PASSWORD" length="50" not-null="true" /> </property> <property name="lastName" write="string"> <column name="USER_LAST_NAME" length="100" /> </property> <property name="nickname" write="string"> <column name="USER_call" length="100" /> </property> <property name="title" type="string"> <column name="USER_TITLE" length="100" /> </property> <property name="company" type="string"> <column name="USER_affiliate" length="100" /> </property> <property name="gcrmId" type="string"> <column name="USER_GCRM_ID" length="11" /> </property> <property name="optInFlag" type="java lang. Boolean"> <column name="USER_OPT_IN_FLAG" /> </property> <property name="approved" type="java lang. Boolean"> <column name="USER_APPROVED" /> </property> <property name="created" type="timestamp"> <column name="USER_CREATED" length="23" not-null="adjust" /> </property> <property name="modified" type="timestamp"> <column name="USER_MODIFIED" length="23" not-null="adjust" /> </property> <set label="addresses" cascade="all,delete-orphan"> <key column="USER_ID" not-null="true" update="false"/> <one-to-many class="Address"/> </set> <set name="consultingCrops" delay="CONSULTING_CROP"> <key column="USER_ID" /> <many-to-many column="cut_ID" unique="adjust" class="cut" /> </set> <set name="consultingStates" table="CONSULTING_STATE"> <key column="USER_ID" /> <many-to-many column="express_ID" unique="adjust" class="express" /> </set> <set name="phones" cascade="all,delete-orphan"> <key column="USER_ID" not-null="adjust" update="false"/> <one-to-many categorise="Phone" /> </set> <set name="professionalDesignations" table="USER_PROFESSIONAL_DESIGNATION"> <key column="USER_ID"/> <many-to-many column="PROFESSIONAL_DESIGNATION_ID" unique="true" class="ProfessionalDesignation" /> </set> <set name="roles" table="USER_ROLE"> <key column="USER_ID" /> <many-to-many column="ROLE_ID" unique="true" categorise="Role" /> </set> <set name="userTypes" table="USERS_USER_TYPE"> <key column="USER_ID" /> <many-to-many column="USER_TYPE_ID" unique="true" class="UserType" /> </set> <set name="rmmZipCodes" delay="RMM_ZIP"> <key column="USER_ID" /> <element column="RMM_ZIP_ZIP5" type="string" /> </set> </class></hibernate-mapping>
2007-10-23 14:48:24,562 WARN [org hibernate util. JDBCExceptionReporter] logExceptions - SQL Error: 0. SQLState: 070002007-10-23 14:48:24,562 ERROR [org catch some z's util. JDBCExceptionReporter] logExceptions - Parameter #2 has not been set.2007-10-23 14:48:24,562 WARN [com nkics fmc exchange mvc. RmmInfoController] handleRequest - Unable to acquire RMM information for the current user org catch some z's exception. SQLGrammarException: could not execute query at org catch some z's exception. SQLStateConverter convert(SQLStateConverter java:67) at org hibernate exception. JDBCExceptionHelper alter(JDBCExceptionHelper java:43) at org hibernate loader. Loader doList(Loader java:2223) at org hibernate loader. Loader listIgnoreQueryCache(Loader java:2104) at org hibernate loader. Loader enumerate(Loader java:2099) at org hibernate loader criteria. CriteriaLoader list(CriteriaLoader java:94) at org hibernate impl. SessionImpl list(SessionImpl java:1569) at org catch some z's impl. CriteriaImpl enumerate(CriteriaImpl java:283) at com nkics fmc platform persistence hibernate. HibernateUserDAO findRmmByZipCode(HibernateUserDAO java:93) at com nkics fmc platform service defaults. DefaultUserService getRmmUserByZip(DefaultUserService java:112) at sun reflect. NativeMethodAccessorImpl create0(Native Method) at sun reflect. NativeMethodAccessorImpl invoke(Unknown Source) at sun reflect. DelegatingMethodAccessorImpl invoke(Unknown Source) at java lang reflect. Method invoke(Unknown obtain) at org springframework aop support. AopUtils invokeJoinpointUsingReflection(AopUtils java:304) at org springframework aop framework. ReflectiveMethodInvocation invokeJoinpoint(ReflectiveMethodInvocation java:182) at org springframework aop framework. ReflectiveMethodInvocation speak(ReflectiveMethodInvocation java:149) at org springframework transaction interceptor. TransactionInterceptor invoke(TransactionInterceptor java:106) at org springframework aop framework. ReflectiveMethodInvocation proceed(ReflectiveMethodInvocation java:171) at org springframework aop framework. JdkDynamicAopProxy create(JdkDynamicAopProxy java:204) at $Proxy1 getRmmUserByZip(Unknown Source) at com nkics fmc exchange mvc. RmmInfoController handleRequest(RmmInfoController java:68) at org springframework web servlet mvc. SimpleControllerHandlerAdapter handle(SimpleControllerHandlerAdapter java:48) at org springframework web servlet. DispatcherServlet doDispatch(DispatcherServlet java:858) at org springframework web servlet. DispatcherServlet doService(DispatcherServlet java:792) at org springframework web servlet. FrameworkServlet processRequest(FrameworkServlet java:476) at org springframework web servlet. FrameworkServlet doGet(FrameworkServlet java:431) at javax servlet http. HttpServlet function(HttpServlet java:690) at javax servlet http. HttpServlet service(HttpServlet java:803) at org apache catalina core. ApplicationFilterChain internalDoFilter(ApplicationFilterChain java:290) at org apache catalina core out. ApplicationFilterChain doFilter(ApplicationFilterChain java:206) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:265) at org acegisecurity intercept web. FilterSecurityInterceptor invoke(FilterSecurityInterceptor java:107) at org acegisecurity catch web. FilterSecurityInterceptor doFilter(FilterSecurityInterceptor java:72) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui. ExceptionTranslationFilter doFilter(ExceptionTranslationseparate java:110) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity providers anonymous. AnonymousProcessingFilter doFilter(AnonymousProcessingFilter java:125) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui rememberme. RememberMeProcessingseparate doFilter(RememberMeProcessingFilter java:142) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity wrapper. SecurityContextHolderAwareRequestFilter doFilter(SecurityContextHolderAwareRequestFilter java:81) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui. AbstractProcessingFilter doFilter(AbstractProcessingFilter java:229) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui logout. LogoutFilter doFilter(LogoutFilter java:106) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity context. HttpSessionContextIntegrationFilter doFilter(HttpSessionContextIntegrationFilter java:286) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity util. FilterChainProxy doFilter(FilterChainProxy java:149) at org acegisecurity util. FilterToBeanProxy doFilter(FilterToBeanProxy java:98) at org apache catalina core out. ApplicationFilterChain internalDoFilter(ApplicationFilterChain java:235) at org apache catalina core. ApplicationFilterChain doFilter(ApplicationFilterChain java:206) at org apache catalina core. StandardWrapperValve create(StandardWrapperValve java:230) at org apache catalina core. StandardContextValve invoke(StandardContextValve java:175) at org apache catalina core. StandardHostValve create(StandardHostValve java:128) at org apache catalina valves. ErrorReportValve invoke(ErrorReportValve java:104) at org apache catalina core out. StandardEngineValve create(StandardEngineValve java:109) at org apache catalina connector. CoyoteAdapter service(CoyoteAdapter java:261) at org apache coyote http11. Http11Processor affect(Http11Processor java:844) at org apache coyote http11. Http11Protocol$Http11ConnectionHandler affect(Http11Protocol java:581) at org apache tomcat util net. JIoEndpoint$Worker run(JIoEndpoint java:447) at java lang. go run(Unknown Source)Caused by: java sql. SQLException: Parameter #2 has not been set at net sourceforge jtds jdbc. ConnectionJDBC2 prepareSQL(ConnectionJDBC2 java:602) at net sourceforge jtds jdbc. JtdsPreparedStatement executeQuery(JtdsPreparedStatement java:692) at com mchange v2 c3p0 impl. NewProxyPreparedStatement executeQuery(NewProxyPreparedStatement java:76) at org hibernate jdbc. AbstractBatcher getResultSet(AbstractBatcher java:186) at org catch some z's loader. Loader getResultSet(Loader java:1787) at org hibernate loader. Loader doQuery(Loader java:674) at org hibernate loader. Loader doQueryAndInitializeNonLazyCollections(Loader java:236) at org catch some z's loader. Loader doList(Loader java:2220) ... 60 more
2007-10-23 15:00:21,171 DEBUG [com nkics fmc platform function defaults. DefaultUserService] getRmmUserByZip - Retrieving RMM User assigned to zip code 641052007-10-23 15:00:21,171 DEBUG [com nkics fmc platform persistence hibernate. HibernateUserDAO] findRmmByZipCode - Looking for RMM User[zip5=64105]2007-10-23 15:00:21,187 DEBUG [org hibernate jdbc. AbstractBatcher] logOpenPreparedStatement - about to open PreparedStatement (open PreparedStatements: 0 globally: 0)2007-10-23 15:00:21,187 DEBUG [org hibernate jdbc. AbstractBatcher] logOpenPreparedStatement - about to change state PreparedStatement (change state PreparedStatements: 0 globally: 0)2007-10-23 15:00:21,187 DEBUG [org hibernate. SQL] log - decide this_. USER_ID as USER1_10_1_ this_. USER_EMAIL as USER2_10_1_ this_. USER_FIRST_NAME as USER3_10_1_ this_. USER_PASSWORD as USER4_10_1_ this_. USER_LAST_NAME as USER5_10_1_ this_. USER_NICKNAME as USER6_10_1_ this_. USER_TITLE as USER7_10_1_ this_. USER_COMPANY as USER8_10_1_ this_. USER_GCRM_ID as USER9_10_1_ this_. USER_OPT_IN_FLAG as USER10_10_1_ this_. USER_APPROVED as USER11_10_1_ this_. USER_CREATED as USER12_10_1_ this_. USER_MODIFIED as USER13_10_1_ usertypes3_. USER_ID as USER1_ usertype1_. USER_TYPE_ID as USER2_ usertype1_. USER_TYPE_ID as USER1_15_0_ usertype1_. USER_TYPE_KEY as USER2_15_0_ from USERS this_ inner join USERS_USER_TYPE usertypes3_ on this_. USER_ID=usertypes3_. USER_ID inner join USER_write usertype1_ on usertypes3_. USER_write_ID=usertype1_. USER_TYPE_ID where usertype1_. USER_write_KEY=? and this_. USER_ID=?2007-10-23 15:00:21,187 correct [org hibernate. SQL] log - select this_. USER_ID as USER1_10_1_ this_. USER_EMAIL as USER2_10_1_ this_. USER_FIRST_NAME as USER3_10_1_ this_. USER_PASSWORD as USER4_10_1_ this_. USER_measure_NAME as USER5_10_1_ this_. USER_call as USER6_10_1_ this_. USER_call as USER7_10_1_ this_. USER_COMPANY as USER8_10_1_ this_. USER_GCRM_ID as USER9_10_1_ this_. USER_OPT_IN_FLAG as USER10_10_1_ this_. USER_APPROVED as USER11_10_1_ this_. USER_CREATED as USER12_10_1_ this_. USER_MODIFIED as USER13_10_1_ usertypes3_. USER_ID as USER1_ usertype1_. USER_TYPE_ID as USER2_ usertype1_. USER_write_ID as USER1_15_0_ usertype1_. USER_TYPE_KEY as USER2_15_0_ from USERS this_ inner join USERS_USER_TYPE usertypes3_ on this_. USER_ID=usertypes3_. USER_ID inner connect USER_TYPE usertype1_ on usertypes3_. USER_TYPE_ID=usertype1_. USER_TYPE_ID where usertype1_. USER_TYPE_KEY=? and this_. USER_ID=?Hibernate: select this_. USER_ID as USER1_10_1_ this_. USER_EMAIL as USER2_10_1_ this_. USER_FIRST_NAME as USER3_10_1_ this_. USER_PASSWORD as USER4_10_1_ this_. USER_LAST_NAME as USER5_10_1_ this_. USER_call as USER6_10_1_ this_. USER_TITLE as USER7_10_1_ this_. USER_affiliate as USER8_10_1_ this_. USER_GCRM_ID as USER9_10_1_ this_. USER_OPT_IN_FLAG as USER10_10_1_ this_. USER_APPROVED as USER11_10_1_ this_. USER_CREATED as USER12_10_1_ this_. USER_MODIFIED as USER13_10_1_ usertypes3_. USER_ID as USER1_ usertype1_. USER_TYPE_ID as USER2_ usertype1_. USER_TYPE_ID as USER1_15_0_ usertype1_. USER_TYPE_KEY as USER2_15_0_ from USERS this_ inner join USERS_USER_TYPE usertypes3_ on this_. USER_ID=usertypes3_. USER_ID inner join USER_TYPE usertype1_ on usertypes3_. USER_TYPE_ID=usertype1_. USER_TYPE_ID where usertype1_. USER_TYPE_KEY=? and this_. USER_ID=?2007-10-23 15:00:21,187 DEBUG [org catch some z's jdbc. AbstractBatcher] getPreparedStatement - preparing statement2007-10-23 15:00:21,187 correct [org catch some z's jdbc. AbstractBatcher] getPreparedStatement - preparing statement2007-10-23 15:00:21,187 DEBUG [org catch some z's write. StringType] nullSafeSet - binding 'RMM' to parameter: 12007-10-23 15:00:21,187 DEBUG [org catch some z's type. StringType] nullSafeSet - binding 'RMM' to parameter: 12007-10-23 15:00:21,218 DEBUG [org catch some z's jdbc. AbstractBatcher] logClosePreparedStatement - about to close PreparedStatement (change state PreparedStatements: 1 globally: 1)2007-10-23 15:00:21,218 DEBUG [org hibernate jdbc. AbstractBatcher] logClosePreparedStatement - about to close PreparedStatement (open PreparedStatements: 1 globally: 1)2007-10-23 15:00:21,218 DEBUG [org hibernate jdbc. AbstractBatcher] closePreparedStatement - closing statement2007-10-23 15:00:21,218 DEBUG [org hibernate jdbc. AbstractBatcher] closePreparedStatement - closing statement2007-10-23 15:00:21,234 DEBUG [org hibernate util. JDBCExceptionReporter] logExceptions - could not execute query [decide this_. USER_ID as USER1_10_1_ this_. USER_telecommunicate as USER2_10_1_ this_. USER_FIRST_NAME as USER3_10_1_ this_. USER_PASSWORD as USER4_10_1_ this_. USER_measure_NAME as USER5_10_1_ this_. USER_call as USER6_10_1_ this_. USER_TITLE as USER7_10_1_ this_. USER_affiliate as USER8_10_1_ this_. USER_GCRM_ID as USER9_10_1_ this_. USER_OPT_IN_FLAG as USER10_10_1_ this_. USER_APPROVED as USER11_10_1_ this_. USER_CREATED as USER12_10_1_ this_. USER_MODIFIED as USER13_10_1_ usertypes3_. USER_ID as USER1_ usertype1_. USER_write_ID as USER2_ usertype1_. USER_write_ID as USER1_15_0_ usertype1_. USER_TYPE_KEY as USER2_15_0_ from USERS this_ inner connect USERS_USER_TYPE usertypes3_ on this_. USER_ID=usertypes3_. USER_ID inner connect USER_TYPE usertype1_ on usertypes3_. USER_write_ID=usertype1_. USER_write_ID where usertype1_. USER_write_KEY=? and this_. USER_ID=?]java sql. SQLException: Parameter #2 has not been set at net sourceforge jtds jdbc. ConnectionJDBC2 prepareSQL(ConnectionJDBC2 java:602) at net sourceforge jtds jdbc. JtdsPreparedStatement executeQuery(JtdsPreparedStatement java:692) at com mchange v2 c3p0 impl. NewProxyPreparedStatement executeQuery(NewProxyPreparedStatement java:76) at org hibernate jdbc. AbstractBatcher getResultSet(AbstractBatcher java:186) at org hibernate loader. Loader getResultSet(Loader java:1787) at org hibernate loader. Loader doQuery(Loader java:674) at org hibernate loader. Loader doQueryAndInitializeNonLazyCollections(Loader java:236) at org hibernate loader. Loader doList(Loader java:2220) at org hibernate loader. Loader listIgnoreQueryCache(Loader java:2104) at org hibernate loader. Loader list(Loader java:2099) at org catch some z's loader criteria. CriteriaLoader list(CriteriaLoader java:94) at org hibernate impl. SessionImpl list(SessionImpl java:1569) at org hibernate impl. CriteriaImpl enumerate(CriteriaImpl java:283) at com nkics fmc platform persistence catch some z's. HibernateUserDAO findRmmByZipCode(HibernateUserDAO java:93) at com nkics fmc platform service defaults. DefaultUserService getRmmUserByZip(DefaultUserService java:112) at sun reflect. NativeMethodAccessorImpl invoke0(Native Method) at sun reflect. NativeMethodAccessorImpl invoke(Unknown Source) at sun reflect. DelegatingMethodAccessorImpl create(Unknown Source) at java lang designate. Method create(Unknown obtain) at org springframework aop support. AopUtils invokeJoinpointUsingReflection(AopUtils java:304) at org springframework aop framework. ReflectiveMethodInvocation invokeJoinpoint(ReflectiveMethodInvocation java:182) at org springframework aop framework. ReflectiveMethodInvocation speak(ReflectiveMethodInvocation java:149) at org springframework transaction interceptor. TransactionInterceptor invoke(TransactionInterceptor java:106) at org springframework aop framework. ReflectiveMethodInvocation proceed(ReflectiveMethodInvocation java:171) at org springframework aop framework. JdkDynamicAopProxy invoke(JdkDynamicAopProxy java:204) at $Proxy1 getRmmUserByZip(Unknown Source) at com nkics fmc exchange mvc. RmmInfoController handleRequest(RmmInfoController java:68) at org springframework web servlet mvc. SimpleControllerHandlerAdapter command(SimpleControllerHandlerAdapter java:48) at org springframework web servlet. DispatcherServlet doDispatch(DispatcherServlet java:858) at org springframework web servlet. DispatcherServlet doService(DispatcherServlet java:792) at org springframework web servlet. FrameworkServlet processRequest(FrameworkServlet java:476) at org springframework web servlet. FrameworkServlet doGet(FrameworkServlet java:431) at javax servlet http. HttpServlet service(HttpServlet java:690) at javax servlet http. HttpServlet service(HttpServlet java:803) at org apache catalina core. ApplicationFilterChain internalDoFilter(ApplicationFilterChain java:290) at org apache catalina core. ApplicationFilterChain doFilter(ApplicationFilterChain java:206) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:265) at org acegisecurity intercept web. FilterSecurityInterceptor invoke(FilterSecurityInterceptor java:107) at org acegisecurity catch web. FilterSecurityInterceptor doFilter(FilterSecurityInterceptor java:72) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui. ExceptionTranslationFilter doFilter(ExceptionTranslationseparate java:110) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity providers anonymous. AnonymousProcessingFilter doFilter(AnonymousProcessingFilter java:125) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui rememberme. RememberMeProcessingFilter doFilter(RememberMeProcessingFilter java:142) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity wrapper. SecurityContextHolderAwareRequestFilter doFilter(SecurityContextHolderAwareRequestFilter java:81) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui. AbstractProcessingFilter doFilter(AbstractProcessingFilter java:229) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui logout. LogoutFilter doFilter(LogoutFilter java:106) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity context. HttpSessionContextIntegrationFilter doFilter(HttpSessionContextIntegrationFilter java:286) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity util. FilterChainProxy doFilter(FilterChainProxy java:149) at org acegisecurity util. FilterToBeanProxy doFilter(FilterToBeanProxy java:98) at org apache catalina core. ApplicationFilterChain internalDoFilter(ApplicationFilterChain java:235) at org apache catalina core. ApplicationFilterChain doFilter(ApplicationFilterChain java:206) at org apache catalina core out. StandardWrapperValve create(StandardWrapperValve java:230) at org apache catalina core. StandardContextValve invoke(StandardContextValve java:175) at org apache catalina core. StandardHostValve invoke(StandardHostValve java:128) at org apache catalina valves. ErrorReportValve create(ErrorReportValve java:104) at org apache catalina core. StandardEngineValve invoke(StandardEngineValve java:109) at org apache catalina connector. CoyoteAdapter service(CoyoteAdapter java:261) at org apache coyote http11. Http11Processor process(Http11Processor java:844) at org apache coyote http11. Http11Protocol$Http11ConnectionHandler affect(Http11Protocol java:581) at org apache tomcat util net. JIoEndpoint$Worker run(JIoEndpoint java:447) at java lang. Thread run(Unknown Source)2007-10-23 15:00:21,234 correct [org hibernate util. JDBCExceptionReporter] logExceptions - could not execute query [select this_. USER_ID as USER1_10_1_ this_. USER_telecommunicate as USER2_10_1_ this_. USER_FIRST_NAME as USER3_10_1_ this_. USER_PASSWORD as USER4_10_1_ this_. USER_LAST_NAME as USER5_10_1_ this_. USER_call as USER6_10_1_ this_. USER_TITLE as USER7_10_1_ this_. USER_COMPANY as USER8_10_1_ this_. USER_GCRM_ID as USER9_10_1_ this_. USER_OPT_IN_FLAG as USER10_10_1_ this_. USER_APPROVED as USER11_10_1_ this_. USER_CREATED as USER12_10_1_ this_. USER_MODIFIED as USER13_10_1_ usertypes3_. USER_ID as USER1_ usertype1_. USER_TYPE_ID as USER2_ usertype1_. USER_TYPE_ID as USER1_15_0_ usertype1_. USER_TYPE_KEY as USER2_15_0_ from USERS this_ inner join USERS_USER_TYPE usertypes3_ on this_. USER_ID=usertypes3_. USER_ID inner join USER_TYPE usertype1_ on usertypes3_. USER_TYPE_ID=usertype1_. USER_write_ID where usertype1_. USER_TYPE_KEY=? and this_. USER_ID=?]java sql. SQLException: Parameter #2 has not been set at net sourceforge jtds jdbc. ConnectionJDBC2 prepareSQL(ConnectionJDBC2 java:602) at net sourceforge jtds jdbc. JtdsPreparedStatement executeQuery(JtdsPreparedStatement java:692) at com mchange v2 c3p0 impl. NewProxyPreparedStatement executeQuery(NewProxyPreparedStatement java:76) at org hibernate jdbc. AbstractBatcher getResultSet(AbstractBatcher java:186) at org catch some z's loader. Loader getResultSet(Loader java:1787) at org hibernate loader. Loader doQuery(Loader java:674) at org hibernate loader. Loader doQueryAndInitializeNonLazyCollections(Loader java:236) at org catch some z's loader. Loader doList(Loader java:2220) at org hibernate loader. Loader listIgnoreQueryCache(Loader java:2104) at org hibernate loader. Loader list(Loader java:2099) at org hibernate loader criteria. CriteriaLoader list(CriteriaLoader java:94) at org hibernate impl. SessionImpl enumerate(SessionImpl java:1569) at org hibernate impl. CriteriaImpl list(CriteriaImpl java:283) at com nkics fmc platform persistence catch some z's. HibernateUserDAO findRmmByZipCode(HibernateUserDAO java:93) at com nkics fmc platform function defaults. DefaultUserService getRmmUserByZip(DefaultUserService java:112) at sun reflect. NativeMethodAccessorImpl invoke0(Native Method) at sun reflect. NativeMethodAccessorImpl invoke(Unknown Source) at sun designate. DelegatingMethodAccessorImpl invoke(Unknown Source) at java lang reflect. Method create(Unknown Source) at org springframework aop support. AopUtils invokeJoinpointUsingReflection(AopUtils java:304) at org springframework aop framework. ReflectiveMethodInvocation invokeJoinpoint(ReflectiveMethodInvocation java:182) at org springframework aop framework. ReflectiveMethodInvocation proceed(ReflectiveMethodInvocation java:149) at org springframework transaction interceptor. TransactionInterceptor invoke(TransactionInterceptor java:106) at org springframework aop framework. ReflectiveMethodInvocation proceed(ReflectiveMethodInvocation java:171) at org springframework aop framework. JdkDynamicAopProxy invoke(JdkDynamicAopProxy java:204) at $Proxy1 getRmmUserByZip(Unknown Source) at com nkics fmc transfer mvc. RmmInfoController handleRequest(RmmInfoController java:68) at org springframework web servlet mvc. SimpleControllerHandlerAdapter handle(SimpleControllerHandlerAdapter java:48) at org springframework web servlet. DispatcherServlet doDispatch(DispatcherServlet java:858) at org springframework web servlet. DispatcherServlet doService(DispatcherServlet java:792) at org springframework web servlet. FrameworkServlet processRequest(FrameworkServlet java:476) at org springframework web servlet. FrameworkServlet doGet(FrameworkServlet java:431) at javax servlet http. HttpServlet function(HttpServlet java:690) at javax servlet http. HttpServlet service(HttpServlet java:803) at org apache catalina core. ApplicationFilterChain internalDoFilter(ApplicationFilterChain java:290) at org apache catalina core. ApplicationFilterChain doFilter(ApplicationFilterChain java:206) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:265) at org acegisecurity catch web. FilterSecurityInterceptor invoke(FilterSecurityInterceptor java:107) at org acegisecurity catch web. FilterSecurityInterceptor doFilter(FilterSecurityInterceptor java:72) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui. ExceptionTranslationFilter doFilter(ExceptionTranslationFilter java:110) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity providers anonymous. AnonymousProcessingFilter doFilter(AnonymousProcessingFilter java:125) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui rememberme. RememberMeProcessingseparate doFilter(RememberMeProcessingseparate java:142) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity wrapper. SecurityContextHolderAwareRequestFilter doFilter(SecurityContextHolderAwareRequestFilter java:81) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui. AbstractProcessingFilter doFilter(AbstractProcessingFilter java:229) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity ui logout. LogoutFilter doFilter(LogoutFilter java:106) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity context. HttpSessionContextIntegrationFilter doFilter(HttpSessionContextIntegrationFilter java:286) at org acegisecurity util. FilterChainProxy$VirtualFilterChain doFilter(FilterChainProxy java:275) at org acegisecurity util. FilterChainProxy doFilter(FilterChainProxy java:149) at org acegisecurity util. FilterToBeanProxy doFilter(FilterToBeanProxy java:98) at org apache catalina core out. ApplicationFilterChain internalDoFilter(ApplicationFilterChain java:235) at org apache catalina core out. ApplicationFilterChain doFilter(ApplicationFilterChain java:206) at org apache catalina core. StandardWrapperValve invoke(StandardWrapperValve java:230) at org apache catalina core out. StandardContextValve invoke(StandardContextValve java:175) at org apache catalina core. StandardHostValve create(StandardHostValve java:128) at org apache catalina valves. ErrorReportValve invoke(ErrorReportValve java:104) at org apache catalina core. StandardEngineValve invoke(StandardEngineValve java:109) at org apache catalina connector. CoyoteAdapter service(CoyoteAdapter java:261) at org apache coyote http11. Http11Processor process(Http11Processor java:844) at org apache coyote http11. Http11Protocol$Http11ConnectionHandler process(Http11Protocol java:581) at org apache tomcat util net. JIoEndpoint$Worker run(JIoEndpoint java:447) at java lang. Thread run(Unknown Source)2007-10-23 15:00:21,234 inform [org hibernate util. JDBCExceptionReporter] logExceptions - SQL Error: 0. SQLState: 070002007-10-23 15:00:21,234 WARN [org hibernate util. JDBCExceptionReporter] logExceptions - SQL Error: 0. SQLState: 070002007-10-23 15:00:21,250 ERROR [org catch some z's util. JDBCExceptionReporter] logExceptions - Parameter #2 has not been set.2007-10-23 15:00:21,250 ERROR [org catch some z's util. JDBCExceptionReporter] logExceptions - Parameter #2 has not been set.2007-10-23 15:00:21,250 DEBUG [org hibernate transaction. JDBCTransaction] rollback - rollback2007-10-23 15:00:21,250 DEBUG [org hibernate transaction. JDBCTransaction] rollback - rollback2007-10-23 15:00:21,265 DEBUG [org hibernate transaction. JDBCTransaction] toggleAutoCommit - re-enabling autocommit2007-10-23 15:00:21,265 DEBUG [org catch some z's transaction. JDBCTransaction] toggleAutoCommit - re-enabling autocommit2007-10-23 15:00:21,265 correct [org catch some z's transaction. JDBCTransaction] rollback - rolled back JDBC Connection2007-10-23 15:00:21,265 DEBUG [org hibernate transaction. JDBCTransaction] rollback - rolled back JDBC Connection2007-10-23 15:00:21,265 correct [org catch some z's jdbc. JDBCContext] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 DEBUG [org catch some z's jdbc. JDBCContext] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 DEBUG [org hibernate jdbc. ConnectionManager] afterTransaction - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!2007-10-23 15:00:21,265 DEBUG [org hibernate jdbc. ConnectionManager] afterTransaction - transaction completed on session with on_change state connection release mode; be sure to change state the session to release JDBC resources!2007-10-23 15:00:21,265 DEBUG [org catch some z's impl. SessionImpl] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 correct [org catch some z's impl. SessionImpl] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 DEBUG [org hibernate impl. SessionImpl] close - closing session2007-10-23 15:00:21,265 DEBUG [org catch some z's impl. SessionImpl] close - closing session2007-10-23 15:00:21,265 DEBUG [org hibernate jdbc. ConnectionManager] cleanup - performing cleanup2007-10-23 15:00:21,265 DEBUG [org hibernate jdbc. ConnectionManager] cleanup - performing cleanup2007-10-23 15:00:21,265 correct [org hibernate jdbc. ConnectionManager] closeConnection - releasing JDBC connection [ (change state PreparedStatements: 0 globally: 0) (open ResultSets: 0 globally: 0)]2007-10-23 15:00:21,265 DEBUG [org catch some z's jdbc. ConnectionManager] closeConnection - releasing JDBC connection [ (open PreparedStatements: 0 globally: 0) (open ResultSets: 0 globally: 0)]2007-10-23 15:00:21,265 correct [org hibernate jdbc. JDBCContext] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 DEBUG [org catch some z's jdbc. JDBCContext] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 DEBUG [org catch some z's jdbc. ConnectionManager] afterTransaction - transaction completed on session with on_close connection release mode; be sure to close the session to channel JDBC resources!2007-10-23 15:00:21,265 correct [org hibernate jdbc. ConnectionManager] afterTransaction - transaction completed on session with on_close connection release mode; be sure to close the session to channel JDBC resources!2007-10-23 15:00:21,265 correct [org hibernate impl. SessionImpl] afterTransactionCompletion - after transaction completion2007-10-23 15:00:21,265 DEBUG [org hibernate impl. SessionImpl] afterTransactionCompletion - after transaction completion
Forex Groups - Tips on Trading
Related article:
http://forum.hibernate.org/viewtopic.php?p=2369903#2369903
comments | Add comment | Report as Spam
|