c IN () is valid sql. some db's just don't handle it. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4029569#4029569 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4029569