Re: obtain a BLOB size without fetching the whole thing?

Yes Samuel is right, a derived entity will help but it is only part of the answer. When an EO is fetched, all of it is fetched. In this case the blob plus the derived attribute so it defeats the purpose. You haven’t avoided fetching the blob. I’m going to give your EO a name, let’s call it

Re: obtain a BLOB size without fetching the whole thing?

lumns set up > through setRawRowKeyPaths. The entity contains also a BLOB column which can > be rather big. Is there a trick to get its size only in the result > dictionaries, without actually fetching the data? > > If db-specific, w

Re: obtain a BLOB size without fetching the whole thing?

all. I've got a FS which reads in some columns set up >>> through setRawRowKeyPaths. The entity contains also a BLOB column which can >>> be rather big. Is there a trick to get its size only in the result >>> dictionaries, without actually fetching the data? >&

Re: obtain a BLOB size without fetching the whole thing?

tity contains also a BLOB column which can >>> be rather big. Is there a trick to get its size only in the result >>> dictionaries, without actually fetching the data? >>> >>> If db-specific, with FrontBase. >>> >>> Thanks a lot! >>> OC &g

Re: obtain a BLOB size without fetching the whole thing?

ds in some columns set up >> through setRawRowKeyPaths. The entity contains also a BLOB column which can >> be rather big. Is there a trick to get its size only in the result >> dictionaries, without actually fetching the data? >> >> If db-specific, with FrontBase. &

obtain a BLOB size without fetching the whole thing?

Hi there, the subject says it all. I've got a FS which reads in some columns set up through setRawRowKeyPaths. The entity contains also a BLOB column which can be rather big. Is there a trick to get its size only in the result dictionaries, without actually fetching the data? If db-spe

Re: Fetching data from a model

Hi André first, for the simple solution: Avoid using qualifierWithQualifierFormat. If you want to construct an equality qualifier, use EOKeyValueQualifier instead. new EOKeyValueQualifier( MyEntity.A_KEY, EOQualifier.QualifierOperatorEqual, timestampA ) This will work if you're just tinkering w

Fetching data from a model

Hi, I created a model with EOModeler. There are some classes in my project which represent the entities of my model. Now I come to the point, that I must fetch data from the database. In my Main component I created an EOQualifier which combines 4 attributes: EOQualifier eq = new EOAndQualifi

Re: slooow DB access at the deployment site (was: relationship count without fetching)

Hi OC, I once had a deployment machine with FrontBase on which – I don't remember why anymore – the indices of the tables where not set. The database was working but it was very very slow. After generating the indices and setting the index mode to "preserve time" the speed was back as expected.

SOLVED: slooow DB access at the deployment site (was: relationship count without fetching)

Oh, forget it. It was the most obvious of possible reasons: they forgot to set up a DB index. Oh, sigh. Anyway, thanks for all the help! OC On 29. 2. 2016, at 18:30, OC wrote: > Well I have implemented count using objectCountForToManyRelationship, and > found it is MUCH worse than before at

slooow DB access at the deployment site (was: relationship count without fetching)

Well I have implemented count using objectCountForToManyRelationship, and found it is MUCH worse than before at the deployment site (whilst it runs like a charm for me at my testing machine). After lots of testing it seems the real bottleneck is the database query itself. Lately, I have impleme

Re: relationship count without fetching

On 28 Feb 2016, at 4:00 am, ocs.cz wrote: > Is there a pre-made solution for this in WOnder (or even plain WO) which I > have missed so far, or am I out to DIMyself? How about this? https://jenkins.wocommunity.org/job/Wonder7/lastSuccessfulBuild/javadoc/er/extensions/eof/ERXEOControlUtilities.

Re: relationship count without fetching

it is rather superfluous, for of all the relationships, only > one or two will typically be actually shown. > > Since the numbers of items are, alas, needed and cannot be simply omitted to > show them only after the user clicks showItemRelN, I would need a solution to > get a n

Re: relationship count without fetching

