File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSF and the fly likes JSF / CRUD - Transaction aborted Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSF
Bookmark "JSF / CRUD - Transaction aborted" Watch "JSF / CRUD - Transaction aborted" New topic

JSF / CRUD - Transaction aborted

Roy Dellray

Joined: Jul 13, 2011
Posts: 10

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
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17410

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.

An IDE is no substitute for an Intelligent Developer.
Roy Dellray

Joined: Jul 13, 2011
Posts: 10

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 ?
I agree. Here's the link:
subject: JSF / CRUD - Transaction aborted
It's not a secret anymore!