This isn't really a "Distributed Java" question, even though "distributed" is mentioned in the error... The error is because your transaction depends on more than 1 "resource" - either your transaction spans multiple databases, or you're using JMS and the transaction spans both the database and the JMS message store.
Moving to the
JDBC forum, since it's really more about transactions and SQL...
[ September 18, 2006: Message edited by: Nathan Pruett ]