I'm hoping to find out which database to use in the application please!
We will be recieving Adobe XML files in a dedicated mailbox, and our users would like to be able to do some queries on the data!
We currently have a Swing application that reads our Oracle and Sybase servers, but in the first phase, we want to provide a simpler approach until the volume increases and the requirements have been finalized!
The general approach will be to manually copy the XML to a shared directory and when a user makes a query, we will read the XML from the shared directory and load the XML data into a database, that way we can use the current Swing application JTable utilities!
Someone mentioned using the following open source DBs as an option, Cloudscape, Berkley or MySql; can anyone tell me which one of these DBs would be the simplist to use?
If the volume isn't that big right now, why not leave the messages on the mail server? Your Swing app can use the JavaMail API to acess the mails right there, with nothing further needing to be set up. My gut feeling would be that you can do that into the thousands of messages before perfromance starts to lag (YMMV, of course).
If you want to use a DB, I assume that you are going to access it using JDBC, which i supported by just about all of them (not sure about Berkeley, though). Postgres and Derby are other options. It's more of an issue for your administrators to decide which one to set up and support, because from a programmers point of view (i.e. JDBC) they'll look very similar. [ August 14, 2005: Message edited by: Ulf Dittmer ]