Begin forwarded message:
> From: Daniel Beatty <danielbea...@mac.com> > Date: December 20, 2009 8:57:09 PM PST > To: Chuck Hill <ch...@global-village.net> > Cc: Daniel Beatty <danielbea...@mac.com> > Subject: Re: MySQL and PG (was Dr. Miguel....) > > Thanks Chuck, > I have never used ERXJDBC Connection Analyzer. Is there a little tutorial > out there to bring me up to speed? > > It would probably go a long way toward diagnosing this little snafu. It > probably is a little more legal than sacrificing a goat or something to the > demo gods. > > Later, > > Dan Beatty, M.S. CS (B.S. EECS) > Ph.D. Student > Texas Tech University > dan.bea...@mac.com > http://venus.cs.ttu.edu/~dabeatty > http://web.me.com/danielbeatty/My_Home_Page/Welcome.html > > > On Dec 20, 2009, at 8:45 PM, Chuck Hill wrote: > >> Hi Dan, >> >> In situations like this, ERXJDBCConnectionAnalyzer is your friend. That >> should track down and report on what is wrong. >> >> Chuck >> >> >> On Dec 20, 2009, at 8:37 PM, Daniel Beatty wrote: >> >>> Greetings gang, >>> Ok, I have a mystery that I am tracking down, and I need some help. I >>> have a MySQL database that seems to work for Wonder's D2W under Eclipse. >>> However, deployment seems to be another issue. The eomodel for the deploy >>> and Eclipse development environment are the same. Yet in the deployment >>> case, I get the following error: >>> >>> java.lang.IllegalStateException: _obtainOpenChannel -- >>> com.webobjects.eoaccess.EODatabaseContext >>> com.webobjects.eoaccess.eodatabasecont...@3bea817f: failed to open database >>> channel. Check your connection dictionary, and ensure your database is >>> correctly configured. >>> >>> Any ideas? >>> >>> Thank you, >>> >>> Dan Beatty, M.S. CS (B.S. EECS) >>> Ph.D. Student >>> Texas Tech University >>> dan.bea...@mac.com >>> http://venus.cs.ttu.edu/~dabeatty >>> http://web.me.com/danielbeatty/My_Home_Page/Welcome.html >>> >>> >>> >>> On Dec 3, 2009, at 7:50 PM, Andrew Lindesay wrote: >>> >>>> Hello Guido; >>>> >>>> I have to concur; PG has been really great for me and I have had some >>>> problems with MySQL. The most serious problem with MySQL was >>>> memory-exhaustion in the driver, but the latest MySQL driver has seemed to >>>> _finally_ resolved that one. I have to also concur with Mike though in >>>> that I did try to take pgpool (replication only) to a production >>>> environment and it was not a happy morning and I had to roll it back. If >>>> I had to choose between the two for a small WOA, I would definitely lean >>>> towards PG because of the trouble-free operations I've experienced. I >>>> notice there are a number of companies offering support for larger PG >>>> deployments. >>>> >>>> cheers. >>>> >>>>> I don't think I ever used MyISAM tables with a WO app. I have seen >>>>> corrupted data with InnoDB tables and WO usage though. For the rest, they >>>>> might have been MyISAM used from some PHP web crap, but the thing is: the >>>>> SQL stored the thing and some historic data gets corrupted. That was the >>>>> issue we had. I can't recall exactly enough to blame it completely on >>>>> MySQL, but I stopped using it and I had never ever again any issues with >>>>> corrupt data (95% PostgreSQL, 5% FrontBase usage). >>>>> >>>>> FrontBase has the issue that you can easily kill the server with bad >>>>> input. This can't happen with PostgreSQL as you get your own backend for >>>>> each connection. >>>>> >>>>> Between the three databases MySQL, PostgreSQL, and FrontBase, I've used >>>>> PostgreSQL the most and with the most success and least amount of >>>>> trouble. I'd love to see a multi master clustering solution for it though >>>>> that actually works and is not a piece of shit. >>>> >>>> ___ >>>> Andrew Lindesay >>>> www.lindesay.co.nz >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/danielbeatty%40mac.com >>>> >>>> This email sent to danielbea...@mac.com >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>> >>> This email sent to ch...@global-village.net >> >> -- >> Chuck Hill Senior Consultant / VP Development >> >> Practical WebObjects - for developers who want to increase their overall >> knowledge of WebObjects or who are trying to solve specific problems. >> http://www.global-village.net/products/practical_webobjects >> >> >> >> >> >> >> > > > > > > > > > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
