Re: EOF and MS SQLServer?

[Markus Ruggiero]

Thanks, works now. I can finally access the Microsoft DB from EntityModeler and 
from my D2W App.

---markus---



> On 18 Mar 2019, at 14:30, Theodore Petrosky  wrote:
> 
> Markus,
> 
> what about the properties??
> 
> from:   
> Class ERXConfigurationManager
> 
> Global:
>   dbConnectServerGLOBAL = myDatabaseServer
>   dbConnectUserGLOBAL = me
>   dbConnectPasswordGLOBAL = secret
>   dbConnectPluginGLOBAL = com.webobjects.jdbcadaptor.MicrosoftPlugIn
>  Per Model for say model ER:
>   ER.DBServer = myDatabaseServer
>   ER.DBUser = me
>   ER.DBPassword = secret
>   ER.DBPlugin = com.webobjects.jdbcadaptor.MicrosoftPlugIn
>  
> in my case I normally use postgresql:
> 
>  dbConnectDriverGLOBAL=org.postgresql.Driver
> 
> I never set this EOModeler unless I have to reverse compile a database
> 
> is this what you are looking for?
> 
> Ted
> 
> 
> 
>> On Mar 18, 2019, at 6:31 AM, Markus Ruggiero > > wrote:
>> 
>> Folks, 
>> 
>> It took a while because I was busy with other things but now I have to come 
>> back to this topic.
>> 
>>> On 28 Feb 2019, at 10:19, René Bock >> > wrote:
>>> 
>>> Hi, 
>>> 
>>> unless you need to use ERXMigrations for schema creation, you may simply 
>>> use the com.webobjects.jdbcadaptor.MicrosoftPlugIn.  
>> 
>> No migrations required.
>> How would I use the plug-in? Possibly silly question, but when I create an 
>> EOModel I cannot specify the plug-in to use (MSSQL is not in the popup list) 
>> and therefore I have no prototypes available. I might be missing something 
>> here simply because it's possibly too trivial and everything has always 
>> worked out of the box so far.
>> 
>> Thanks for some hand holding
>> ---markus---
>> 
>>> 
>>> If you  need ERXMigrations, things become bit hairy, since Microsoft  did  
>>> some strange sql extensions:
>>> 
>>> utf-8 Support:  varchar don't support UTF-8 characters.  You have to use 
>>> nvarchar, ntext, columns if you need to store utf-8 characters
>>> text-bolb:  text (and ntext)  are deprecated.  Microsoft encourage to use 
>>> varchar(MAX), which is not really standard sql :-(   At least I wasn't able 
>>> varchar(max) text blobs using the default EOSchemaGeneration mechanism.
>>> 
>>> Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address 
>>> migration-support.  Unfortunately, didn't find it's way into WOnder. 
>>> Fortunately I got a copy of chucks plugin and added the nvarchar/ntext 
>>> migration support.  But my implementation required some changes in 
>>> ERPrototypes, which are not backward compatible...
>>> 
>>> 
>>> 
 Am 27.02.2019 um 10:40 schrieb Markus Ruggiero >>> >:
 
 We are about to get a new project but the customer requires the 
 application to run against an existing Microsoft SQL Server (version not 
 yet known). When I create a new EOModel there is no selection for an MS 
 SQL Server plug-in. No support in Wonder for Microsoft?
 
 Does anyone have experience running a Wonder App against a Microssoft 
 database?
 
 Please help and advise
 ---markus---
 
 ___
 Do not post admin requests to the list. They will be ignored.
 Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
 )
 Help/Unsubscribe/Update your Subscription:
 https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de
  
 
 
 This email sent to b...@salient-doremus.de 
>>> 
>>> Mit freundlichen Grüßen 
>>> 
>>> René Bock
>>> 
>>> --
>>> Telefon: +49 69 650096 18
>>> 
>>> salient GmbH, Lindleystraße 12, 60314 Frankfurt
>>> Telefon Zentrale: 069 / 65 00 96 - 0  |  www.salient-doremus.de 
>>> 
>> 
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
>> )
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com 
>> 
>> 
>> This email sent to tedp...@yahoo.com
> 

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: EOF and MS SQLServer?

[Markus Ruggiero]

Folks, 

It took a while because I was busy with other things but now I have to come 
back to this topic.

> On 28 Feb 2019, at 10:19, René Bock  wrote:
> 
> Hi, 
> 
> unless you need to use ERXMigrations for schema creation, you may simply use 
> the com.webobjects.jdbcadaptor.MicrosoftPlugIn.  

