JSF / CRUD - Transaction aborted

[Roy Dellray]

Hi All
I have created a very simple CRUD program using NetBeans 7.0, JSF 2.0 and Glassfish 3.1, have not edited a single line. it connects to a very simple MySQL database, the program works great until I try to create a new entry in table1, I receive a "Transaction aborted" message.

I whipped up a another quick CRUD prog, using another simple DB using the exact same methods, and it works great, whats going on here?, what should I be looking for. I even tried a new JNDI and restarting MySQL and Glassfish, but no go.

Someone please help, my last question fell off into a black hole some months ago without an answer. please Help

[Tim Holloway]

There's not much we can do to help. We need some details. Preferably just enough to get an idea of how you're trying to do this without actually burying us in so much trivia we can't read it. Which is always a challenge.

[Roy Dellray]

Ok,
table1: ID - pk int nn ai, Date - date nn, Hour - int(2) nn, Minute - int(2) nn, Message - varchar(255) nn, Frequency - varchar(20) nn, fk_Frequency to table2 Frequency on update cascade on delete cascade
table2: Frequency - pk nn varchar(20)
Where pk - primary key, nn - not null, fk - foreign key, ai - auto increment.
Frequency table is 1 to many non-identifying relationship to Alert table.
Process: Created web app project, created entity classes from db (JNDI - mysql using root), created jsf pages from entities, deploy, run.
Other simpler one works, this one doesnt ?