The datasource pool was originally setup as transactional. It looks like by default glassfish will return 1 non xa connection from a pool, unless you check the box "Returns Non Transactional Connections." The error specifically says "Unable to allocation additional NXA connections from pool" and when we check this box and try again, it works.
[Message sent by forum member 'johnament']
http://forums.java.net/jive/thread.jspa?messageID=393935