No migrations required.
How would I use the plug-in? Possibly silly question, but when I create an 
EOModel I cannot specify the plug-in to use (MSSQL is not in the popup list) 
and therefore I have no prototypes available. I might be missing something here 
simply because it's possibly too trivial and everything has always worked out 
of the box so far.

Thanks for some hand holding
---markus---

> 
> If you  need ERXMigrations, things become bit hairy, since Microsoft  did  
> some strange sql extensions:
> 
> utf-8 Support:  varchar don't support UTF-8 characters.  You have to use 
> nvarchar, ntext, columns if you need to store utf-8 characters
> text-bolb:  text (and ntext)  are deprecated.  Microsoft encourage to use 
> varchar(MAX), which is not really standard sql :-(   At least I wasn't able 
> varchar(max) text blobs using the default EOSchemaGeneration mechanism.
> 
> Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address 
> migration-support.  Unfortunately, didn't find it's way into WOnder. 
> Fortunately I got a copy of chucks plugin and added the nvarchar/ntext 
> migration support.  But my implementation required some changes in 
> ERPrototypes, which are not backward compatible...
> 
> 
> 
>> Am 27.02.2019 um 10:40 schrieb Markus Ruggiero > >:
>> 
>> We are about to get a new project but the customer requires the application 
>> to run against an existing Microsoft SQL Server (version not yet known). 
>> When I create a new EOModel there is no selection for an MS SQL Server 
>> plug-in. No support in Wonder for Microsoft?
>> 
>> Does anyone have experience running a Wonder App against a Microssoft 
>> database?
>> 
>> Please help and advise
>> ---markus---
>> 
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
>> )
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de
>>  
>> 
>> 
>> This email sent to b...@salient-doremus.de
> 
> Mit freundlichen Grüßen 
> 
> René Bock
> 
> --
> Telefon: +49 69 650096 18
> 
> salient GmbH, Lindleystraße 12, 60314 Frankfurt
> Telefon Zentrale: 069 / 65 00 96 - 0  |  www.salient-doremus.de 
> 

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: EOF and MS SQLServer?

[René Bock]

Hi,

unless you need to use ERXMigrations for schema creation, you may simply use 
the com.webobjects.jdbcadaptor.MicrosoftPlugIn.

If you  need ERXMigrations, things become bit hairy, since Microsoft  did  some 
strange sql extensions:

