• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: SQL Server plugin framework
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQL Server plugin framework


  • Subject: Re: SQL Server plugin framework
  • From: Schoenenberger Dominique <email@hidden>
  • Date: Fri, 04 Mar 2016 11:24:27 +0000
  • Thread-topic: SQL Server plugin framework

Hello,

I tried the MicrosoftPlugIn from WebObject distribution but it’s not working correctly.

In the post below, you mention a plugin you wrote and you provide a link. The link is not working anymore. Could you send me this code ?

Thanks,

Dominique

On 25 Nov 2014, at 22:20, Chuck Hill <email@hidden> wrote:

On 2014-11-25, 1:12 PM, "Ress, David A" wrote:

Good afternoon,

My current question is a development issue: I am using SQL Server and I cannot seem to find its plugin framework within the latest Wonder builds listed at https://github.com/wocommunity/wonder.  Could someone please tell me where I can find it?

A version that I made long ago is here
http://www.global-village.net/chill/ms_sql_server_eof_plugin
I thought that a newer version went into Wonder, but I could be wrong.


Without the plugin, I am getting the following error message when I attempt to insert a record from a form: "Cannot insert explicit values for identity column in table 'RxUser' when IDENTITY_INSERT is set to OFF."  When I went into the EOModel to check things out, I noticed the plugin was not set for the current model. That led me to looking for the MicrosoftPlugIn.framework.

Identity columns and EOF don’t play well.  The database expected to populate the identity column when the row is committed and EOF needs to know the PK value before it commits.  I have never used nor know anything about setting IDENTITY_INSERT to off.  I could possibly work.  The plugin above does not do this.


Any suggestions for working with SQL Server in general would be appreciated. Coming from FrontBase, SQL Server seems like a 2-ton gorilla trying to lift a breadbox.

It is not my favourite database.  My two pieces of advice are: don’t use identity columns and don’t lock on timestamp columns as SQL Server’s timestamps are less accurate than JDBC/EOF and this results in optimistic locking failures.  Or did with the 2008 version.

Chuck

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Prev by Date: Re: Can I force a reload of a database's JDBC info?
  • Next by Date: Re: Can I force a reload of a database's JDBC info?
  • Previous by thread: Re: Can I force a reload of a database's JDBC info?
  • Next by thread: Re: SQL Server plugin framework
  • Index(es):
    • Date
    • Thread