I'm using JPA with an AS/400 (DB2/i) in an EJB/EAR application. We're having trouble with rollbacks, which also has me wondering what else might work better if I knew how to configure this correctly.
Does anyone have any best practices for this setup? Do I need both a JTA and non-JTA datasource defined for JPA? (I've read posts where that was needed for Derby.) Also, when I create the server Database Pools, what values should I use? Specifically, I've been using Database Type "Other", but does using that reduce my functionality? Should I be using one of the "DB2" values, even though its on the i? And what about Transaction Type? We're running WASCE 2.1.1.3. Thanks! David Frahm Huber & Associates Office: 573-634-5000, Mobile: 573-298-1040