Hello, I most struggled with UTF-8 Support and the use of ERMigrations and ERPrototypes ( Mircosoft decided to introduce NVARCHAR and NTEXT to store UTF-8 strings. VARCHAR and TEXT are for 8-bit Chars only )
So I ended in hacking EOJDBCMicrosoftPrototypes.plist, JDBCInfo.plist and the MicrosoftSQLHelper I just added my Version of MicrosoftPlugIn to my fork of Wonder: https://github.com/renebock/wonder/tree/master/Frameworks/PlugIns/MicrosoftPlugIn I'm not shure, if there is a general solution for a MicrosoftPlugIn to be used with legacy DataBases (using 8-Bit Chars) and projects depending on UTF-8 Texts... Am 25.11.2014 um 22:20 schrieb Chuck Hill <[email protected]>: > 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 > René -- salient doremus salient GmbH Kontorhaus - Lindleystraße 12 60314 Frankfurt Main Fon +49 (0)69 - 650096 -0, Durchwahl: - 18, Fax: -70
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
