i got similar problem with oracle and cmp's. i can do as much create and update steps as is value MaxSize in jboss.jcml file at XADataSourceLoader description. after n steps jboss hangs.
how can this problem be solved?
It's always nice if people give some basic information about what they are doing, like jboss version, CMP/BMP etc. It makes guessing about all the details left out a little more fun.
If you are using BMP, make sure you get the connection after the transaction starts and close it before it ends. With cmt, this means get the connection in the method and close it before it returns.
Make sure you call Connection.close() after using it or else the pool will not remove the cxn from the pool.