search

wocommunity / wonder

Project Wonder
http://wiki.wocommunity.org/
239 stars 166 forks source link

Add new ERMicrosoftPlugIn supporting PK generation from sequences #984

Closed hprange closed 2 years ago

hprange commented 2 years ago

Improves the support for SQL Server with WebObjects. The ERMicrosoftPlugIn generates primary keys from sequences instead of the EO_PK_TABLE strategy used by the standard MicrosoftPlugIn.

Also, the original implementation of the MicrosoftPlugIn forcibly adds the SelectMethod=cursor parameter to the connection URL. Even though this option may be useful in some scenarios, it may also cause undesirable side effects. Each application may have different requirements regarding how and when to use adaptive buffering. For this reason, the ERMicrosoftPlugin lets the user decide how to configure adaptive buffering if needed.

See the Microsoft documentation for more information about adaptive buffering.

hprange commented 2 years ago

I've been using this plug-in for development for a while and haven't found any issues. Since this plug-in is not enabled by default, I'm willing to merge this pull request. I'm working on other improvements to this plug-in, but they deserve a separate pull request. Any objections?