utf-8 Support:  varchar don't support UTF-8 characters.  You have to use 
nvarchar, ntext, columns if you need to store utf-8 characters
text-bolb:  text (and ntext)  are deprecated.  Microsoft encourage to use 
varchar(MAX), which is not really standard sql :-(   At least I wasn't able 
varchar(max) text blobs using the default EOSchemaGeneration mechanism.

Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address 
migration-support.  Unfortunately, didn't find it's way into WOnder. 
Fortunately I got a copy of chucks plugin and added the nvarchar/ntext 
migration support.  But my implementation required some changes in 
ERPrototypes, which are not backward compatible...



Am 27.02.2019 um 10:40 schrieb Markus Ruggiero 
mailto:mailingli...@kataputt.com>>:

We are about to get a new project but the customer requires the application to 
run against an existing Microsoft SQL Server (version not yet known). When I 
create a new EOModel there is no selection for an MS SQL Server plug-in. No 
support in Wonder for Microsoft?

Does anyone have experience running a Wonder App against a Microssoft database?

Please help and advise
---markus---

___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  
(Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de

This email sent to b...@salient-doremus.de

Mit freundlichen Grüßen

René Bock

--
Telefon: +49 69 650096 18

salient GmbH, Lindleystraße 12, 60314 Frankfurt
Telefon Zentrale: 069 / 65 00 96 - 0  |  
www.salient-doremus.de

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: EOF and MS SQLServer?

[Hugi Thordarson]

Used EOF with MS SQL Server a lot about a decade ago, worked fine and I don't 
recall a lot of caveats. All switched to Cayenne now, though.

- hugi



> On 27 Feb 2019, at 19:00, Tim Worman  wrote:
> 
> Hi Markus,
> 
> I’ve used the Microsoft plugin in Wonder to connect to SQL Server quite a 
> lot. I don’t have to write data to these databases so I can’t offer any 
> updates on the issues Chuck encountered but our connections have worked well. 
> There are definitely peculiarities working SQL Server though and I’m happy to 
> chime in if/when you see issues.
> 
> 
> 
> Tim
> UCLA GSE&IS
> 
>> On Feb 27, 2019, at 9:27 AM, Chuck Hill > > wrote:
>> 
>> Hi Markus,
>> 
>> This was back in 2008 so things may have changed.  IIRC the plugin I used 
>> was called MicrosoftPlugIn and it was part of WO.  The ordering below was 
>> the main issue that I had.  The other was that timestamps were accurate to 
>> something like 3 ms in the database so while you could use then, you could 
>> not use them for optimistic locking as the snapshot value would often not 
>> match the value in the generated WHERE clause.
>> 
>> Chuck.
>> 
>>> On Feb 27, 2019, at 6:52 AM, Aaron Rosenzweig >> > wrote:
>>> 
>>> Hi Markus,
>>> 
>>> Here’s the coordinating callback hook I was referring to (made for MS SQL 
>>> but could work for any DB):
>>> 
>>> https://github.com/wocommunity/wonder/blob/master/Frameworks/Core/ERExtensions/Sources/com/webobjects/eoaccess/ERXEntityDependencyOrderingDelegate.java
>>>  
>>> 
>>> 
>>> It helps with, but does not fully eliminate, problems due to lack of 
>>> deferred constraints.
>>> AARON ROSENZWEIG / Chat 'n Bike 
>>> e:  aa...@chatnbike.com   t:  (301) 956-2319
>>> 
>>> 
 On Feb 27, 2019, at 9:47 AM, Aaron Rosenzweig >>> > wrote:
 
 Hi Markus,
 
 If memory serves, Chuck Hill deployed to MS SQLServer. I remember 
 specifically he had a coordinating callback that was added to Wonder so 
 that it did a better job of organizing the order of update/delete/insert 
 as to help not avoid constraint errors. That’s because MS SQL didn’t have 
 deferred constraints back then (maybe it does now). I thought there was a 
 plug-in too… 
 AARON ROSENZWEIG / Chat 'n Bike 
 e:  aa...@chatnbike.com   t:  (301) 956-2319

 
> On Feb 27, 2019, at 4:40 AM, Markus Ruggiero  > wrote:
> 
> We are about to get a new project but the customer requires the 
> application to run against an existing Microsoft SQL Server (version not 
> yet known). When I create a new EOModel there is no selection for an MS 
> SQL Server plug-in. No support in Wonder for Microsoft?
> 
> Does anyone have experience running a Wonder App against a Microssoft 
> database?
> 
> Please help and advise
> ---markus---
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
> )
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com
>  
> 
> 
> This email sent to aa...@chatnbike.com 
 
>>> 
>>> ___
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
>>> )
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/webobjects-dev/hill.chuck%40gmail.com
>>>  
>>> 
>>> 
>>> This email sent to hill.ch...@gmail.com 
>> 
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
>> )
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com 
>> 
>> 
>> This email sent to li...@thetimmy.com 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple

Re: EOF and MS SQLServer?

[Chuck Hill]

Hi Markus,

This was back in 2008 so things may have changed.  IIRC the plugin I used was 
called MicrosoftPlugIn and it was part of WO.  The ordering below was the main 
issue that I had.  The other was that timestamps were accurate to something 
like 3 ms in the database so while you could use then, you could not use them 
for optimistic locking as the snapshot value would often not match the value in 
the generated WHERE clause.

Chuck.

