Kevin Welcome to Cach�.
Check these out. A) General Cache - Java Reference C:\CacheSys\Dev\Java\doc\index.html B) Connecting to Cache C:\CacheSys\Dev\Java\doc\com\intersys\objects\Database.html C) DOCUMENTATION http://127.0.0.1:1972/csp/docbook/DocBook.UI.Page.cls?KEY=GCJB Sukesh Hoogan e-Linear Enterprise Solutions Bombay, India http://personal.vsnl.com/sukesh_hoogan Kevin Roke <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi All, > > I am a relative newbie to using databases in general so this problem may > seem trivial! > > 1. I am writing a Java application that accesses data stored in a Microsoft > Access database. The database contains horseracing results and I am trying > to determine if I can transfer the data to a Cache database and use Java > projection to simplify/speed up the application performance. > > 2. One of the tables in Access holds individual race information, related to > this is a separate table of non-runners. Each row consists of the race ID > value (of the race where non-runners were recorded), horse ID value (of the > horse that didn't run) and its non-run reason, thus several rows of the > table can refer to one race if more than one horse was declared a > non-runner. > > 3. To simplify the access of non-runner information from the race, I am > trying to embed the horse ID and reason fields into another class the Race > class in the form of an array, thus removing the need for the non-runner > table (class). > > 4. I have designed a NonRunner (serialisable) class which contains two > properties; the horse ID and the reason and included an array of NonRunner > objects in the Race class (I suppose I could use a multi dimension array > but, Hey! I'm using Java and I want to use objects as much as possible). I > am able to instantiate the NonRunner objects and set their properties, but I > can't seem to be able to place them into the Race NonRunner array in either > Java or using the Cache terminal. > > 5. The documentation seems a little sparse as far as Java is concerned and I > don't seem to be able to use > do race.NonRunners.InsertObject(nr, 0) > in the Cache terminal. > > 6. Also I notice that there are deprecated classes in the Java projections > for the array and list properties, does anyone know if this is to be updated > anytime soon? > > I have spent several hours looking at the on-line documentation and I have > looked through the postings but there seems to be nothing that relates > directly to my needs (perhaps I can't see the wood for the trees!). > > Can anyone help please? > > Thanks in advance > > Regards > > Kevin > >
