Hi, I've been playing with AppFuse 2.0 M5 (MySQL, JPA Hibernate, Struts2 Basic) for the past couple of weeks and I've been following the useful tutorials. I've hit a couple of snags which have slowed me down. Hopefully, your answers will get me back on my feet.
My current issue is that DBUnit has been causing me problems. I've already had to add FOREIGN_KEY_CHECKS=0 to the JDBC URL to work around another issue, but now DBUnit doesn't seem to increment sequences when inserting the sample-data.xml. (see: http://www.nabble.com/unique-constraint-violated-when-running-test-all-tf1447523s2369.html Unique constraint violated ). When I run my DAO tests, it fails with MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 2. I tried to initialize the sequence to a high number, but it doesn't seem to work. @Id @GeneratedValue(strategy = GenerationType.AUTO, generator = "generator") @SequenceGenerator(name = "generator", initialValue = 100) private Long id; @ManyToOne private Subject parent; @OneToMany(cascade = CascadeType.ALL, mappedBy = "parent") private Set<Subject> children; @Column(nullable = false, length = 50) private String title; @Lob private String description; What do people used to populate a DB when using AppFuse? I'd like to keep using DBUnit's solution, but maybe I'm barking at the wrong tree. Thanks much in advance! Eric =) -- View this message in context: http://www.nabble.com/Populating-Database-and-DAO-Testing-tf4264560s2369.html#a12136692 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
