The following are some similarities and differences between file stores and JDBC stores:

* Both have the same transaction semantics, including rolling back transactions (e.g., received messages are put back on the queue).

* Both have the same application interface (no difference in application code).

* The file store should be much faster.

* JDBC may make it easier to handle failure recovery since the JDBC interface can access the database from any client machine; with the file store, the disk must be shared or migrated.

* File store reliability is limited to reliability of disk and O/S; run it on Veritas or a RAID 5 system. Database reliability may be higher.

* File stores will require more memory, but perhaps not significantly more; it depends on how fragmented the file store gets, if the application works roughly

* FIFO it shouldn't get very fragmented at all.

* File stores generate no additional network traffic, database stores do if the database server is on a different JVM or machine.