File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » JSF
Bookmark "JSF / CRUD - Transaction aborted" Watch "JSF / CRUD - Transaction aborted" New topic
Author

JSF / CRUD - Transaction aborted

Roy Dellray
Greenhorn

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: 16305
    
  21

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
Roy Dellray
Greenhorn

Joined: Jul 13, 2011
Posts: 10

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 ?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSF / CRUD - Transaction aborted