Re: EOF and MS SQLServer?
Re: EOF and MS SQLServer?
- Subject: Re: EOF and MS SQLServer?
- From: Markus Ruggiero <email@hidden>
- Date: Mon, 25 Mar 2019 15:02:13 +0100
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 <email@hidden> 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 <email@hidden
>> <mailto:email@hidden>> 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 <email@hidden
>>> <mailto:email@hidden>> 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 <email@hidden
>>>> <mailto:email@hidden>>:
>>>>
>>>> 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 (email@hidden
>>>> <mailto:email@hidden>)
>>>> Help/Unsubscribe/Update your Subscription:
>>>>
>>>>
>>>> This email sent to email@hidden <mailto:email@hidden>
>>>
>>> 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
>>> <http://www.salient-doremus.de/>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden
>> <mailto: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