This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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: 17030

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: JSF / CRUD - Transaction aborted
It's not a secret anymore!