how them only after the user clicks showItemRelN, I would need a solution to > get a number of items in a relationship quickly without actually fetching > them. That would probably mean exploiting SQL COUNT somehow (but only if the > relationship is not fetched yet, of course; if alre

relationship count without fetching

ot be simply omitted to show them only after the user clicks showItemRelN, I would need a solution to get a number of items in a relationship quickly without actually fetching them. That would probably mean exploiting SQL COUNT somehow (but only if the relationship is not fetched yet, of cours

Re: Preferred way for fetching with given SQL select statement?

mailto:webobjects-dev@lists.apple.com>" mailto:webobjects-dev@lists.apple.com>> Subject: Re: Preferred way for fetching with given SQL select statement? Thanks for all your help. Here is the code I am using now (might need some more error checking) Wish you all a WOnder-full day ---markus--- publ

Re: Preferred way for fetching with given SQL select statement?

Not judging :) I’ve got the exact same problem here at work. I’ve been living with it for years. WO can be just as horrible as any other solution when properly applied :P On Sep 25, 2015, at 9:11 AM, Markus Ruggiero wrote: > Thanks, Ramsey, I am fully aware of this. It is very unfortunate but

Re: Preferred way for fetching with given SQL select statement?

Thanks, Ramsey, I am fully aware of this. It is very unfortunate but this is how things are at the moment. The external application whose functionality I have to incorporate into a WO app has been written with Hybernate and raw JDBC. A main part is the collection of product records according to

Re: Preferred way for fetching with given SQL select statement?

Look out for little Bobby Tables https://xkcd.com/327/ ;-) On Sep 25, 2015, at 2:26 AM, Markus Ruggiero wrote: > Thanks for all your help. Here is the code I am using now (might need some > more error checking) > > Wish you all a WOnder-full day > ---markus--- > > public NSArray findP

Re: Preferred way for fetching with given SQL select statement?

Thanks for all your help. Here is the code I am using now (might need some more error checking) Wish you all a WOnder-full day ---markus--- public NSArray findProducts(EOEditingContext ec, String query, NSArray queryParameters) { String resolvedQuery = query;

Re: Preferred way for fetching with given SQL select statement?

Maybe ERXSQLQueryWithBindingsUtilities could be useful here. You'd still have to parse the binding values, but at least you'd get to keep the SQL. Fabian > Am 25.09.2015 um 00:48 schrieb Chuck Hill : > > The challenge is going to be "In addition these statements are > parameterized with ? so th

Re: Preferred way for fetching with given SQL select statement?

The challenge is going to be "In addition these statements are parameterized with ? so they can be precompiled and then used with different query values² You might be able to parse and rewrite those as EOQualifierVariables and then use qualifier.qualiferWithBindings, but you are going to have to k

Re: Preferred way for fetching with given SQL select statement?

Hi, For raw row fetches, there is a shorter way: EOEditingContext ec = ERXEC.newEditingContext(); NSArray rawRows = EOUtilities.rawRowsForSQL(ec, "YourModelName", sql)); ... Samuel > Le 2015-09-24 à 14:48, Johann Werner a écrit : > > Hi Markus, > > I did not clearly understand what you are

Re: Preferred way for fetching with given SQL select statement?

Hi Markus, I did not clearly understand what you are exactly trying to achieve. If you just need to run the vendor specific SQL to get a list of primary keys that you can then use to fetch the EOs you want you could do something like EOEditingContext ec = ERXEC.newEditingContext(); EOEntity en

Preferred way for fetching with given SQL select statement?

Folks, What is the preferred way to fetch EOs when you have a db vendor specific "select id from ... where ." statement? I need to interface with a legacy system where I have to incorporate the functionality of an external java tool into a Wonder app. This external tool executes raw SQL se

Re: Fetching through snapshot

On 16 Sep 2015, at 8:30 am, Paul Hoadley wrote: > On 16 Sep 2015, at 1:27 am, Hugi Thordarson > wrote: > >> Newly inserted (uncommitted) objects are not included when you fetch. One >> way to get around this is to use the “objectsWithQualifier” methods of >> ERXEOContr

Re: Fetching through snapshot

On 16 Sep 2015, at 1:27 am, Hugi Thordarson wrote: > Newly inserted (uncommitted) objects are not included when you fetch. One way > to get around this is to use the “objectsWithQualifier” methods of > ERXEOControlUtilities to perform your fetches, they have an > “includeNewObjects” parameter

Re: Fetching through snapshot

“includeNewObjects” parameter you use to indicate that you want to include > new objects from your EC. > > Cheers, > - hugi > > // Hugi Thordarson > // http://www.loftfar.is/ > // s. 895-6688 > > > >> On 15. sep. 2015, at 15:47, Markus Ruggiero >> w

Re: Fetching through snapshot

from your EC. Cheers, - hugi // Hugi Thordarson // http://www.loftfar.is/ // s. 895-6688 > On 15. sep. 2015, at 15:47, Markus Ruggiero wrote: > > I am running into a problem with fetching. As I am away from my desk and all > the books for the next couple days I kindly ask here for

Fetching through snapshot

I am running into a problem with fetching. As I am away from my desk and all the books for the next couple days I kindly ask here for help: I fetch data from the database with the standard fetchAll...() method. This properly generates SQL queries delivering the requested data. Now the user

Re: Pre-fetching

setPrefetchingRelationshipKeyPaths(NSArray paths) On Feb 21, 2015, at 6:14 PM, Robert B. Hanviriyapunt wrote: > I know how to set up pre fetching in a model based fetch spec. How does one > do this programmatically? > ___ > Do no

Pre-fetching

I know how to set up pre fetching in a model based fetch spec. How does one do this programmatically? ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe

Pre-fetching ERTags

Hello, I have a WODisplayGroup displayGroup containing a collection of EOs. The entity is registered as a taggable entity, and its tag entity is "TemplateTag", a subclass of ERTag. I want to find the set of all TemplateTags that are currently applied to any object in displayGroup.allObjects()

Fetching Sorted Entities With A Tag (ERTag)

Hi, In setting up ERTag to an entity in my model I went with the Quick Start method outlined in the documentation which outlines how to setup ERTag with minimal effort. The side effect of this is there are none of the usual relationship methods for starting with an ERTag and fetching all of

Re: Setting relationship is fetching all objects

Transaction type sounds like a good candidate for an enum if you don't need to create new ones at runtime :-) Ramsey On Jul 31, 2012, at 12:51 PM, Pascal Robert wrote: > > Le 2012-07-31 à 15:39, Maik Musall a écrit : > >> >> Am 31.07.2012 um 21:29 schrieb Pascal Robert: >> >>> I have a weir

Re: Setting relationship is fetching all objects

Le 2012-07-31 à 15:39, Maik Musall a écrit : > > Am 31.07.2012 um 21:29 schrieb Pascal Robert: > >> I have a weird problem or maybe I'm just stupid. In awakeFromInsertion, I >> want to set a relationship (transactionType) on all new Transaction EOs. So >> I did this: >> >> @Override >> publi

Re: Setting relationship is fetching all objects

Maybe use the fetchRequiredTransactionType instead?? On 2012-07-31, at 12:29 PM, Pascal Robert wrote: > I have a weird problem or maybe I'm just stupid. In awakeFromInsertion, I > want to set a relationship (transactionType) on all new Transaction EOs. So I > did this: > > @Override > publ

Re: Setting relationship is fetching all objects

Am 31.07.2012 um 21:29 schrieb Pascal Robert: > I have a weird problem or maybe I'm just stupid. In awakeFromInsertion, I > want to set a relationship (transactionType) on all new Transaction EOs. So I > did this: > > @Override > public void awakeFromInsertion(EOEditingContext editingContext

Setting relationship is fetching all objects

I have a weird problem or maybe I'm just stupid. In awakeFromInsertion, I want to set a relationship (transactionType) on all new Transaction EOs. So I did this: @Override public void awakeFromInsertion(EOEditingContext editingContext) { super.awakeFromInsertion(editingContext); setQ

Re: fetchLimit don't affect SQL fetching limit?

I force LIMIT to SQL statement in MySQL? >>>>>> >>>>>> 2012/6/26 Kieran Kelleher : >>>>>>> It depends on the database plugin you are using. Some plugins take the >>>>>>> fetchSpec fetchLimit an

Re: fetchLimit don't affect SQL fetching limit?

her : >>>>>> It depends on the database plugin you are using. Some plugins take the >>>>>> fetchSpec fetchLimit and incorporate it into the SQL statement in the >>>>>> plugin's EOSQLExpression subclass. The default behaviour of EOF i

Re: fetchLimit don't affect SQL fetching limit?

gt;>> fetchSpec fetchLimit and incorporate it into the SQL statement in the >>>>> plugin's EOSQLExpression subclass. The default behaviour of EOF is to >>>>> limit in memory after the fetch. >>>>> >>>>> On Jun 2

Re: fetchLimit don't affect SQL fetching limit?

ugins take the >>>> fetchSpec fetchLimit and incorporate it into the SQL statement in the >>>> plugin's EOSQLExpression subclass. The default behaviour of EOF is to >>>> limit in memory after the fetch. >>>> >>>> On Jun 26, 20

Re: fetchLimit don't affect SQL fetching limit?

t behaviour of EOF is to limit >>> in memory after the fetch. >>> >>> On Jun 26, 2012, at 10:23 AM, Gennady Kushnir wrote: >>> >>>> Hello all! >>>> I am fetching from a table that has lots of records. So I decided to

Re: fetchLimit don't affect SQL fetching limit?

;> >> On Jun 26, 2012, at 10:23 AM, Gennady Kushnir wrote: >> >>> Hello all! >>> I am fetching from a table that has lots of records. So I decided to >>> fs.setFetchLimit(10) on my EOFetchSpecification, but nevertheless when >>> I perform ec.objec

Re: fetchLimit don't affect SQL fetching limit?

s. The default behaviour of EOF is to limit > in memory after the fetch. > > On Jun 26, 2012, at 10:23 AM, Gennady Kushnir wrote: > >> Hello all! >> I am fetching from a table that has lots of records. So I decided to >> fs.setFetchLimit(10) on my EOFetchSpeci

Re: fetchLimit don't affect SQL fetching limit?

shnir wrote: > Hello all! > I am fetching from a table that has lots of records. So I decided to > fs.setFetchLimit(10) on my EOFetchSpecification, but nevertheless when > I perform ec.objectsWithFetchSpecification(fs) I get > JavaOutOfMemoryError. > It seems to me that fetchLimit do

fetchLimit don't affect SQL fetching limit?

Hello all! I am fetching from a table that has lots of records. So I decided to fs.setFetchLimit(10) on my EOFetchSpecification, but nevertheless when I perform ec.objectsWithFetchSpecification(fs) I get JavaOutOfMemoryError. It seems to me that fetchLimit does not actually convert to a LIMIT

Re: Fetching to-one-relationship: How to use willRead and willReadRelationship?

JDBCPlugIn 'com.webobjects.jdbcadaptor.PostgresqlPlugIn' for JDBCAdaptor@ >> 2019733318 >> Jun 26 20:17:16 TicketManagmentServer[54345] DEBUG NSLog - Using >> JDBCPlugIn 'com.webobjects.jdbcadaptor.PostgresqlPlugIn' for >> JDBCAdaptor@1901677475 >> Jun 26 20:17

Re: Fetching to-one-relationship: How to use willRead and willReadRelationship?

17:16 TicketManagmentServer[54345] DEBUG NSLog - connecting with >> dictionary: {plugin = "Postgresql"; username = "postgres"; driver = >> "org.postgresql.Driver"; password = ""; URL = >> "jdbc:postgresql://localhost/TicketMan

Re: Fetching to-one-relationship: How to use willRead and willReadRelationship?

345] DEBUG NSLog - Using > JDBCPlugIn 'com.webobjects.jdbcadaptor.PostgresqlPlugIn' for > JDBCAdaptor@1901677475 > Jun 26 20:17:16 TicketManagmentServer[54345] DEBUG NSLog - connecting > with dictionary: {plugin = "Postgresql"; username = "postgres"; driver = > &qu

Re: Fetching to-one-relationship: How to use willRead and willReadRelationship?

t;; username = "postgres"; driver = > "org.postgresql.Driver"; password = ""; URL = > "jdbc:postgresql://localhost/TicketManagment"; } > Jun 26 20:17:16 TicketManagmentServer[54345] DEBUG NSLog - fetching JDBC > Info with JDBCContext@1433183189 > Ju

Re: Fetching to-one-relationship: How to use willRead and willReadRelationship?

ocalhost/TicketManagment"; } Jun 26 20:17:16 TicketManagmentServer[54345] DEBUG NSLog - fetching JDBC Info with JDBCContext@1433183189 Jun 26 20:17:16 TicketManagmentServer[54345] DEBUG NSLog - connecting with dictionary: {plugin = "Postgresql"; username = "postgres"; driver =

Re: Fetching to-one-relationship: How to use willRead and willReadRelationship?

Hi Fred, On Jun 26, 2011, at 5:01 PM, Fred Opims wrote: > Hi! > I have some problem to a to-one relationship. > I have an Entity with 3 properties ( color, brand, model) and one > relationship Responsable, > > When i make a fetch, i'm able to access to all propeties, but i can't access > to r

Fetching to-one-relationship: How to use willRead and willReadRelationship?

Hi! I have some problem to a to-one relationship. I have an Entity with 3 properties ( color, brand, model) and one relationship Responsable, When i make a fetch, i'm able to access to all propeties, but i can't access to relation responsable. Here is the code String imm = vehicule.immatr

Re: NSTimestamp - date-timestamp data fetching issues

Hi Genkush, The issue got resolved. In the PLIST file if we set the "valueType=T" then the issue got resolved. Now we are getting the hours, minutes and seconds along with the date. Following is the corrected code snippet: (the valueType was not specified before) { allo

Re: NSTimestamp - date-timestamp data fetching issues

> But when I tried printing the fetched Object, the date fields of the object > are printing as (2011-01-27 05:00:00 Etc/GMT), all the date fields hour, > minutes and seconds are printing as 05:00:00, even though this value is > different for different columns in the database. May be you have s

NSTimestamp - date-timestamp data fetching issues

Hi Team, I am trying to fetch the records using NSTimestamp values (that includes date, hours and minutes), and the data is fetched correctly based on the given date and time range parameters. But when I tried printing the fetched Object, the date fields of the object are printing as (2011-01-

[RESOLVED] Duplicated data after fetching on a view

Hi Alex, Thanks a lot., you have right. In fact, I defined the pk of the view on field which contain the same code for all data. So I redefined my pk on another field which have unique code for each data and it works. So I go to write fetch spec to clear my fetching data. Thanks

Re: Duplicated data after fetching on a view

iew to get all data I want and do a fetch on WO to return > specific data. So When I create my fetching code, the sqlExpression is good > but return same data several times although it count different data. > I.e : > > Java fetch code: NSMutableArray

Duplicated data after fetching on a view

Hi All, I create a view to get all data I want and do a fetch on WO to return specific data. So When I create my fetching code, the sqlExpression is good but return same data several times although it count different data. I.e : Java fetch code: NSMutableArray qualFinal = new

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 16, 2011, at 11:50 PM, wrote: >> So if I use Wonder, I can write this code in my WOD to display each person >> picture where person pic like http://webserver/person/mini/personPk.jpg? >> i.e : > > Member picture > > ... > > > > in WOD > p

[RESOLVED]Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

Hi All, I converted my project in wonder, and TB method work great. Thanks a lot Message du : 16/05/2011 De : "Travis Britt " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: Tr: Re: Re: Fetching on 2 EOMO

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 16, 2011, at 10:00 AM, naneon.raym...@neuf.fr wrote: > So what about this ? including a variable in a url : >> in WOD >> picture : WOImage { >> src = "http://webserver/person/mini/"${^person.id}".jpg";; >> } Quick and dirty, lots of assumptions, top of my head, might not compile, non

Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

not mentioned in property class, How I display it? Thakns Message du : 16/05/2011 De : "David Avendasora " A : naneon.raym...@neuf.fr Copie à : Sujet : Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have re

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

able (especially when the qualifier have many parts), but refactoring is much easier too. > Ray > === > > Message du : 13/05/2011 > De : "Chuck Hill " > A : naneon.raym...@neuf.fr > Copie à : webobjects-dev@lists.apple.com >

Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

the EOModel. >How can I do to qualify with pk if it's not mentioned in the class property? Ray === Message du : 13/05/2011 De : "Chuck Hill " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: Tr: Re: Re: Fetching on 2 EOM

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 13, 2011, at 3:21 PM, Tim Worman wrote: > On May 13, 2011, at 7:09 AM, David Avendasora wrote: > >> >> On May 13, 2011, at 4:39 AM, naneon.raym...@neuf.fr wrote: >> >>> I always stay in the corner because I know I need advice on WO >> >> Don't stay in the corner! :-) >> >> This is th

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 13, 2011, at 7:09 AM, David Avendasora wrote: > > On May 13, 2011, at 4:39 AM, naneon.raym...@neuf.fr wrote: > >> I always stay in the corner because I know I need advice on WO > > Don't stay in the corner! :-) > > This is the place for help with WebObjects. Everyone here remembers wha

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

es) and the batch per 10 with DisplayGroup > makes the application very fast. > > I always stay in the corner because I know I need advice on WO > > Thank you > > > ==== > > Message du : 12/05/2011 > De : naneon.raym...@neuf.fr > A : "Henriqu

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 13, 2011, at 4:39 AM, naneon.raym...@neuf.fr wrote: > I always stay in the corner because I know I need advice on WO Don't stay in the corner! :-) This is the place for help with WebObjects. Everyone here remembers what it's like to be new to WO and trying to figure out the fundamental

Re: Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

essage du : 12/05/2011 De : naneon.raym...@neuf.fr A : "Henrique Gomes" , "WebObjects webobjects-dev" Copie à : Sujet : Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship Hi,

Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

Hi, I want just a filter t0.id = t1.etuId to restrict the results, that's all. thanks Message du : 12/05/2011 De : "Henrique Gomes " A : "WebObjects webobjects-dev" Copie à : naneon.raym...@neuf.fr Sujet : Re: Tr: Re: R

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

7;B's when fetching from A. Henrique Gomes On May 12, 2011, at 4:07 PM, naneon.raym...@neuf.fr wrote: > Hi all, > > I could fix my problem of *Distinct* with this line: > > ds.fetchSpecification (). setUsesDistinct (true); > > Then I adde

Re: Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

ects webobjects-dev" Copie à : Sujet : Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship Hi Chuck, I change my mind and go to try ERXBatchingDisplayGroup with a qualifier I built (see below) I translate my fetch spec qualifier:

Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

Yep, the relation exist in my modeler. The relation toOne and sometime toMany. Message du : 12/05/2011 De : "Henrique Gomes " A : "WebObjects webobjects-dev" Copie à : Sujet : Re: Tr: Re: Re: Fetching on 2 EOMODELS using different

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 12, 2011, at 11:44 AM, naneon.raym...@neuf.fr wrote: > The another problem is how to set qualifier to do natural join like : > A.id = B.id, when I don't have parameters for my qualifier? Is that relation modeled in Entity Modeler? The qualifier to use will depend if the relation is toO

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

On May 12, 2011, at 11:44 AM, naneon.raym...@neuf.fr wrote: > > My problem is this fetch don't use *disctinct* and I have several time the > same student. Simple? fetchEtudiantViaUvDg.setUsesDistinct(true); See: http://developer.apple.com/legacy/mac/library/documentation/InternetWeb/Refere

Re: Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

er to do natural join like : A.id = B.id, when I don't have parameters for my qualifier? i.e : SELECT * FROM GERRY.INDIVIDU t0, GEST_UV.REF_CIVILITE T2, GERRY.IND_EMAIL T3, GERRY.ETU_INSCR_ADM T1 WHERE t0.INDIV_ID = T3.INDIV_ID AND t0.INDIV_ID = T1.ETU_ID AND t0.CIVILITE_$C = T2.CIVILITE_

Re: Tr: Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

cal Robert " > A : naneon.raym...@neuf.fr > Copie à : susanne.schnei...@interactive-systems.de, alexis.t...@gmail.com, > ch...@global-village.net, webobjects-dev@lists.apple.com > Sujet : Re: Fetching on 2 EOMODELS using different schema in DATABASE with > but have relation

Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

eption in thread "WorkerThread0" > com.webobjects.foundation.NSForwardException [java.lang.OutOfMemoryError] > Java heap space:java.lang.OutOfMemoryError: Java heap space > > > > Message du : 11/05/2011 > De : "Susanne Schneider " > A : naneon.raym...@neuf.fr >

Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

HI All, I chosed storedProcedure which is execute database side (to get speed) but I have big problem when I execute it. in my seach Class : private static final String PROCEDURE_NAME = "searchEtudiants"; public static NSMutableDictionary parameters(String pperiode, String pdiplome

Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

Schneider " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship Hi, at least in Oracle it should be possible if you 1) qualify the table name with the schema name, e.g. "b.in

Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

ubject: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship To: naneon.raym...@neuf.fr Cc: WebObjects webobjects-dev Message-ID: Content-Type: text/plain; charset="us-ascii" I think this is something that EOF can't do: qualify across schemas

Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

ip. So in my model "A", I use a fetch spec. on a > table which have the maximum relation with tables in model "A" and "B". > So when I excute my fech spec, WO don't see the schema of model A and show > exception ORA-00942 : table or view does no

Re: Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

OUT to return data. Ray Message du : 10/05/2011 De : "Chuck Hill " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship I thi

Re: Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

relationship. So in my model "A", I use a fetch spec. on a > table which have the maximum relation with tables in model "A" and "B". > So when I excute my fech spec, WO don't see the schema of model A and show > exception ORA-00942 : table or vi

Fetching on 2 EOMODELS using different schema in DATABASE with but have relationship

ec, WO don't see the schema of model A and show exception ORA-00942 : table or view does not exist. This a the querry generate by WO on fetching : "SELECT t0.ANC_UV_OUVERTE_ID, t0.CATEG_ID, t0.CRE_DATE, t0.DIPL_SPEC_$C, t0.DIPLOME_$C, t0.MAJ_AUTEUR, t0.MAJ_DATE, t0.NLE_UV_OUVERTE_ID

Re: Re: fetching on joined table

ooking for ways and John gave me a way Message du : 13/04/2011 De : "John Huss " A : Copie à : naneon.raym...@neuf.fr, webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table IF your data is read-only and you really, really want

Re: fetching on joined table

IF your data is read-only and you really, really want to use a custom SQL statement, then it's ok to fetch raw rows and set the SQL using a hint: String sqlQuery = ... NSMutableDictionary hints = new NSMutableDictionary(); hints.setObjectForKey( sqlQuery, EODatabaseConte

Re: fetching on joined table

>> >> >> Message du : 12/04/2011 >> De : "Chuck Hill " >> A : naneon.raym...@neuf.fr >> Copie à : webobjects-dev@lists.apple.com >> Sujet : Re: fetching on joined table >> >> >> Hi Ray, >>

Re: fetching on joined table

l " > A : naneon.raym...@neuf.fr > Copie à : webobjects-dev@lists.apple.com > Sujet : Re: fetching on joined table > > > Hi Ray, > > WebObjects is not going to generate SQL like that for you (maybe it is > possible, but it would be very difficult). I think that yo

Re: fetching on joined table

ton. > > Thanks > > Ray > > > > > Message du : 12/04/2011 > De : "Chuck Hill " > A : naneon.raym...@neuf.fr > Copie à : webobjects-dev@lists.apple.com > Sujet : Re: fetching on joined table > > > Hi Ray, > > W

Re: Re: fetching on joined table

" A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table Hi Ray, WebObjects is not going to generate SQL like that for you (maybe it is possible, but it would be very difficult).  I think  that you have two choices: 1. Use views 2. Think an

Re: fetching on joined table

n_univ >prd_univ=vtp.prd_fin > ),'N') as IS_STUDENT_TRANSFERED > FROM gest_uv.VUE_PROFIL_PARCOURS vtp, > gerry.diplome d > WHERE vtp.diplome_$c = d.diplome_$c > order by prd_debut, prd_fin; > > So I must fetch on view vue_profil_parcours, dip

Re: Re: fetching on joined table

tdent, teacher so on... I want a example code How to translate this sql request or what the best practice in WebObjects in this situation? To fast forward in my apps, I create view every time when I want to display this kind of information. This allows me to browse my data in an accurate in WebObjects.

Re: fetching on joined table

get my data, I > don't have EOF entities but dictionnaries. > > So I would like to know what the best practice on my case? create view with > my sql request on database and fetching on view in my model? I think the best practice would be to change the model (and the schema too, if ne

Tr: Re: Re: fetching on joined table

sql request on database and fetching on view  in my model? Thanks for your help. Ray Message du : 11/04/2011 De : "Chuck Hill " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table Hello Ray, O

Re: Re: fetching on joined table

sql request on database and fetching on view  in my model? Thanks for your help. Ray Message du : 11/04/2011 De : "Chuck Hill " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table Hello Ray, O

Re: fetching on joined table

Hello Ray, On Apr 8, 2011, at 5:16 PM, naneon.raym...@neuf.fr wrote: > Hi, > > I'm newbie on WebObjects and I have big problem to fetching on joined table. > Example : > I have my SQL like that : A good rule with WebObjects is "If you are thinking about SQL, you are

  1   2   3   >