Oskar, Thanks. yeah i understood the basic ideas about it before. Before though we were using "SEQUENCE" as our strategy. I guess the big problem, which i should have stressed is that when it generates the number and stores it in the databse, i can't find where its getting that number from. If i look at Oracle's sequences table, we have sequences named it but the numbers dont seem to be adding up. Now that i switched from "SEQUENCE" to "AUTO" ... the numbers changed again. So i guess i am having a hard time finding where tis c connecting to the sequence on the db itself. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4124450#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...