[SOLVED] Re: DataBase Connection and EOUtilities.rawRowsForSQL
[SOLVED] Re: DataBase Connection and EOUtilities.rawRowsForSQL
- Subject: [SOLVED] Re: DataBase Connection and EOUtilities.rawRowsForSQL
- From: Miguel Torres <email@hidden>
- Date: Thu, 20 Dec 2012 11:33:29 -0600
Hi Chuck.
You are right, the problem is that I am using dblink to connect two different databases and have some views in my database that connect with the other database but with the name hardcoded.
dblink_exec(''dbname=leviatan_application'', ........
At the beginning of the project sound clever to have two different databases (One for enterprise's catalog and application configuration and other for all the enterprise's business information) but now (after 3 years) I am not sure.
I will read a little to correct this problem ASAP.
Thanks.
On 19/12/2012, at 14:50, Chuck Hill <email@hidden> wrote:
> rawRowsForSQL should be using the same values as anything else. How are you creating the editing context you are using? It sounds like you have a second EOF stack that is not getting initialized from the properties.
>
> Chuck
>
>
> On 2012-12-19, at 11:52 AM, Miguel Torres wrote:
>
>> Hi List,
>>
>> I am using Wonder in my project.
>>
>> I define the database connection in the Properties.user file using the following vars:
>>
>> MyEOModel.URL=jdbc:postgresql:myDBDevelopment
>> MyEOModel.DBUser=someuser
>> MyEOModel.DBPassword=sompass
>> MyEOModel.DBDriver= org.postgresql.Driver
>>
>>
>> In MyEOModel I have a Default connection that is set to: jdbc:postgresql:myDB
>>
>> The application works great, it uses the connection specified in the Properties.user file. The problem is when I use EOUtilities.rawRowsForSQL(EOEditingContext ec, String modelName, String sqlString, NSArray keys)
>>
>> The function gets the database connection parameters from de model.
>>
>> Obviously the problem is solved changing the model database connection info but I want the flexibility that Wonder gives me.
>>
>> Is there any similar approach similar to RawRows but using the connection that wonder creates from Properties file's parameters?
>>
>> Thanks in advance.
>>
>>
>>
>>
>>
>> _______________________________________________
>> 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
>
> --
> Chuck Hill Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
> http://www.global-village.net/gvc/practical_webobjects
>
> Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
> Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
>
>
>
>
>
>
>
>
>
_______________________________________________
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