I think it'not an iBatis issue but a "transactional" issue. If you want to use transactions on AS/400 you have to put the files under journaling.
We usually create libraries with the SQL command "CREATE COLLECTION" instead of traditional AS/400 command "CRTLIB". The "CREATE COLLECTION" sql instruction creates a library and some journal objects inside it (every file created in the library will be automatically under journaling). Davide. -----Messaggio originale----- Da: Tokajac [mailto:[EMAIL PROTECTED] Inviato: lunedi 27 ottobre 2008 15.46 A: user-java@ibatis.apache.org Oggetto: iBatis AS/400 journaling STRJRNPF http://www.nabble.com/file/p20189119/journalTrouble2.txt journalTrouble2.txt Hello, I'm trying to do an UPDATE and INSERT on a table. I have an error message in the attached file. Can U give me an example of how to start journaling from iBatis? Any hint is welcome! Regards -- View this message in context: http://www.nabble.com/iBatis-AS-400-journaling-STRJRNPF-tp20189119p20189119. html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.