Hi all,
I have found fix for my problem it was due to this line of code:
MailGroup mailGroup = new MailGroupImpl(confirmation.getAction());
I replaced it with:
MailGroup mailGroup =
newsletterService.getMailGroup(confirmation.getAction());
and now it is working. I think that explanation is not needed :)
Thanks to everyone who took the time to read about my problem.
All the best,
Igor
----- Original Message -----
From: "Igor Salma" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, June 12, 2008 3:03 PM
Subject: [HippoCMS-dev] Problem with adding subscription to
existingsubscriber
Hi all,
I'm trying to use hippo-community-apps library for newsletter management. I
have a problem when I try to create
subscriber and after that add subscription to him. Creation goes well, I can
see new subscriber in database, but
when I do this:
MailGroup mailGroup = new MailGroupImpl(confirmation.getAction());
Subscription subscription = new SubscriptionImpl(subscriber, mailGroup);
subscriber = newsletterService.getSubscriber(subscriber.getId());
subscriber.addSubscription(subscription);
newsletterService.saveSubscriber(subscriber);
I get:
javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO
`HCA_MAILGROUPS` (`DESCRIPTION`,`PUBLIC`,`TYPENAME`,`DOMAIN`,`ID`) VALUES
(?,?,?,?,?)
NestedThrowables:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Duplicate entry 'Mailinglijst Architectuur' for key 2
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:455)
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)
org.jpox.store.StoreManager.insert(StoreManager.java:920)
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3667)
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3646)
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1243)
org.jpox.store.mapping.PersistenceCapableMapping.setObject(PersistenceCapableMapping.java:450)
org.jpox.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:144)
org.jpox.state.StateManagerImpl.providedObjectField(StateManagerImpl.java:2771)
nl.hippo.hca.newsletter.model.impl.SubscriptionImpl.jdoProvideField(Unknown
Source)
nl.hippo.hca.newsletter.model.impl.SubscriptionImpl.jdoProvideFields(Unknown
Source)
org.jpox.state.StateManagerImpl.provideFields(StateManagerImpl.java:3115)
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:252)
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)
org.jpox.store.StoreManager.insert(StoreManager.java:920)
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3667)
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3646)
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1243)
org.jpox.AbstractPersistenceManager.attachCopy(AbstractPersistenceManager.java:1374)
org.jpox.sco.Set.attachCopy(Set.java:428)
org.jpox.state.AttachFieldManager.storeObjectField(AttachFieldManager.java:157)
org.jpox.state.StateManagerImpl.providedObjectField(StateManagerImpl.java:2771)
nl.hippo.hca.newsletter.model.impl.SubscriberImpl.jdoProvideField(Unknown
Source)
nl.hippo.hca.newsletter.model.impl.SubscriberImpl.jdoProvideFields(Unknown
Source)
org.jpox.state.StateManagerImpl.provideFields(StateManagerImpl.java:3115)
org.jpox.state.StateManagerImpl.internalAttachCopy(StateManagerImpl.java:4389)
org.jpox.state.StateManagerImpl.attachCopy(StateManagerImpl.java:4331)
org.jpox.AbstractPersistenceManager.attachCopy(AbstractPersistenceManager.java:1415)
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1161)
org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1261)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.springframework.orm.jdo.JdoTemplate$9.doInJdo(JdoTemplate.java:406)
org.springframework.orm.jdo.JdoTemplate.execute(JdoTemplate.java:259)
org.springframework.orm.jdo.JdoTemplate.makePersistent(JdoTemplate.java:403)
nl.hippo.hca.newsletter.dao.jdo.NewsletterJdoDao.saveSubscriber(Unknown
Source)
nl.hippo.hca.newsletter.services.impl.NewsletterServiceImpl.saveSubscriber(Unknown
Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:266)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
$Proxy22.saveSubscriber(Unknown Source)
nl.hippo.client.eoverheid.services.Newsletter.subscribe(Newsletter.java:115)
org.apache.jsp.jsp.processor_jsp._jspService(processor_jsp.java:182)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
nl.hippo.client.el.filter.impl.AbstractRepositoryFilter.doFilter(AbstractRepositoryFilter.java:220)I
dont get it: why new mailgroup need to be added.
Kind regards,
HintTech
Igor Salma
T: +381 [0] 21-301 205
F: +381 [0] 21-639 26 96
M: +381 [0] 64-4010415
E: [EMAIL PROTECTED]
Jermenska 9 | 21000 Novi Sad | Serbia
HEADQUARTERS: Rotterdamseweg 183c | 2629 HD Delft | The Netherlands |
www.hinttech.com
Chamber of Commerce The Hague nr. 27242282 | Sales Tax nr. NL8062.16.396.B01
HintTech
HintTech specialises in supplying contract specialist staff in the field of
software
development (.NET and Java), Project Management and Information Security.
Tridion | IBM WebSphere | .Net | Unix | Hippo CMS | GrIB | ISMF | Prince2 |
IPMA | ITIL
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
