Re: EOF and MS SQLServer?
Re: EOF and MS SQLServer?
- Subject: Re: EOF and MS SQLServer?
- From: Theodore Petrosky <email@hidden>
- Date: Mon, 18 Mar 2019 09:30:51 -0400
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>
> 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)
> 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