SQL Tools: I'd recommend people checkout DbVisualizer (www.minq.se) if they're looking for a SQL tool. (They have a free version.)
It's written in Java and works with standard JDBC libraries. I've used it with MySQL, Oracle and SQLServer. -Chris > -----Original Message----- > From: Danny Angus [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 1:54 PM > To: James Users List > Subject: RE: Cannot retrieve messages after reboot > > > my own opinion is that to someone who's confident at running sql queries > from the command line, or has a handy visual app managing the contents of > repositories, be it spam, spool, errors or inboxes becomes a > no-brainer you > can use SQL to filter on any field, and modify the messages > in-situ, or move > them from store to store. > > Although I use Linux, and the MySQL command line, Windows users might want > to note that M$Access can perform as a visual client to MySQL using the > MyODBC driver and linked tables (not imports) > > d. > > > -----Original Message----- > > From: Dodd Gatsos [mailto:[EMAIL PROTECTED]] > > Sent: 18 September 2002 17:35 > > To: James Users List > > Subject: Re: Cannot retrieve messages after reboot > > > > > > That's an excellent question. I've seen a lot of people on this list > > implementing James with a DB backend and I've been asking > myself if there > > was any advantage to it. I haven't been able to think of one and I see > > maintaining another application as a rather large drawback. I > don't even > > have the time to regularly check James to make sure it's still > running or > > try and figure out why the messages aren't being removed from > the inboxes > > even though I don't have express set to leave messages on the server. > > > > I would love to hear some opinions on the pros and cons. > > > > ----- Original Message ----- > > From: "Mike Shoemaker" <[EMAIL PROTECTED]> > > To: "James Users List" <[EMAIL PROTECTED]> > > Sent: Wednesday, September 18, 2002 11:13 AM > > Subject: Re: Cannot retrieve messages after reboot > > > > > > > Eric > > > > > > You should ask for your money back :) > > > > > > Its not really too big of a problem for me since I have all of > > 2 users. I > > > can just make sure to retrieve email prior to shutdown. I > > tried to search > > > the archive for anything related to this but kept getting an error > > message. > > > > > > Do you know if this problem would go away if I switched to using a > > database > > > instead of the file system to store mail? I have thought about > > going to a > > > mysql db but always came to the conclusion that there was no > benefit to > > > me. If this problem goes away, Id be willing to switch. > > > > > > Thanks for your input Eric. > > > > > > Mike > > > > > > > > > > > > At 05:40 PM 09/18/2002 +0200, [EMAIL PROTECTED] wrote: > > > >Hello, > > > >We have the same problem since we are using James (6 months ago). > > > >This question was already answered previously : it should have > > to do with > > > >avalon repositories number reattribution. Wonderful, it was > > promised to > > > >be solved with 2.0a3. > > > > > > > >It does not work ! > > > > > > > >We pray for the next version that will hopefully solve this problem. > > > > > > > >Tks, > > > > > > > >eric > > > > > > > > > > > >Mike Shoemaker wrote: > > > > > > > >> > > > >> > > > >>Hello Gang > > > >> > > > >>I recently noticed that I was unable to retrieve messages after > > rebooting > > > >>my machine. I downloaded them at work(left them on the server) via > > pop3, > > > >>rebooted, and then was unable to download them(while removing > > them from > > > >>the server). I can still see them sitting in the inbox so > > they are not > > > >>gone, just untouchable? Anything I can do to make the accessible > > > >>again. Im using James version 2.0a3 on Windows 2000, JDK 1.4 > > > >> > > > >>Any insight would be appreciated > > > >> > > > >> > > > >>-- > > > >>To unsubscribe, e-mail: > > > >><mailto:[EMAIL PROTECTED]> > > > >>For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > >> > > > > > > > > > > > >-- > > > >To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > >For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > Mike Shoemaker > > > http://www.shoesobjects.com > > > > > > > > > -- > > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