> On Feb 27, 2019, at 6:52 AM, Aaron Rosenzweig  wrote:
> 
> Hi Markus,
> 
> Here’s the coordinating callback hook I was referring to (made for MS SQL but 
> could work for any DB):
> 
> https://github.com/wocommunity/wonder/blob/master/Frameworks/Core/ERExtensions/Sources/com/webobjects/eoaccess/ERXEntityDependencyOrderingDelegate.java
>  
> 
> 
> It helps with, but does not fully eliminate, problems due to lack of deferred 
> constraints.
> AARON ROSENZWEIG / Chat 'n Bike 
> e:  aa...@chatnbike.com   t:  (301) 956-2319  
> 
>   
> 
>> On Feb 27, 2019, at 9:47 AM, Aaron Rosenzweig > > wrote:
>> 
>> Hi Markus,
>> 
>> If memory serves, Chuck Hill deployed to MS SQLServer. I remember 
>> specifically he had a coordinating callback that was added to Wonder so that 
>> it did a better job of organizing the order of update/delete/insert as to 
>> help not avoid constraint errors. That’s because MS SQL didn’t have deferred 
>> constraints back then (maybe it does now). I thought there was a plug-in 
>> too… 
>> AARON ROSENZWEIG / Chat 'n Bike 
>> e:  aa...@chatnbike.com   t:  (301) 956-2319 
>> 
>>  
>> 
>>> On Feb 27, 2019, at 4:40 AM, Markus Ruggiero >> > wrote:
>>> 
>>> We are about to get a new project but the customer requires the application 
>>> to run against an existing Microsoft SQL Server (version not yet known). 
>>> When I create a new EOModel there is no selection for an MS SQL Server 
>>> plug-in. No support in Wonder for Microsoft?
>>> 
>>> Does anyone have experience running a Wonder App against a Microssoft 
>>> database?
>>> 
>>> Please help and advise
>>> ---markus---
>>> 
>>> ___
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
>>> )
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com
>>>  
>>> 
>>> 
>>> This email sent to aa...@chatnbike.com 
>> 
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/hill.chuck%40gmail.com
> 
> This email sent to hill.ch...@gmail.com

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: EOF and MS SQLServer?

[Aaron Rosenzweig]

Hi Markus,

Here’s the coordinating callback hook I was referring to (made for MS SQL but 
could work for any DB):

https://github.com/wocommunity/wonder/blob/master/Frameworks/Core/ERExtensions/Sources/com/webobjects/eoaccess/ERXEntityDependencyOrderingDelegate.java
 


It helps with, but does not fully eliminate, problems due to lack of deferred 
constraints.
AARON ROSENZWEIG / Chat 'n Bike 
e:  aa...@chatnbike.com   t:  (301) 956-2319



> On Feb 27, 2019, at 9:47 AM, Aaron Rosenzweig  wrote:
> 
> Hi Markus,
> 
> If memory serves, Chuck Hill deployed to MS SQLServer. I remember 
> specifically he had a coordinating callback that was added to Wonder so that 
> it did a better job of organizing the order of update/delete/insert as to 
> help not avoid constraint errors. That’s because MS SQL didn’t have deferred 
> constraints back then (maybe it does now). I thought there was a plug-in too… 
> AARON ROSENZWEIG / Chat 'n Bike 
> e:  aa...@chatnbike.com   t:  (301) 956-2319  
> 
>   
> 
>> On Feb 27, 2019, at 4:40 AM, Markus Ruggiero > > wrote:
>> 
>> We are about to get a new project but the customer requires the application 
>> to run against an existing Microsoft SQL Server (version not yet known). 
>> When I create a new EOModel there is no selection for an MS SQL Server 
>> plug-in. No support in Wonder for Microsoft?
>> 
>> Does anyone have experience running a Wonder App against a Microssoft 
>> database?
>> 
>> Please help and advise
>> ---markus---
>> 
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com 
>> )
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com 
>> 
>> 
>> This email sent to aa...@chatnbike.com
> 

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: EOF and MS SQLServer?

[Aaron Rosenzweig]

Hi Markus,

If memory serves, Chuck Hill deployed to MS SQLServer. I remember specifically 
he had a coordinating callback that was added to Wonder so that it did a better 
job of organizing the order of update/delete/insert as to help not avoid 
constraint errors. That’s because MS SQL didn’t have deferred constraints back 
then (maybe it does now). I thought there was a plug-in too… 
AARON ROSENZWEIG / Chat 'n Bike 
e:  aa...@chatnbike.com   t:  (301) 956-2319



> On Feb 27, 2019, at 4:40 AM, Markus Ruggiero  
> wrote:
> 
> We are about to get a new project but the customer requires the application 
> to run against an existing Microsoft SQL Server (version not yet known). When 
> I create a new EOModel there is no selection for an MS SQL Server plug-in. No 
> support in Wonder for Microsoft?
> 
> Does anyone have experience running a Wonder App against a Microssoft 
> database?
> 
> Please help and advise
> ---markus---
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com
> 
> This email sent to aa...@chatnbike.com

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

EOF and MS SQLServer?

[Markus Ruggiero]

We are about to get a new project but the customer requires the application to 
run against an existing Microsoft SQL Server (version not yet known). When I 
create a new EOModel there is no selection for an MS SQL Server plug-in. No 
support in Wonder for Microsoft?

Does anyone have experience running a Wonder App against a Microssoft database?

Please help and advise
---markus---

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com