Bugs item #912287, was opened at 2004-03-08 15:32 Message generated for change (Comment added) made by jdhildeb You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=104866&aid=912287&group_id=4866
Category: MiddleKit Group: None >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Benno Rice (benno) Assigned to: Chuck Esterbrook (echuck) Summary: MiddleKit support for PostgreSQL attached Initial Comment: The attached files implement PostgreSQL support for MiddleKit. There are several issues however: - PostgreSQL requires that transactions be committed. I would suggest adding a pre-transaction and post-transaction method to the SQLObejctServer class that can be overridden to add transaction support. I would envisage transactions covering the entirety of a store.saveChanges() call. - PostgreSQL (and other databases) do not support acquiring the primary key of the last inserted row as a contextless after-the-fact operation a la MySQL. To work around this I've had to override the _insertObject method of SQLObjectStore so as to avoid using the retrieveLastInsertId method. To fix this in the least intrusive way possible would require passing the object.sqlTableName() and object.sqlIdName() to retrieveLastInsertId. These files have not been heavily tested. ---------------------------------------------------------------------- >Comment By: Jason Hildebrand (jdhildeb) Date: 2004-10-07 10:59 Message: Logged In: YES user_id=173690 Thanks for your patch and interest in MiddleKit. I didn't end up using your code, because I already had a partial implementation for this myself. A couple of weeks ago I worked at ensuring full test-suite coverage, and have now committed full PostgreSQL support for MiddleKit into CVS. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=104866&aid=912287&group_id=4866 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ Webware-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-devel