I didn't do any changes in UserDaoHibernate or UserManagerImpl. I do some
changes in user.hbm file and user.java file .I am sending my user.hbm file
to you....
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd";>
<hibernate-mapping
>
<class name="org.appfuse.model.User"
table="user">
<id
name="username"
column="user_name"
length="20"
unsaved-value="version"
>
<!-- The generator-class attribute of @hibernate.id is deprecated, use
the @hibernate.generator tag instead -->
<generator class="assigned">
</generator>
</id>
<version
name="version"
column="version"
type="java.lang.Integer"
/>
<property
name="password"
column="password"
not-null="true"
>
</property>
<property
name="firstName"
column="first_name"
length="50"
not-null="true"
>
</property>
<property
name="lastName"
column="last_name"
length="50"
not-null="true"
>
</property>
<property
name="email"
column="email"
not-null="true"
unique="true"
>
</property>
<property
name="passwordHint"
column="password_hint"
not-null="false"
>
</property>
<set
name="roles"
table="user_role"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.Role"
column="role_name"
outer-join="auto"
/>
</set>
<set
name="auditPeriods"
table="user_audit_period"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.AuditPeriod"
column="A_P_ID"
outer-join="auto"
/>
</set>
<set
name="auditTypes"
table="user_audit_type"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.AuditType"
column="A_T_ID"
outer-join="auto"
/>
</set>
<set
name="auditQuarters"
table="user_audit_quarter"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.AuditQuarter"
column="A_Q_ID"
outer-join="auto"
/>
</set>
<set
name="belongTos"
table="user_belong_to"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.BelongTo"
column="B_T_ID"
outer-join="auto"
/>
</set>
<set
name="businessUnits"
table="user_business_unit"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.BusinessUnit"
column="BUSINESS_ID"
outer-join="auto"
/>
</set>
<set
name="circles"
table="user_circle"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.Circle"
column="CIRCLE_ID"
outer-join="auto"
/>
</set>
<set
name="domains"
table="user_domain"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.Domain"
column="DOMAIN_ID"
outer-join="auto"
/>
</set>
<set
name="regions"
table="user_region"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.Region"
column="REGION_ID"
outer-join="auto"
/>
</set>
<set
name="subDomains"
table="user_sub_domain"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.SubDomain"
column="SUB_DOMAIN_ID"
outer-join="auto"
/>
</set>
<set
name="towers"
table="user_tower"
lazy="false"
cascade="save-update"
>
<!-- @hibernate.collection-key tag is deprecated, use
@hibernate.key instead -->
<key
column="user_name"
>
</key>
<!-- @hibernate.collection-many-to-many tag is deprecated, use
@hibernate.many-to-many instead -->
<many-to-many
class="org.appfuse.model.Tower"
column="TOWER_ID"
outer-join="auto"
/>
</set>
<property
name="flag1"
column="flag1"
not-null="true"
>
</property>
<property
name="flag2"
column="flag2"
not-null="true"
>
</property>
<property
name="flag3"
column="flag3"
not-null="true"
>
</property>
<property
name="flag4"
column="flag4"
not-null="true"
>
</property>
<property
name="logintimestamp"
column="login_time"
not-null="false"
>
</property>
<property
name="enabled"
type="yes_no"
column="account_enabled"
>
</property>
<property
name="accountExpired"
type="yes_no"
column="account_expired"
not-null="true"
>
</property>
<property
name="accountLocked"
type="yes_no"
column="account_locked"
not-null="true"
>
</property>
<property
name="credentialsExpired"
type="yes_no"
column="credentials_expired"
not-null="true"
>
</property>
<set name="reportingManagers" inverse="true"
cascade="all,delete-orphan">
<key column="user_name"/>
<one-to-many class="org.appfuse.model.ReportingManager" />
</set>
</class>
</hibernate-mapping>
Michael Horwitz wrote:
>
> Which version of AppFuse are you using? Have you modified any of the user
> management code, e.g. UserDaoHibernate or UserManagerImpl?
>
> Mike
>
>
> On 8/16/07, ujjala <[EMAIL PROTECTED]> wrote:
>>
>>
>> When i add a user which is already exist in database then it throws the
>> following exception.
>> org.hibernate.exception. I get the error also in jsp page. It does not
>> show
>> any message that user already exist. What is the reason please tell me.
>>
>>
>>
>>
>>
>> ConstraintViolationException: could not insert: [org.appfuse.model.User]
>> at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
>> :69)
>> at
>> org.hibernate.exception.JDBCExceptionHelper.convert(
>> JDBCExceptionHelper.java:43)
>> at
>> org.hibernate.persister.entity.AbstractEntityPersister.insert(
>> AbstractEntityPersister.java:2078)
>> at
>> org.hibernate.persister.entity.AbstractEntityPersister.insert(
>> AbstractEntityPersister.java:2427)
>> at
>> org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java
>> :51)
>> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
>> at
>> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java
>> :227)
>> at
>> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java
>> :140)
>> at
>> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
>> AbstractFlushingEventListener.java:296)
>> at
>> org.hibernate.event.def.DefaultFlushEventListener.onFlush(
>> DefaultFlushEventListener.java:27)
>> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
>> at
>> org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(
>> HibernateTemplate.java:788)
>> at
>> org.springframework.orm.hibernate3.HibernateTemplate.execute(
>> HibernateTemplate.java:365)
>> at
>> org.springframework.orm.hibernate3.HibernateTemplate.flush(
>> HibernateTemplate.java:786)
>> at
>> org.appfuse.dao.hibernate.UserDAOHibernate.saveUser(UserDAOHibernate.java
>> :56)
>> at
>> org.appfuse.service.impl.UserManagerImpl.saveUser(UserManagerImpl.java:56)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>> (Compiled
>> Code))
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>> (Compiled
>> Code))
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(
>> DelegatingMethodAccessorImpl.java(Compiled
>> Code))
>> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(
>> AopUtils.java:335)
>> at
>>
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
>> (ReflectiveMethodInvocation.java:181)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>> ReflectiveMethodInvocation.java:148)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(
>> TransactionInterceptor.java:96)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>> ReflectiveMethodInvocation.java:170)
>> at
>>
>> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke
>> (MethodBeforeAdviceInterceptor.java:53)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>> ReflectiveMethodInvocation.java:170)
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:176)
>> at $Proxy2.saveUser(Unknown Source)
>> at org.appfuse.webapp.action.UserAction.save(UserAction.java:265)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>> (Compiled
>> Code))
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>> (Compiled
>> Code))
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(
>> DelegatingMethodAccessorImpl.java(Compiled
>> Code))
>> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
>> at
>> org.apache.struts.actions.DispatchAction.dispatchMethod(
>> DispatchAction.java:274)
>> at org.appfuse.webapp.action.BaseAction.execute(BaseAction.java
>> :210)
>> at
>> org.apache.struts.action.RequestProcessor.processActionPerform(
>> RequestProcessor.java:419)
>> at
>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
>> :224)
>> at org.apache.struts.action.ActionServlet.process(
>> ActionServlet.java:1196)
>> at
>> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java
>> :432)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(
>> StrictServletInstance.java:110)
>> at
>> com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(
>> StrictLifecycleServlet.java:174)
>> at
>> com.ibm.ws.webcontainer.servlet.IdleServletState.service(
>> StrictLifecycleServlet.java:313)
>> at
>> com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(
>> StrictLifecycleServlet.java:116)
>> at
>> com.ibm.ws.webcontainer.servlet.ServletInstance.service(
>> ServletInstance.java:283)
>> at
>> com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(
>> ValidServletReferenceState.java:42)
>> at
>> com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(
>> ServletInstanceReference.java:40)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:76)
>> at
>> com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(
>> PageFilter.java:118)
>> at
>> com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(
>> PageFilter.java:52)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(
>> UrlRewriteFilter.java:323)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> org.appfuse.webapp.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:42)
>> at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(
>> OncePerRequestFilter.java:76)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> org.displaytag.filter.ResponseOverrideFilter.doFilter(
>> ResponseOverrideFilter.java:125)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(
>> CharacterEncodingFilter.java:75)
>> at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(
>> OncePerRequestFilter.java:76)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> com.opensymphony.clickstream.ClickstreamFilter.doFilter(
>> ClickstreamFilter.java:42)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>>
>> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal
>> (OpenSessionInViewFilter.java:174)
>> at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(
>> OncePerRequestFilter.java:76)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:292)
>> at
>> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(
>> FilterSecurityInterceptor.java:108)
>> at
>> org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(
>> SecurityEnforcementFilter.java:197)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:303)
>> at
>> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(
>> AnonymousProcessingFilter.java:143)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:303)
>> at
>> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(
>> RememberMeProcessingFilter.java:154)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:303)
>> at
>> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter
>> (SecurityContextHolderAwareRequestFilter.java:50)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:303)
>> at
>> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(
>> AbstractProcessingFilter.java:246)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:303)
>> at
>> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(
>> HttpSessionContextIntegrationFilter.java:220)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:303)
>> at
>> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java
>> :173)
>> at
>> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
>> :120)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>> org.appfuse.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java
>> :49)
>> at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(
>> OncePerRequestFilter.java:76)
>> at
>> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
>> FilterInstanceWrapper.java:132)
>> at
>> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
>> WebAppFilterChain.java:71)
>> at
>>
>> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch
>> (WebAppRequestDispatcher.java:1010)
>> at
>> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(
>> WebAppRequestDispatcher.java:592)
>> at
>> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(
>> WebAppRequestDispatcher.java:204)
>> at
>> com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java
>> :125)
>> at
>> com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(
>> WebAppInvoker.java:286)
>> at
>> com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation
>> (CachedInvocation.java:71)
>> at
>> com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(
>> ServletRequestProcessor.java:182)
>> at
>> com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(
>> OSEListener.java:334)
>> at
>> com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(
>> HttpConnection.java:56)
>> at
>> com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java
>> :615)
>> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
>> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
>> Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT]
>> SQL0803N
>> One or more values in the INSERT statement, UPDATE statement, or foreign
>> key
>> update caused by a DELETE statement are not valid because the primary
>> key,
>> unique constraint or unique index identified by "1" constrains table
>> "DB2ADMIN.USER" from having duplicate rows for those columns.
>> SQLSTATE=23505
>>
>> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException
>> (Unknown
>> Source)
>> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException
>> (Unknown
>> Source)
>> at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code
>> (Unknown
>> Source)
>> at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown
>> Source)
>> at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown
>> Source)
>> at
>> org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java
>> :23)
>> at
>> org.hibernate.persister.entity.AbstractEntityPersister.insert(
>> AbstractEntityPersister.java:2062)
>> --
>> View this message in context:
>> http://www.nabble.com/Adding-same-user-tf4278429s2369.html#a12177826
>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Adding-same-user-tf4278429s2369.html#a12178836
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
