Hi, I use JBoss Seam 1.2.1 GA, Jboss 4.0.5 GA and JSF for one project. I have made one new Session bean for inserting/deleting some data in/from database.
It's look something like this: | | @Stateless | @Name("initialize") | public class InitializeData implements Initialize | { | @PersistenceContext | private EntityManager em = null; | | public void insertData() | { | try | { | | PriceCategory cat1 = new PriceCategory("Old", new BigDecimal(3.2)); | PriceCategory cat2 = new PriceCategory("New", new BigDecimal(5.2)); | | em.persist(cat1); | em.persist(cat2); | | em.flush(); | } | catch(Exception e) | { | e.printStackTrace(); | } | } | But when I call this method from JSF, I get always this exception by first em.persist()-call: | | 09:27:45,078 INFO [STDOUT] Hibernate: insert into PriceCategory (priceCategoryId, name, dailyFee, optLock) values (null, ?, ?, ?) | 09:27:45,093 WARN [JDBCExceptionReporter] SQL Error: -104, SQLState: 23000 | 09:27:45,093 ERROR [JDBCExceptionReporter] Unique constraint violation: SYS_CT_61 in statement [insert into PriceCategory (priceCategoryId, name, dailyFee, optLock) values (null, ? | , ?, ?)] | 09:27:45,093 ERROR [STDERR] javax.persistence.EntityExistsException: org.hibernate.exception.ConstraintViolationException: could not insert: [model.PriceCategory] | 09:27:45,093 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:622) | 09:27:45,093 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:218) | | I don't really understand what happend there. Perheps my entity bean PriceCategory: | | @Entity | @Table(name = "PriceCategory") | @Name("pricecategory") | public class PriceCategory implements Serializable { | | @Id | @GeneratedValue(strategy=GenerationType.IDENTITY) | @Column(name = "priceCategoryId") | private Integer id; | | @Column(name = "name", nullable = false, length = 20, unique=true) | private String name; | | @Column(name = "dailyFee", nullable = false, precision = 4, scale = 2) | private BigDecimal dailyFee; | | @Version | @Column(name = "optLock") | private Integer version; | ... | | I am really stuck at this point and without data in database cann't do anything more. Could anyone give me some hint for get over it? Thanks a lot for every help! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039725#4039725 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4039725 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user