Greetings Chuck, Any idea where to put it in a D2W application? I would normally say right before the query, but that seems to bring up the question again, like where is that point?
Thank you, Dan Beatty, M.S. CS (B.S. EECS) Ph.D. Student Texas Tech University [email protected] http://venus.cs.ttu.edu/~dabeatty http://web.me.com/danielbeatty/My_Home_Page/Welcome.html On Dec 20, 2009, at 9:03 PM, Chuck Hill wrote: > Tutorial? Not really. > > new ERXJDBCConnectionAnalyzer("NameOfYourModel"); > > > That is about it. > > Chuck > > > On Dec 20, 2009, at 8:58 PM, Daniel Beatty wrote: > >> >> >> Begin forwarded message: >> >>> From: Daniel Beatty <[email protected]> >>> Date: December 20, 2009 8:57:09 PM PST >>> To: Chuck Hill <[email protected]> >>> Cc: Daniel Beatty <[email protected]> >>> 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 >>> [email protected] >>> 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 >>>>> [email protected] >>>>> 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 ([email protected]) >>>>>> Help/Unsubscribe/Update your Subscription: >>>>>> http://lists.apple.com/mailman/options/webobjects-dev/danielbeatty%40mac.com >>>>>> >>>>>> This email sent to [email protected] >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list ([email protected]) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>>>> >>>>> This email sent to [email protected] >>>> >>>> -- >>>> 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 ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >> >> This email sent to [email protected] > > -- > 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 ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
