Bugs item #912287, was opened at 2004-03-09 08:32
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=104866&aid=912287&group_id=4866

Category: MiddleKit
Group: None
Status: Open
Resolution: None
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.

----------------------------------------------------------------------

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: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Webware-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-devel

Reply via email to