I like DbVisualizer very much too. I also like a tool that you can find at http://sourceforge.com phpMyAdmin. An excellent tool for dealing with mysql. You can drop databases/tables. Create them also and the program will printout the sql to create these tables. So you can hack around with it and the have it spit out the sql to make your tables. Very much worth looking into. It's #2 on the top ten list at http://sourceforge.com
David Rodal On Wednesday, September 18, 2002, at 04:25 PM, Chris Means wrote: > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
