You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tuscany.apache.org by Adriano Crestani <ad...@apache.org> on 2007/05/20 10:19:32 UTC

DAS C++ Status

Actually is being developed the Tuscany DAS C++. So far, the framework can
perform the following:

- Convetion Over Configuration(COC):

   - DAS assumes that a column named xxx_id is a FK to the column named
   id on table xxx.
   - If no PK column is found on the ResultSet, it sets the column named
   id as PK, if exists.
   - The COCs defined above are, actually, case sensitive and, for
   example, a column named ID will not be set as PK


- The das is using the ResultSet metadata(column name, column data type and
column table) to generate the sdo graph and popule it. The DAS guarantees
the table object uniqueness on graph basing on the table PK, so the first
table retrieved by the ResultSet will be taken, and any other table
containing the same PK ignored:


   - A table may contain a simple PK or a composite one.
   - If no PK is defined for the table, the DAS tries to find one using
   COC.
   - If the table has a composite PK and not all the columns that
   compound the PK are contained on the ResultSet, the DAS ignores the defined
   composite PK and tries to find another PK using COC as defined above.
   - If no PK is found using COC, the DAS sets all columns on ResultSet
   as PK.

- Setting the references on graph objects basing on table relationships.

   - Actually, there may be up to 1 relationship between 2 tables.
   - The columns data that compound the FK are not created on the graph.
   - The DAS accepts simple or composite relationships.
   - If not all the columns, PK or FK, that compound the relationship are
   on the ResultSet, the relationship is ignored and the remaining FK are
   loaded onto graph.

- Actually, the DAS config can only be set from code.

- There are also implemented some testcases.

- DAS is only supporting the following SQL types: INTEGER, REAL, CHAR,
VARCHAR, FLOAT, DOUBLE.

Next steps:

- Read the config from a xml file.

- To implement a sample that reads some data from a database and print on
console.

- Implement support for more SQL types.


Comments and suggestions will be appreciated : )

Any volunteer would be helpful ; )


Regards,

Adriano Crestani

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
The SimpleRead sample was remade and renamed to CompanySamples. Not it
demonstrates not only how to load data from rdb to SDO graph, but how to
modify the graph and apply the changes back to the rdb.

DAS GettingInvolved and sample Readme are updated to these new changes.

Adriano Crestani

On 10/15/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Commands can now be loaded from a config file.
>
> Adriano Crestani
>
> On 10/15/07, Adriano Crestani <adrianocrestani@apache.org > wrote:
> >
> > -DAS is now supporing all CRUD operations.
> > -Optimistic Concurrency Control is now implemented on DAS
> > -testcases are now being tested using postgres rdbms and not firebird
> > anymore, once its odbc driver is more stable
> >
> > Adriano Crestani
> >
> > On 10/1/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > >
> > > Native DAS provides now a new build infrastructure using ant that is
> > > also being used by Native SCA and SDO.
> > >
> > > Adriano Crestani
> > >
> > > On 7/21/07, Adriano Crestani <ad...@apache.org> wrote:
> > > >
> > > > DAS C++ has now its own exceptions, such as
> > > > DASInvalidTypeNameException, DASInvalidPropertyNameException,
> > > > DASNullPointerException, DASColumnNotFoundException,
> > > > DASInvalidColumnNameException, DASInvalidRelationshipNameException,
> > > > DASInvalidSQLTypeException and DASInvalidTableNameException.
> > > >
> > > > Adriano Crestani
> > > >
> > > > On 7/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > >
> > > > > DAS C++ is now non-case sensitive, once most dbms are non-case
> > > > > sensitive, DAS C++ will be so, at least for now. Maybe on future, there can
> > > > > be added an option on config file that set DAS as case sensitive.
> > > > >
> > > > > All type and property names are converted to lower case when the
> > > > > SDO graph is created.
> > > > >
> > > > > Regards,
> > > > > Adriano Crestani
> > > > >
> > > > > On 6/26/07, Luciano Resende < luckbr1975@gmail.com> wrote:
> > > > > >
> > > > > > Hey, very good, once this is available under the wiki, you
> > > > > > probably
> > > > > > should also send an e-mail to the user list.
> > > > > >
> > > > > > On 6/25/07, Adriano Crestani < adrianocrestani@apache.org >
> > > > > > wrote:
> > > > > > > Added DAS C++ GettingStarted.html document and the first DAS
> > > > > > C++ sample
> > > > > > > under revision 550697.
> > > > > > >
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > > > On 6/6/07, Adriano Crestani < adrianocrestani@apache.org>
> > > > > > wrote:
> > > > > > > >
> > > > > > > > DAS is no longer needing the config.xsd to read xml
> > > > > > configuration files
> > > > > > > > since revision 544749.
> > > > > > > >
> > > > > > > > Adriano Crestani
> > > > > > > >
> > > > > > > > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org>
> > > > > > wrote:
> > > > > > > > >
> > > > > > > > > Since revision 542742, DAS C++ is only working with SDO on
> > > > > > trunk, and
> > > > > > > > > not with SDO C++ M3.
> > > > > > > > >
> > > > > > > > > Adriano Crestani
> > > > > > > > >
> > > > > > > > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org >
> > > > > > wrote:
> > > > > > > > > >
> > > > > > > > > > Added support to one to many relationship under revision
> > > > > > 542742
> > > > > > > > > >
> > > > > > > > > > Adriano Crestani
> > > > > > > > > >
> > > > > > > > > > On 5/28/07, Adriano Crestani <
> > > > > > adrianocrestani@apache.org> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Added support to set up the framework via config xml
> > > > > > under revision
> > > > > > > > > > > 542124.
> > > > > > > > > > >
> > > > > > > > > > > Adriano Crestani
> > > > > > > > > > >
> > > > > > > > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > Thank you for the explanation.
> > > > > > > > > > > >
> > > > > > > > > > > > On 5/21/07, Adriano Crestani <
> > > > > > adrianocrestani@apache.org> wrote:
> > > > > > > > > > > > >
> > > > > > > > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Next step is to implement a sample for it.
> > > > > > > > > > > > >
> > > > > > > > > > > > > I intend to add some info on wiki before the first
> > > > > > release.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Regards,
> > > > > > > > > > > > > Adriano Crestani
> > > > > > > > > > > > >
> > > > > > > > > > > > > On 5/21/07, haleh mahbod < hmahbod@gmail.com >
> > > > > > wrote:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Hi Adriano,
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Is this integrated with SDO C++?  Is there a
> > > > > > sample for it?
> > > > > > > > > > > > > > Can more information be added to the home page
> > > > > > and  user
> > > > > > > > > > > > guide[1]?
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > [1]
> > > > > > > > > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Haleh
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > On 5/20/07, Adriano Crestani <
> > > > > > adrianocrestani@apache.org >
> > > > > > > > > > > > wrote:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Actually is being developed the Tuscany DAS
> > > > > > C++. So far, the
> > > > > > > > > > > > framework
> > > > > > > > > > > > > > can
> > > > > > > > > > > > > > > perform the following:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >    - DAS assumes that a column named xxx_id is
> > > > > > a FK to the
> > > > > > > > > > > > column
> > > > > > > > > > > > > named
> > > > > > > > > > > > > > >    id on table xxx.
> > > > > > > > > > > > > > >    - If no PK column is found on the
> > > > > > ResultSet, it sets the
> > > > > > > > > > > > column
> > > > > > > > > > > > > named
> > > > > > > > > > > > > > >    id as PK, if exists.
> > > > > > > > > > > > > > >    - The COCs defined above are, actually,
> > > > > > case sensitive
> > > > > > > > > > > > and, for
> > > > > > > > > > > > > > >    example, a column named ID will not be set
> > > > > > as PK
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - The das is using the ResultSet
> > > > > > metadata(column name,
> > > > > > > > > > > > column data
> > > > > > > > > > > > > type
> > > > > > > > > > > > > > > and
> > > > > > > > > > > > > > > column table) to generate the sdo graph and
> > > > > > popule it. The
> > > > > > > > > > > > DAS
> > > > > > > > > > > > > > guarantees
> > > > > > > > > > > > > > > the table object uniqueness on graph basing on
> > > > > > the table PK,
> > > > > > > > > > > > so the
> > > > > > > > > > > > > > first
> > > > > > > > > > > > > > > table retrieved by the ResultSet will be
> > > > > > taken, and any
> > > > > > > > > > > > other table
> > > > > > > > > > > > > > > containing the same PK ignored:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >    - A table may contain a simple PK or a
> > > > > > composite one.
> > > > > > > > > > > > > > >    - If no PK is defined for the table, the
> > > > > > DAS tries to
> > > > > > > > > > > > find one
> > > > > > > > > > > > > using
> > > > > > > > > > > > > > >    COC.
> > > > > > > > > > > > > > >    - If the table has a composite PK and not
> > > > > > all the columns
> > > > > > > > > > > > that
> > > > > > > > > > > > > > >    compound the PK are contained on the
> > > > > > ResultSet, the DAS
> > > > > > > > > > > > ignores the
> > > > > > > > > > > > > > > defined
> > > > > > > > > > > > > > >    composite PK and tries to find another PK
> > > > > > using COC as
> > > > > > > > > > > > defined
> > > > > > > > > > > > > above.
> > > > > > > > > > > > > > >    - If no PK is found using COC, the DAS sets
> > > > > > all columns
> > > > > > > > > > > > on
> > > > > > > > > > > > > ResultSet
> > > > > > > > > > > > > > >    as PK.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - Setting the references on graph objects
> > > > > > basing on table
> > > > > > > > > > > > > relationships.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >    - Actually, there may be up to 1
> > > > > > relationship between 2
> > > > > > > > > > > > tables.
> > > > > > > > > > > > > > >    - The columns data that compound the FK are
> > > > > > not created
> > > > > > > > > > > > on the
> > > > > > > > > > > > > graph.
> > > > > > > > > > > > > > >    - The DAS accepts simple or composite
> > > > > > relationships.
> > > > > > > > > > > > > > >    - If not all the columns, PK or FK, that
> > > > > > compound the
> > > > > > > > > > > > relationship
> > > > > > > > > > > > > > are
> > > > > > > > > > > > > > >    on the ResultSet, the relationship is
> > > > > > ignored and the
> > > > > > > > > > > > remaining FK
> > > > > > > > > > > > > > are
> > > > > > > > > > > > > > >    loaded onto graph.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - Actually, the DAS config can only be set
> > > > > > from code.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - There are also implemented some testcases.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - DAS is only supporting the following SQL
> > > > > > types: INTEGER,
> > > > > > > > > > > > REAL, CHAR,
> > > > > > > > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Next steps:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - Read the config from a xml file.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - To implement a sample that reads some data
> > > > > > from a database
> > > > > > > > > > > > and print
> > > > > > > > > > > > > > on
> > > > > > > > > > > > > > > console.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > - Implement support for more SQL types.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Comments and suggestions will be appreciated :
> > > > > > )
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Regards,
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Adriano Crestani
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Luciano Resende
> > > > > > Apache Tuscany Committer
> > > > > > http://people.apache.org/~lresende<http://people.apache.org/%7Elresende>
> > > > > > http://lresende.blogspot.com/
> > > > > >
> > > > > > ---------------------------------------------------------------------
> > > > > >
> > > > > > To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> > > > > > For additional commands, e-mail: tuscany-dev-help@ws.apache.org
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Commands can now be loaded from a config file.

Adriano Crestani

On 10/15/07, Adriano Crestani <ad...@apache.org> wrote:
>
> -DAS is now supporing all CRUD operations.
> -Optimistic Concurrency Control is now implemented on DAS
> -testcases are now being tested using postgres rdbms and not firebird
> anymore, once its odbc driver is more stable
>
> Adriano Crestani
>
> On 10/1/07, Adriano Crestani <ad...@apache.org> wrote:
> >
> > Native DAS provides now a new build infrastructure using ant that is
> > also being used by Native SCA and SDO.
> >
> > Adriano Crestani
> >
> > On 7/21/07, Adriano Crestani <ad...@apache.org> wrote:
> > >
> > > DAS C++ has now its own exceptions, such as
> > > DASInvalidTypeNameException, DASInvalidPropertyNameException,
> > > DASNullPointerException, DASColumnNotFoundException,
> > > DASInvalidColumnNameException, DASInvalidRelationshipNameException,
> > > DASInvalidSQLTypeException and DASInvalidTableNameException.
> > >
> > > Adriano Crestani
> > >
> > > On 7/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > >
> > > > DAS C++ is now non-case sensitive, once most dbms are non-case
> > > > sensitive, DAS C++ will be so, at least for now. Maybe on future, there can
> > > > be added an option on config file that set DAS as case sensitive.
> > > >
> > > > All type and property names are converted to lower case when the SDO
> > > > graph is created.
> > > >
> > > > Regards,
> > > > Adriano Crestani
> > > >
> > > > On 6/26/07, Luciano Resende < luckbr1975@gmail.com> wrote:
> > > > >
> > > > > Hey, very good, once this is available under the wiki, you
> > > > > probably
> > > > > should also send an e-mail to the user list.
> > > > >
> > > > > On 6/25/07, Adriano Crestani < adrianocrestani@apache.org > wrote:
> > > > > > Added DAS C++ GettingStarted.html document and the first DAS C++
> > > > > sample
> > > > > > under revision 550697.
> > > > > >
> > > > > > Adriano Crestani
> > > > > >
> > > > > > On 6/6/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > > > >
> > > > > > > DAS is no longer needing the config.xsd to read xml
> > > > > configuration files
> > > > > > > since revision 544749.
> > > > > > >
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > > > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org>
> > > > > wrote:
> > > > > > > >
> > > > > > > > Since revision 542742, DAS C++ is only working with SDO on
> > > > > trunk, and
> > > > > > > > not with SDO C++ M3.
> > > > > > > >
> > > > > > > > Adriano Crestani
> > > > > > > >
> > > > > > > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org >
> > > > > wrote:
> > > > > > > > >
> > > > > > > > > Added support to one to many relationship under revision
> > > > > 542742
> > > > > > > > >
> > > > > > > > > Adriano Crestani
> > > > > > > > >
> > > > > > > > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org>
> > > > > wrote:
> > > > > > > > > >
> > > > > > > > > > Added support to set up the framework via config xml
> > > > > under revision
> > > > > > > > > > 542124.
> > > > > > > > > >
> > > > > > > > > > Adriano Crestani
> > > > > > > > > >
> > > > > > > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Thank you for the explanation.
> > > > > > > > > > >
> > > > > > > > > > > On 5/21/07, Adriano Crestani <
> > > > > adrianocrestani@apache.org> wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > > > > > > >
> > > > > > > > > > > > Next step is to implement a sample for it.
> > > > > > > > > > > >
> > > > > > > > > > > > I intend to add some info on wiki before the first
> > > > > release.
> > > > > > > > > > > >
> > > > > > > > > > > > Regards,
> > > > > > > > > > > > Adriano Crestani
> > > > > > > > > > > >
> > > > > > > > > > > > On 5/21/07, haleh mahbod < hmahbod@gmail.com >
> > > > > wrote:
> > > > > > > > > > > > >
> > > > > > > > > > > > > Hi Adriano,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Is this integrated with SDO C++?  Is there a
> > > > > sample for it?
> > > > > > > > > > > > > Can more information be added to the home page
> > > > > and  user
> > > > > > > > > > > guide[1]?
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > [1]
> > > > > > > > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > > >
> > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Haleh
> > > > > > > > > > > > >
> > > > > > > > > > > > > On 5/20/07, Adriano Crestani <
> > > > > adrianocrestani@apache.org >
> > > > > > > > > > > wrote:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Actually is being developed the Tuscany DAS C++.
> > > > > So far, the
> > > > > > > > > > > framework
> > > > > > > > > > > > > can
> > > > > > > > > > > > > > perform the following:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >    - DAS assumes that a column named xxx_id is a
> > > > > FK to the
> > > > > > > > > > > column
> > > > > > > > > > > > named
> > > > > > > > > > > > > >    id on table xxx.
> > > > > > > > > > > > > >    - If no PK column is found on the ResultSet,
> > > > > it sets the
> > > > > > > > > > > column
> > > > > > > > > > > > named
> > > > > > > > > > > > > >    id as PK, if exists.
> > > > > > > > > > > > > >    - The COCs defined above are, actually, case
> > > > > sensitive
> > > > > > > > > > > and, for
> > > > > > > > > > > > > >    example, a column named ID will not be set as
> > > > > PK
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - The das is using the ResultSet metadata(column
> > > > > name,
> > > > > > > > > > > column data
> > > > > > > > > > > > type
> > > > > > > > > > > > > > and
> > > > > > > > > > > > > > column table) to generate the sdo graph and
> > > > > popule it. The
> > > > > > > > > > > DAS
> > > > > > > > > > > > > guarantees
> > > > > > > > > > > > > > the table object uniqueness on graph basing on
> > > > > the table PK,
> > > > > > > > > > > so the
> > > > > > > > > > > > > first
> > > > > > > > > > > > > > table retrieved by the ResultSet will be taken,
> > > > > and any
> > > > > > > > > > > other table
> > > > > > > > > > > > > > containing the same PK ignored:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >    - A table may contain a simple PK or a
> > > > > composite one.
> > > > > > > > > > > > > >    - If no PK is defined for the table, the DAS
> > > > > tries to
> > > > > > > > > > > find one
> > > > > > > > > > > > using
> > > > > > > > > > > > > >    COC.
> > > > > > > > > > > > > >    - If the table has a composite PK and not all
> > > > > the columns
> > > > > > > > > > > that
> > > > > > > > > > > > > >    compound the PK are contained on the
> > > > > ResultSet, the DAS
> > > > > > > > > > > ignores the
> > > > > > > > > > > > > > defined
> > > > > > > > > > > > > >    composite PK and tries to find another PK
> > > > > using COC as
> > > > > > > > > > > defined
> > > > > > > > > > > > above.
> > > > > > > > > > > > > >    - If no PK is found using COC, the DAS sets
> > > > > all columns
> > > > > > > > > > > on
> > > > > > > > > > > > ResultSet
> > > > > > > > > > > > > >    as PK.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - Setting the references on graph objects basing
> > > > > on table
> > > > > > > > > > > > relationships.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >    - Actually, there may be up to 1 relationship
> > > > > between 2
> > > > > > > > > > > tables.
> > > > > > > > > > > > > >    - The columns data that compound the FK are
> > > > > not created
> > > > > > > > > > > on the
> > > > > > > > > > > > graph.
> > > > > > > > > > > > > >    - The DAS accepts simple or composite
> > > > > relationships.
> > > > > > > > > > > > > >    - If not all the columns, PK or FK, that
> > > > > compound the
> > > > > > > > > > > relationship
> > > > > > > > > > > > > are
> > > > > > > > > > > > > >    on the ResultSet, the relationship is ignored
> > > > > and the
> > > > > > > > > > > remaining FK
> > > > > > > > > > > > > are
> > > > > > > > > > > > > >    loaded onto graph.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - Actually, the DAS config can only be set from
> > > > > code.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - There are also implemented some testcases.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - DAS is only supporting the following SQL
> > > > > types: INTEGER,
> > > > > > > > > > > REAL, CHAR,
> > > > > > > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Next steps:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - Read the config from a xml file.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - To implement a sample that reads some data
> > > > > from a database
> > > > > > > > > > > and print
> > > > > > > > > > > > > on
> > > > > > > > > > > > > > console.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > - Implement support for more SQL types.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Regards,
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Adriano Crestani
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Luciano Resende
> > > > > Apache Tuscany Committer
> > > > > http://people.apache.org/~lresende<http://people.apache.org/%7Elresende>
> > > > > http://lresende.blogspot.com/
> > > > >
> > > > > ---------------------------------------------------------------------
> > > > >
> > > > > To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> > > > > For additional commands, e-mail: tuscany-dev-help@ws.apache.org
> > > > >
> > > > >
> > > >
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
-DAS is now supporing all CRUD operations.
-Optimistic Concurrency Control is now implemented on DAS
-testcases are now being tested using postgres rdbms and not firebird
anymore, once its odbc driver is more stable

Adriano Crestani

On 10/1/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Native DAS provides now a new build infrastructure using ant that is also
> being used by Native SCA and SDO.
>
> Adriano Crestani
>
> On 7/21/07, Adriano Crestani <ad...@apache.org> wrote:
> >
> > DAS C++ has now its own exceptions, such as DASInvalidTypeNameException,
> > DASInvalidPropertyNameException, DASNullPointerException,
> > DASColumnNotFoundException, DASInvalidColumnNameException,
> > DASInvalidRelationshipNameException, DASInvalidSQLTypeException and
> > DASInvalidTableNameException.
> >
> > Adriano Crestani
> >
> > On 7/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > >
> > > DAS C++ is now non-case sensitive, once most dbms are non-case
> > > sensitive, DAS C++ will be so, at least for now. Maybe on future, there can
> > > be added an option on config file that set DAS as case sensitive.
> > >
> > > All type and property names are converted to lower case when the SDO
> > > graph is created.
> > >
> > > Regards,
> > > Adriano Crestani
> > >
> > > On 6/26/07, Luciano Resende < luckbr1975@gmail.com> wrote:
> > > >
> > > > Hey, very good, once this is available under the wiki, you probably
> > > > should also send an e-mail to the user list.
> > > >
> > > > On 6/25/07, Adriano Crestani < adrianocrestani@apache.org > wrote:
> > > > > Added DAS C++ GettingStarted.html document and the first DAS C++
> > > > sample
> > > > > under revision 550697.
> > > > >
> > > > > Adriano Crestani
> > > > >
> > > > > On 6/6/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > > >
> > > > > > DAS is no longer needing the config.xsd to read xml
> > > > configuration files
> > > > > > since revision 544749.
> > > > > >
> > > > > > Adriano Crestani
> > > > > >
> > > > > > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org>
> > > > wrote:
> > > > > > >
> > > > > > > Since revision 542742, DAS C++ is only working with SDO on
> > > > trunk, and
> > > > > > > not with SDO C++ M3.
> > > > > > >
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org >
> > > > wrote:
> > > > > > > >
> > > > > > > > Added support to one to many relationship under revision
> > > > 542742
> > > > > > > >
> > > > > > > > Adriano Crestani
> > > > > > > >
> > > > > > > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org>
> > > > wrote:
> > > > > > > > >
> > > > > > > > > Added support to set up the framework via config xml under
> > > > revision
> > > > > > > > > 542124.
> > > > > > > > >
> > > > > > > > > Adriano Crestani
> > > > > > > > >
> > > > > > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > > > > > >
> > > > > > > > > > Thank you for the explanation.
> > > > > > > > > >
> > > > > > > > > > On 5/21/07, Adriano Crestani <
> > > > adrianocrestani@apache.org> wrote:
> > > > > > > > > > >
> > > > > > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > > > > > >
> > > > > > > > > > > Next step is to implement a sample for it.
> > > > > > > > > > >
> > > > > > > > > > > I intend to add some info on wiki before the first
> > > > release.
> > > > > > > > > > >
> > > > > > > > > > > Regards,
> > > > > > > > > > > Adriano Crestani
> > > > > > > > > > >
> > > > > > > > > > > On 5/21/07, haleh mahbod < hmahbod@gmail.com > wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > Hi Adriano,
> > > > > > > > > > > >
> > > > > > > > > > > > Is this integrated with SDO C++?  Is there a sample
> > > > for it?
> > > > > > > > > > > > Can more information be added to the home page
> > > > and  user
> > > > > > > > > > guide[1]?
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > [1]
> > > > > > > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > >
> > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Haleh
> > > > > > > > > > > >
> > > > > > > > > > > > On 5/20/07, Adriano Crestani <
> > > > adrianocrestani@apache.org >
> > > > > > > > > > wrote:
> > > > > > > > > > > > >
> > > > > > > > > > > > > Actually is being developed the Tuscany DAS C++.
> > > > So far, the
> > > > > > > > > > framework
> > > > > > > > > > > > can
> > > > > > > > > > > > > perform the following:
> > > > > > > > > > > > >
> > > > > > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > > > > > >
> > > > > > > > > > > > >    - DAS assumes that a column named xxx_id is a
> > > > FK to the
> > > > > > > > > > column
> > > > > > > > > > > named
> > > > > > > > > > > > >    id on table xxx.
> > > > > > > > > > > > >    - If no PK column is found on the ResultSet, it
> > > > sets the
> > > > > > > > > > column
> > > > > > > > > > > named
> > > > > > > > > > > > >    id as PK, if exists.
> > > > > > > > > > > > >    - The COCs defined above are, actually, case
> > > > sensitive
> > > > > > > > > > and, for
> > > > > > > > > > > > >    example, a column named ID will not be set as
> > > > PK
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > - The das is using the ResultSet metadata(column
> > > > name,
> > > > > > > > > > column data
> > > > > > > > > > > type
> > > > > > > > > > > > > and
> > > > > > > > > > > > > column table) to generate the sdo graph and popule
> > > > it. The
> > > > > > > > > > DAS
> > > > > > > > > > > > guarantees
> > > > > > > > > > > > > the table object uniqueness on graph basing on the
> > > > table PK,
> > > > > > > > > > so the
> > > > > > > > > > > > first
> > > > > > > > > > > > > table retrieved by the ResultSet will be taken,
> > > > and any
> > > > > > > > > > other table
> > > > > > > > > > > > > containing the same PK ignored:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >    - A table may contain a simple PK or a
> > > > composite one.
> > > > > > > > > > > > >    - If no PK is defined for the table, the DAS
> > > > tries to
> > > > > > > > > > find one
> > > > > > > > > > > using
> > > > > > > > > > > > >    COC.
> > > > > > > > > > > > >    - If the table has a composite PK and not all
> > > > the columns
> > > > > > > > > > that
> > > > > > > > > > > > >    compound the PK are contained on the ResultSet,
> > > > the DAS
> > > > > > > > > > ignores the
> > > > > > > > > > > > > defined
> > > > > > > > > > > > >    composite PK and tries to find another PK using
> > > > COC as
> > > > > > > > > > defined
> > > > > > > > > > > above.
> > > > > > > > > > > > >    - If no PK is found using COC, the DAS sets all
> > > > columns
> > > > > > > > > > on
> > > > > > > > > > > ResultSet
> > > > > > > > > > > > >    as PK.
> > > > > > > > > > > > >
> > > > > > > > > > > > > - Setting the references on graph objects basing
> > > > on table
> > > > > > > > > > > relationships.
> > > > > > > > > > > > >
> > > > > > > > > > > > >    - Actually, there may be up to 1 relationship
> > > > between 2
> > > > > > > > > > tables.
> > > > > > > > > > > > >    - The columns data that compound the FK are not
> > > > created
> > > > > > > > > > on the
> > > > > > > > > > > graph.
> > > > > > > > > > > > >    - The DAS accepts simple or composite
> > > > relationships.
> > > > > > > > > > > > >    - If not all the columns, PK or FK, that
> > > > compound the
> > > > > > > > > > relationship
> > > > > > > > > > > > are
> > > > > > > > > > > > >    on the ResultSet, the relationship is ignored
> > > > and the
> > > > > > > > > > remaining FK
> > > > > > > > > > > > are
> > > > > > > > > > > > >    loaded onto graph.
> > > > > > > > > > > > >
> > > > > > > > > > > > > - Actually, the DAS config can only be set from
> > > > code.
> > > > > > > > > > > > >
> > > > > > > > > > > > > - There are also implemented some testcases.
> > > > > > > > > > > > >
> > > > > > > > > > > > > - DAS is only supporting the following SQL types:
> > > > INTEGER,
> > > > > > > > > > REAL, CHAR,
> > > > > > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Next steps:
> > > > > > > > > > > > >
> > > > > > > > > > > > > - Read the config from a xml file.
> > > > > > > > > > > > >
> > > > > > > > > > > > > - To implement a sample that reads some data from
> > > > a database
> > > > > > > > > > and print
> > > > > > > > > > > > on
> > > > > > > > > > > > > console.
> > > > > > > > > > > > >
> > > > > > > > > > > > > - Implement support for more SQL types.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > > > > > > >
> > > > > > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Regards,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Adriano Crestani
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Luciano Resende
> > > > Apache Tuscany Committer
> > > > http://people.apache.org/~lresende<http://people.apache.org/%7Elresende>
> > > > http://lresende.blogspot.com/
> > > >
> > > > ---------------------------------------------------------------------
> > > >
> > > > To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> > > > For additional commands, e-mail: tuscany-dev-help@ws.apache.org
> > > >
> > > >
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Native DAS provides now a new build infrastructure using ant that is also
being used by Native SCA and SDO.

Adriano Crestani

On 7/21/07, Adriano Crestani <ad...@apache.org> wrote:
>
> DAS C++ has now its own exceptions, such as DASInvalidTypeNameException,
> DASInvalidPropertyNameException, DASNullPointerException,
> DASColumnNotFoundException, DASInvalidColumnNameException,
> DASInvalidRelationshipNameException, DASInvalidSQLTypeException and
> DASInvalidTableNameException.
>
> Adriano Crestani
>
> On 7/21/07, Adriano Crestani <ad...@apache.org> wrote:
> >
> > DAS C++ is now non-case sensitive, once most dbms are non-case
> > sensitive, DAS C++ will be so, at least for now. Maybe on future, there can
> > be added an option on config file that set DAS as case sensitive.
> >
> > All type and property names are converted to lower case when the SDO
> > graph is created.
> >
> > Regards,
> > Adriano Crestani
> >
> > On 6/26/07, Luciano Resende < luckbr1975@gmail.com> wrote:
> > >
> > > Hey, very good, once this is available under the wiki, you probably
> > > should also send an e-mail to the user list.
> > >
> > > On 6/25/07, Adriano Crestani < adrianocrestani@apache.org > wrote:
> > > > Added DAS C++ GettingStarted.html document and the first DAS C++
> > > sample
> > > > under revision 550697.
> > > >
> > > > Adriano Crestani
> > > >
> > > > On 6/6/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > >
> > > > > DAS is no longer needing the config.xsd to read xml configuration
> > > files
> > > > > since revision 544749.
> > > > >
> > > > > Adriano Crestani
> > > > >
> > > > > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > > >
> > > > > > Since revision 542742, DAS C++ is only working with SDO on
> > > trunk, and
> > > > > > not with SDO C++ M3.
> > > > > >
> > > > > > Adriano Crestani
> > > > > >
> > > > > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org >
> > > wrote:
> > > > > > >
> > > > > > > Added support to one to many relationship under revision
> > > 542742
> > > > > > >
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org>
> > > wrote:
> > > > > > > >
> > > > > > > > Added support to set up the framework via config xml under
> > > revision
> > > > > > > > 542124.
> > > > > > > >
> > > > > > > > Adriano Crestani
> > > > > > > >
> > > > > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > Thank you for the explanation.
> > > > > > > > >
> > > > > > > > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org>
> > > wrote:
> > > > > > > > > >
> > > > > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > > > > >
> > > > > > > > > > Next step is to implement a sample for it.
> > > > > > > > > >
> > > > > > > > > > I intend to add some info on wiki before the first
> > > release.
> > > > > > > > > >
> > > > > > > > > > Regards,
> > > > > > > > > > Adriano Crestani
> > > > > > > > > >
> > > > > > > > > > On 5/21/07, haleh mahbod < hmahbod@gmail.com > wrote:
> > > > > > > > > > >
> > > > > > > > > > > Hi Adriano,
> > > > > > > > > > >
> > > > > > > > > > > Is this integrated with SDO C++?  Is there a sample
> > > for it?
> > > > > > > > > > > Can more information be added to the home page
> > > and  user
> > > > > > > > > guide[1]?
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > [1]
> > > > > > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > >
> > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Haleh
> > > > > > > > > > >
> > > > > > > > > > > On 5/20/07, Adriano Crestani <
> > > adrianocrestani@apache.org >
> > > > > > > > > wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > Actually is being developed the Tuscany DAS C++. So
> > > far, the
> > > > > > > > > framework
> > > > > > > > > > > can
> > > > > > > > > > > > perform the following:
> > > > > > > > > > > >
> > > > > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > > > > >
> > > > > > > > > > > >    - DAS assumes that a column named xxx_id is a FK
> > > to the
> > > > > > > > > column
> > > > > > > > > > named
> > > > > > > > > > > >    id on table xxx.
> > > > > > > > > > > >    - If no PK column is found on the ResultSet, it
> > > sets the
> > > > > > > > > column
> > > > > > > > > > named
> > > > > > > > > > > >    id as PK, if exists.
> > > > > > > > > > > >    - The COCs defined above are, actually, case
> > > sensitive
> > > > > > > > > and, for
> > > > > > > > > > > >    example, a column named ID will not be set as PK
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > - The das is using the ResultSet metadata(column
> > > name,
> > > > > > > > > column data
> > > > > > > > > > type
> > > > > > > > > > > > and
> > > > > > > > > > > > column table) to generate the sdo graph and popule
> > > it. The
> > > > > > > > > DAS
> > > > > > > > > > > guarantees
> > > > > > > > > > > > the table object uniqueness on graph basing on the
> > > table PK,
> > > > > > > > > so the
> > > > > > > > > > > first
> > > > > > > > > > > > table retrieved by the ResultSet will be taken, and
> > > any
> > > > > > > > > other table
> > > > > > > > > > > > containing the same PK ignored:
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >    - A table may contain a simple PK or a composite
> > > one.
> > > > > > > > > > > >    - If no PK is defined for the table, the DAS
> > > tries to
> > > > > > > > > find one
> > > > > > > > > > using
> > > > > > > > > > > >    COC.
> > > > > > > > > > > >    - If the table has a composite PK and not all the
> > > columns
> > > > > > > > > that
> > > > > > > > > > > >    compound the PK are contained on the ResultSet,
> > > the DAS
> > > > > > > > > ignores the
> > > > > > > > > > > > defined
> > > > > > > > > > > >    composite PK and tries to find another PK using
> > > COC as
> > > > > > > > > defined
> > > > > > > > > > above.
> > > > > > > > > > > >    - If no PK is found using COC, the DAS sets all
> > > columns
> > > > > > > > > on
> > > > > > > > > > ResultSet
> > > > > > > > > > > >    as PK.
> > > > > > > > > > > >
> > > > > > > > > > > > - Setting the references on graph objects basing on
> > > table
> > > > > > > > > > relationships.
> > > > > > > > > > > >
> > > > > > > > > > > >    - Actually, there may be up to 1 relationship
> > > between 2
> > > > > > > > > tables.
> > > > > > > > > > > >    - The columns data that compound the FK are not
> > > created
> > > > > > > > > on the
> > > > > > > > > > graph.
> > > > > > > > > > > >    - The DAS accepts simple or composite
> > > relationships.
> > > > > > > > > > > >    - If not all the columns, PK or FK, that compound
> > > the
> > > > > > > > > relationship
> > > > > > > > > > > are
> > > > > > > > > > > >    on the ResultSet, the relationship is ignored and
> > > the
> > > > > > > > > remaining FK
> > > > > > > > > > > are
> > > > > > > > > > > >    loaded onto graph.
> > > > > > > > > > > >
> > > > > > > > > > > > - Actually, the DAS config can only be set from
> > > code.
> > > > > > > > > > > >
> > > > > > > > > > > > - There are also implemented some testcases.
> > > > > > > > > > > >
> > > > > > > > > > > > - DAS is only supporting the following SQL types:
> > > INTEGER,
> > > > > > > > > REAL, CHAR,
> > > > > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > > > > >
> > > > > > > > > > > > Next steps:
> > > > > > > > > > > >
> > > > > > > > > > > > - Read the config from a xml file.
> > > > > > > > > > > >
> > > > > > > > > > > > - To implement a sample that reads some data from a
> > > database
> > > > > > > > > and print
> > > > > > > > > > > on
> > > > > > > > > > > > console.
> > > > > > > > > > > >
> > > > > > > > > > > > - Implement support for more SQL types.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > > > > > >
> > > > > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Regards,
> > > > > > > > > > > >
> > > > > > > > > > > > Adriano Crestani
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> > > --
> > > Luciano Resende
> > > Apache Tuscany Committer
> > > http://people.apache.org/~lresende<http://people.apache.org/%7Elresende>
> > > http://lresende.blogspot.com/
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> > > For additional commands, e-mail: tuscany-dev-help@ws.apache.org
> > >
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
DAS C++ has now its own exceptions, such as DASInvalidTypeNameException,
DASInvalidPropertyNameException, DASNullPointerException,
DASColumnNotFoundException, DASInvalidColumnNameException,
DASInvalidRelationshipNameException, DASInvalidSQLTypeException and
DASInvalidTableNameException.

Adriano Crestani

On 7/21/07, Adriano Crestani <ad...@apache.org> wrote:
>
> DAS C++ is now non-case sensitive, once most dbms are non-case sensitive,
> DAS C++ will be so, at least for now. Maybe on future, there can be added an
> option on config file that set DAS as case sensitive.
>
> All type and property names are converted to lower case when the SDO graph
> is created.
>
> Regards,
> Adriano Crestani
>
> On 6/26/07, Luciano Resende <lu...@gmail.com> wrote:
> >
> > Hey, very good, once this is available under the wiki, you probably
> > should also send an e-mail to the user list.
> >
> > On 6/25/07, Adriano Crestani <adrianocrestani@apache.org > wrote:
> > > Added DAS C++ GettingStarted.html document and the first DAS C++
> > sample
> > > under revision 550697.
> > >
> > > Adriano Crestani
> > >
> > > On 6/6/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > >
> > > > DAS is no longer needing the config.xsd to read xml configuration
> > files
> > > > since revision 544749.
> > > >
> > > > Adriano Crestani
> > > >
> > > > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > >
> > > > > Since revision 542742, DAS C++ is only working with SDO on trunk,
> > and
> > > > > not with SDO C++ M3.
> > > > >
> > > > > Adriano Crestani
> > > > >
> > > > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org > wrote:
> > > > > >
> > > > > > Added support to one to many relationship under revision 542742
> > > > > >
> > > > > > Adriano Crestani
> > > > > >
> > > > > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org>
> > wrote:
> > > > > > >
> > > > > > > Added support to set up the framework via config xml under
> > revision
> > > > > > > 542124.
> > > > > > >
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > > > >
> > > > > > > > Thank you for the explanation.
> > > > > > > >
> > > > > > > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org>
> > wrote:
> > > > > > > > >
> > > > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > > > >
> > > > > > > > > Next step is to implement a sample for it.
> > > > > > > > >
> > > > > > > > > I intend to add some info on wiki before the first
> > release.
> > > > > > > > >
> > > > > > > > > Regards,
> > > > > > > > > Adriano Crestani
> > > > > > > > >
> > > > > > > > > On 5/21/07, haleh mahbod <hmahbod@gmail.com > wrote:
> > > > > > > > > >
> > > > > > > > > > Hi Adriano,
> > > > > > > > > >
> > > > > > > > > > Is this integrated with SDO C++?  Is there a sample for
> > it?
> > > > > > > > > > Can more information be added to the home page and  user
> > > > > > > > guide[1]?
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > [1]
> > > > > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> >
> > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Haleh
> > > > > > > > > >
> > > > > > > > > > On 5/20/07, Adriano Crestani <
> > adrianocrestani@apache.org >
> > > > > > > > wrote:
> > > > > > > > > > >
> > > > > > > > > > > Actually is being developed the Tuscany DAS C++. So
> > far, the
> > > > > > > > framework
> > > > > > > > > > can
> > > > > > > > > > > perform the following:
> > > > > > > > > > >
> > > > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > > > >
> > > > > > > > > > >    - DAS assumes that a column named xxx_id is a FK to
> > the
> > > > > > > > column
> > > > > > > > > named
> > > > > > > > > > >    id on table xxx.
> > > > > > > > > > >    - If no PK column is found on the ResultSet, it
> > sets the
> > > > > > > > column
> > > > > > > > > named
> > > > > > > > > > >    id as PK, if exists.
> > > > > > > > > > >    - The COCs defined above are, actually, case
> > sensitive
> > > > > > > > and, for
> > > > > > > > > > >    example, a column named ID will not be set as PK
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > - The das is using the ResultSet metadata(column name,
> >
> > > > > > > > column data
> > > > > > > > > type
> > > > > > > > > > > and
> > > > > > > > > > > column table) to generate the sdo graph and popule it.
> > The
> > > > > > > > DAS
> > > > > > > > > > guarantees
> > > > > > > > > > > the table object uniqueness on graph basing on the
> > table PK,
> > > > > > > > so the
> > > > > > > > > > first
> > > > > > > > > > > table retrieved by the ResultSet will be taken, and
> > any
> > > > > > > > other table
> > > > > > > > > > > containing the same PK ignored:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >    - A table may contain a simple PK or a composite
> > one.
> > > > > > > > > > >    - If no PK is defined for the table, the DAS tries
> > to
> > > > > > > > find one
> > > > > > > > > using
> > > > > > > > > > >    COC.
> > > > > > > > > > >    - If the table has a composite PK and not all the
> > columns
> > > > > > > > that
> > > > > > > > > > >    compound the PK are contained on the ResultSet, the
> > DAS
> > > > > > > > ignores the
> > > > > > > > > > > defined
> > > > > > > > > > >    composite PK and tries to find another PK using COC
> > as
> > > > > > > > defined
> > > > > > > > > above.
> > > > > > > > > > >    - If no PK is found using COC, the DAS sets all
> > columns
> > > > > > > > on
> > > > > > > > > ResultSet
> > > > > > > > > > >    as PK.
> > > > > > > > > > >
> > > > > > > > > > > - Setting the references on graph objects basing on
> > table
> > > > > > > > > relationships.
> > > > > > > > > > >
> > > > > > > > > > >    - Actually, there may be up to 1 relationship
> > between 2
> > > > > > > > tables.
> > > > > > > > > > >    - The columns data that compound the FK are not
> > created
> > > > > > > > on the
> > > > > > > > > graph.
> > > > > > > > > > >    - The DAS accepts simple or composite
> > relationships.
> > > > > > > > > > >    - If not all the columns, PK or FK, that compound
> > the
> > > > > > > > relationship
> > > > > > > > > > are
> > > > > > > > > > >    on the ResultSet, the relationship is ignored and
> > the
> > > > > > > > remaining FK
> > > > > > > > > > are
> > > > > > > > > > >    loaded onto graph.
> > > > > > > > > > >
> > > > > > > > > > > - Actually, the DAS config can only be set from code.
> > > > > > > > > > >
> > > > > > > > > > > - There are also implemented some testcases.
> > > > > > > > > > >
> > > > > > > > > > > - DAS is only supporting the following SQL types:
> > INTEGER,
> > > > > > > > REAL, CHAR,
> > > > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > > > >
> > > > > > > > > > > Next steps:
> > > > > > > > > > >
> > > > > > > > > > > - Read the config from a xml file.
> > > > > > > > > > >
> > > > > > > > > > > - To implement a sample that reads some data from a
> > database
> > > > > > > > and print
> > > > > > > > > > on
> > > > > > > > > > > console.
> > > > > > > > > > >
> > > > > > > > > > > - Implement support for more SQL types.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > > > > >
> > > > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Regards,
> > > > > > > > > > >
> > > > > > > > > > > Adriano Crestani
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> >
> > --
> > Luciano Resende
> > Apache Tuscany Committer
> > http://people.apache.org/~lresende<http://people.apache.org/%7Elresende>
> > http://lresende.blogspot.com/
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> > For additional commands, e-mail: tuscany-dev-help@ws.apache.org
> >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
DAS C++ is now non-case sensitive, once most dbms are non-case sensitive,
DAS C++ will be so, at least for now. Maybe on future, there can be added an
option on config file that set DAS as case sensitive.

All type and property names are converted to lower case when the SDO graph
is created.

Regards,
Adriano Crestani

On 6/26/07, Luciano Resende <lu...@gmail.com> wrote:
>
> Hey, very good, once this is available under the wiki, you probably
> should also send an e-mail to the user list.
>
> On 6/25/07, Adriano Crestani <ad...@apache.org> wrote:
> > Added DAS C++ GettingStarted.html document and the first DAS C++ sample
> > under revision 550697.
> >
> > Adriano Crestani
> >
> > On 6/6/07, Adriano Crestani <ad...@apache.org> wrote:
> > >
> > > DAS is no longer needing the config.xsd to read xml configuration
> files
> > > since revision 544749.
> > >
> > > Adriano Crestani
> > >
> > > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > >
> > > > Since revision 542742, DAS C++ is only working with SDO on trunk,
> and
> > > > not with SDO C++ M3.
> > > >
> > > > Adriano Crestani
> > > >
> > > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > >
> > > > > Added support to one to many relationship under revision 542742
> > > > >
> > > > > Adriano Crestani
> > > > >
> > > > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > > >
> > > > > > Added support to set up the framework via config xml under
> revision
> > > > > > 542124.
> > > > > >
> > > > > > Adriano Crestani
> > > > > >
> > > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > > >
> > > > > > > Thank you for the explanation.
> > > > > > >
> > > > > > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org>
> wrote:
> > > > > > > >
> > > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > > >
> > > > > > > > Next step is to implement a sample for it.
> > > > > > > >
> > > > > > > > I intend to add some info on wiki before the first release.
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > > Adriano Crestani
> > > > > > > >
> > > > > > > > On 5/21/07, haleh mahbod <hmahbod@gmail.com > wrote:
> > > > > > > > >
> > > > > > > > > Hi Adriano,
> > > > > > > > >
> > > > > > > > > Is this integrated with SDO C++?  Is there a sample for
> it?
> > > > > > > > > Can more information be added to the home page and  user
> > > > > > > guide[1]?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [1]
> > > > > > > >
> http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > > > > >
> > > > > > > > >
> > > > > > > > > Haleh
> > > > > > > > >
> > > > > > > > > On 5/20/07, Adriano Crestani <adrianocrestani@apache.org >
> > > > > > > wrote:
> > > > > > > > > >
> > > > > > > > > > Actually is being developed the Tuscany DAS C++. So far,
> the
> > > > > > > framework
> > > > > > > > > can
> > > > > > > > > > perform the following:
> > > > > > > > > >
> > > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > > >
> > > > > > > > > >    - DAS assumes that a column named xxx_id is a FK to
> the
> > > > > > > column
> > > > > > > > named
> > > > > > > > > >    id on table xxx.
> > > > > > > > > >    - If no PK column is found on the ResultSet, it sets
> the
> > > > > > > column
> > > > > > > > named
> > > > > > > > > >    id as PK, if exists.
> > > > > > > > > >    - The COCs defined above are, actually, case
> sensitive
> > > > > > > and, for
> > > > > > > > > >    example, a column named ID will not be set as PK
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > - The das is using the ResultSet metadata(column name,
> > > > > > > column data
> > > > > > > > type
> > > > > > > > > > and
> > > > > > > > > > column table) to generate the sdo graph and popule it.
> The
> > > > > > > DAS
> > > > > > > > > guarantees
> > > > > > > > > > the table object uniqueness on graph basing on the table
> PK,
> > > > > > > so the
> > > > > > > > > first
> > > > > > > > > > table retrieved by the ResultSet will be taken, and any
> > > > > > > other table
> > > > > > > > > > containing the same PK ignored:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >    - A table may contain a simple PK or a composite one.
> > > > > > > > > >    - If no PK is defined for the table, the DAS tries to
> > > > > > > find one
> > > > > > > > using
> > > > > > > > > >    COC.
> > > > > > > > > >    - If the table has a composite PK and not all the
> columns
> > > > > > > that
> > > > > > > > > >    compound the PK are contained on the ResultSet, the
> DAS
> > > > > > > ignores the
> > > > > > > > > > defined
> > > > > > > > > >    composite PK and tries to find another PK using COC
> as
> > > > > > > defined
> > > > > > > > above.
> > > > > > > > > >    - If no PK is found using COC, the DAS sets all
> columns
> > > > > > > on
> > > > > > > > ResultSet
> > > > > > > > > >    as PK.
> > > > > > > > > >
> > > > > > > > > > - Setting the references on graph objects basing on
> table
> > > > > > > > relationships.
> > > > > > > > > >
> > > > > > > > > >    - Actually, there may be up to 1 relationship between
> 2
> > > > > > > tables.
> > > > > > > > > >    - The columns data that compound the FK are not
> created
> > > > > > > on the
> > > > > > > > graph.
> > > > > > > > > >    - The DAS accepts simple or composite relationships.
> > > > > > > > > >    - If not all the columns, PK or FK, that compound the
> > > > > > > relationship
> > > > > > > > > are
> > > > > > > > > >    on the ResultSet, the relationship is ignored and the
> > > > > > > remaining FK
> > > > > > > > > are
> > > > > > > > > >    loaded onto graph.
> > > > > > > > > >
> > > > > > > > > > - Actually, the DAS config can only be set from code.
> > > > > > > > > >
> > > > > > > > > > - There are also implemented some testcases.
> > > > > > > > > >
> > > > > > > > > > - DAS is only supporting the following SQL types:
> INTEGER,
> > > > > > > REAL, CHAR,
> > > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > > >
> > > > > > > > > > Next steps:
> > > > > > > > > >
> > > > > > > > > > - Read the config from a xml file.
> > > > > > > > > >
> > > > > > > > > > - To implement a sample that reads some data from a
> database
> > > > > > > and print
> > > > > > > > > on
> > > > > > > > > > console.
> > > > > > > > > >
> > > > > > > > > > - Implement support for more SQL types.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > > > >
> > > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Regards,
> > > > > > > > > >
> > > > > > > > > > Adriano Crestani
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
> --
> Luciano Resende
> Apache Tuscany Committer
> http://people.apache.org/~lresende
> http://lresende.blogspot.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-dev-help@ws.apache.org
>
>

Re: DAS C++ Status

Posted by Luciano Resende <lu...@gmail.com>.
Hey, very good, once this is available under the wiki, you probably
should also send an e-mail to the user list.

On 6/25/07, Adriano Crestani <ad...@apache.org> wrote:
> Added DAS C++ GettingStarted.html document and the first DAS C++ sample
> under revision 550697.
>
> Adriano Crestani
>
> On 6/6/07, Adriano Crestani <ad...@apache.org> wrote:
> >
> > DAS is no longer needing the config.xsd to read xml configuration files
> > since revision 544749.
> >
> > Adriano Crestani
> >
> > On 5/30/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > >
> > > Since revision 542742, DAS C++ is only working with SDO on trunk, and
> > > not with SDO C++ M3.
> > >
> > > Adriano Crestani
> > >
> > > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > >
> > > > Added support to one to many relationship under revision 542742
> > > >
> > > > Adriano Crestani
> > > >
> > > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > >
> > > > > Added support to set up the framework via config xml under revision
> > > > > 542124.
> > > > >
> > > > > Adriano Crestani
> > > > >
> > > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > > >
> > > > > > Thank you for the explanation.
> > > > > >
> > > > > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > > > >
> > > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > > >
> > > > > > > Next step is to implement a sample for it.
> > > > > > >
> > > > > > > I intend to add some info on wiki before the first release.
> > > > > > >
> > > > > > > Regards,
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > > > On 5/21/07, haleh mahbod <hmahbod@gmail.com > wrote:
> > > > > > > >
> > > > > > > > Hi Adriano,
> > > > > > > >
> > > > > > > > Is this integrated with SDO C++?  Is there a sample for it?
> > > > > > > > Can more information be added to the home page and  user
> > > > > > guide[1]?
> > > > > > > >
> > > > > > > >
> > > > > > > > [1]
> > > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > > > >
> > > > > > > >
> > > > > > > > Haleh
> > > > > > > >
> > > > > > > > On 5/20/07, Adriano Crestani <adrianocrestani@apache.org >
> > > > > > wrote:
> > > > > > > > >
> > > > > > > > > Actually is being developed the Tuscany DAS C++. So far, the
> > > > > > framework
> > > > > > > > can
> > > > > > > > > perform the following:
> > > > > > > > >
> > > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > > >
> > > > > > > > >    - DAS assumes that a column named xxx_id is a FK to the
> > > > > > column
> > > > > > > named
> > > > > > > > >    id on table xxx.
> > > > > > > > >    - If no PK column is found on the ResultSet, it sets the
> > > > > > column
> > > > > > > named
> > > > > > > > >    id as PK, if exists.
> > > > > > > > >    - The COCs defined above are, actually, case sensitive
> > > > > > and, for
> > > > > > > > >    example, a column named ID will not be set as PK
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > - The das is using the ResultSet metadata(column name,
> > > > > > column data
> > > > > > > type
> > > > > > > > > and
> > > > > > > > > column table) to generate the sdo graph and popule it. The
> > > > > > DAS
> > > > > > > > guarantees
> > > > > > > > > the table object uniqueness on graph basing on the table PK,
> > > > > > so the
> > > > > > > > first
> > > > > > > > > table retrieved by the ResultSet will be taken, and any
> > > > > > other table
> > > > > > > > > containing the same PK ignored:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >    - A table may contain a simple PK or a composite one.
> > > > > > > > >    - If no PK is defined for the table, the DAS tries to
> > > > > > find one
> > > > > > > using
> > > > > > > > >    COC.
> > > > > > > > >    - If the table has a composite PK and not all the columns
> > > > > > that
> > > > > > > > >    compound the PK are contained on the ResultSet, the DAS
> > > > > > ignores the
> > > > > > > > > defined
> > > > > > > > >    composite PK and tries to find another PK using COC as
> > > > > > defined
> > > > > > > above.
> > > > > > > > >    - If no PK is found using COC, the DAS sets all columns
> > > > > > on
> > > > > > > ResultSet
> > > > > > > > >    as PK.
> > > > > > > > >
> > > > > > > > > - Setting the references on graph objects basing on table
> > > > > > > relationships.
> > > > > > > > >
> > > > > > > > >    - Actually, there may be up to 1 relationship between 2
> > > > > > tables.
> > > > > > > > >    - The columns data that compound the FK are not created
> > > > > > on the
> > > > > > > graph.
> > > > > > > > >    - The DAS accepts simple or composite relationships.
> > > > > > > > >    - If not all the columns, PK or FK, that compound the
> > > > > > relationship
> > > > > > > > are
> > > > > > > > >    on the ResultSet, the relationship is ignored and the
> > > > > > remaining FK
> > > > > > > > are
> > > > > > > > >    loaded onto graph.
> > > > > > > > >
> > > > > > > > > - Actually, the DAS config can only be set from code.
> > > > > > > > >
> > > > > > > > > - There are also implemented some testcases.
> > > > > > > > >
> > > > > > > > > - DAS is only supporting the following SQL types: INTEGER,
> > > > > > REAL, CHAR,
> > > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > > >
> > > > > > > > > Next steps:
> > > > > > > > >
> > > > > > > > > - Read the config from a xml file.
> > > > > > > > >
> > > > > > > > > - To implement a sample that reads some data from a database
> > > > > > and print
> > > > > > > > on
> > > > > > > > > console.
> > > > > > > > >
> > > > > > > > > - Implement support for more SQL types.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > > >
> > > > > > > > > Any volunteer would be helpful ; )
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Regards,
> > > > > > > > >
> > > > > > > > > Adriano Crestani
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>


-- 
Luciano Resende
Apache Tuscany Committer
http://people.apache.org/~lresende
http://lresende.blogspot.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Added DAS C++ GettingStarted.html document and the first DAS C++ sample
under revision 550697.

Adriano Crestani

On 6/6/07, Adriano Crestani <ad...@apache.org> wrote:
>
> DAS is no longer needing the config.xsd to read xml configuration files
> since revision 544749.
>
> Adriano Crestani
>
> On 5/30/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> >
> > Since revision 542742, DAS C++ is only working with SDO on trunk, and
> > not with SDO C++ M3.
> >
> > Adriano Crestani
> >
> > On 5/29/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > >
> > > Added support to one to many relationship under revision 542742
> > >
> > > Adriano Crestani
> > >
> > > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > >
> > > > Added support to set up the framework via config xml under revision
> > > > 542124.
> > > >
> > > > Adriano Crestani
> > > >
> > > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > > >
> > > > > Thank you for the explanation.
> > > > >
> > > > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > > >
> > > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > > >
> > > > > > Next step is to implement a sample for it.
> > > > > >
> > > > > > I intend to add some info on wiki before the first release.
> > > > > >
> > > > > > Regards,
> > > > > > Adriano Crestani
> > > > > >
> > > > > > On 5/21/07, haleh mahbod <hmahbod@gmail.com > wrote:
> > > > > > >
> > > > > > > Hi Adriano,
> > > > > > >
> > > > > > > Is this integrated with SDO C++?  Is there a sample for it?
> > > > > > > Can more information be added to the home page and  user
> > > > > guide[1]?
> > > > > > >
> > > > > > >
> > > > > > > [1]
> > > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > > >
> > > > > > >
> > > > > > > Haleh
> > > > > > >
> > > > > > > On 5/20/07, Adriano Crestani <adrianocrestani@apache.org >
> > > > > wrote:
> > > > > > > >
> > > > > > > > Actually is being developed the Tuscany DAS C++. So far, the
> > > > > framework
> > > > > > > can
> > > > > > > > perform the following:
> > > > > > > >
> > > > > > > > - Convetion Over Configuration(COC):
> > > > > > > >
> > > > > > > >    - DAS assumes that a column named xxx_id is a FK to the
> > > > > column
> > > > > > named
> > > > > > > >    id on table xxx.
> > > > > > > >    - If no PK column is found on the ResultSet, it sets the
> > > > > column
> > > > > > named
> > > > > > > >    id as PK, if exists.
> > > > > > > >    - The COCs defined above are, actually, case sensitive
> > > > > and, for
> > > > > > > >    example, a column named ID will not be set as PK
> > > > > > > >
> > > > > > > >
> > > > > > > > - The das is using the ResultSet metadata(column name,
> > > > > column data
> > > > > > type
> > > > > > > > and
> > > > > > > > column table) to generate the sdo graph and popule it. The
> > > > > DAS
> > > > > > > guarantees
> > > > > > > > the table object uniqueness on graph basing on the table PK,
> > > > > so the
> > > > > > > first
> > > > > > > > table retrieved by the ResultSet will be taken, and any
> > > > > other table
> > > > > > > > containing the same PK ignored:
> > > > > > > >
> > > > > > > >
> > > > > > > >    - A table may contain a simple PK or a composite one.
> > > > > > > >    - If no PK is defined for the table, the DAS tries to
> > > > > find one
> > > > > > using
> > > > > > > >    COC.
> > > > > > > >    - If the table has a composite PK and not all the columns
> > > > > that
> > > > > > > >    compound the PK are contained on the ResultSet, the DAS
> > > > > ignores the
> > > > > > > > defined
> > > > > > > >    composite PK and tries to find another PK using COC as
> > > > > defined
> > > > > > above.
> > > > > > > >    - If no PK is found using COC, the DAS sets all columns
> > > > > on
> > > > > > ResultSet
> > > > > > > >    as PK.
> > > > > > > >
> > > > > > > > - Setting the references on graph objects basing on table
> > > > > > relationships.
> > > > > > > >
> > > > > > > >    - Actually, there may be up to 1 relationship between 2
> > > > > tables.
> > > > > > > >    - The columns data that compound the FK are not created
> > > > > on the
> > > > > > graph.
> > > > > > > >    - The DAS accepts simple or composite relationships.
> > > > > > > >    - If not all the columns, PK or FK, that compound the
> > > > > relationship
> > > > > > > are
> > > > > > > >    on the ResultSet, the relationship is ignored and the
> > > > > remaining FK
> > > > > > > are
> > > > > > > >    loaded onto graph.
> > > > > > > >
> > > > > > > > - Actually, the DAS config can only be set from code.
> > > > > > > >
> > > > > > > > - There are also implemented some testcases.
> > > > > > > >
> > > > > > > > - DAS is only supporting the following SQL types: INTEGER,
> > > > > REAL, CHAR,
> > > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > > >
> > > > > > > > Next steps:
> > > > > > > >
> > > > > > > > - Read the config from a xml file.
> > > > > > > >
> > > > > > > > - To implement a sample that reads some data from a database
> > > > > and print
> > > > > > > on
> > > > > > > > console.
> > > > > > > >
> > > > > > > > - Implement support for more SQL types.
> > > > > > > >
> > > > > > > >
> > > > > > > > Comments and suggestions will be appreciated : )
> > > > > > > >
> > > > > > > > Any volunteer would be helpful ; )
> > > > > > > >
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > >
> > > > > > > > Adriano Crestani
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
DAS is no longer needing the config.xsd to read xml configuration files
since revision 544749.

Adriano Crestani

On 5/30/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Since revision 542742, DAS C++ is only working with SDO on trunk, and not
> with SDO C++ M3.
>
> Adriano Crestani
>
> On 5/29/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> >
> > Added support to one to many relationship under revision 542742
> >
> > Adriano Crestani
> >
> > On 5/28/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > >
> > > Added support to set up the framework via config xml under revision
> > > 542124.
> > >
> > > Adriano Crestani
> > >
> > > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > > >
> > > > Thank you for the explanation.
> > > >
> > > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > > >
> > > > > Yes, it's intergrated with Tuscany SDO C++.
> > > > >
> > > > > Next step is to implement a sample for it.
> > > > >
> > > > > I intend to add some info on wiki before the first release.
> > > > >
> > > > > Regards,
> > > > > Adriano Crestani
> > > > >
> > > > > On 5/21/07, haleh mahbod <hmahbod@gmail.com > wrote:
> > > > > >
> > > > > > Hi Adriano,
> > > > > >
> > > > > > Is this integrated with SDO C++?  Is there a sample for it?
> > > > > > Can more information be added to the home page and  user
> > > > guide[1]?
> > > > > >
> > > > > >
> > > > > > [1]
> > > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > >
> > > > > >
> > > > > > Haleh
> > > > > >
> > > > > > On 5/20/07, Adriano Crestani <adrianocrestani@apache.org >
> > > > wrote:
> > > > > > >
> > > > > > > Actually is being developed the Tuscany DAS C++. So far, the
> > > > framework
> > > > > > can
> > > > > > > perform the following:
> > > > > > >
> > > > > > > - Convetion Over Configuration(COC):
> > > > > > >
> > > > > > >    - DAS assumes that a column named xxx_id is a FK to the
> > > > column
> > > > > named
> > > > > > >    id on table xxx.
> > > > > > >    - If no PK column is found on the ResultSet, it sets the
> > > > column
> > > > > named
> > > > > > >    id as PK, if exists.
> > > > > > >    - The COCs defined above are, actually, case sensitive and,
> > > > for
> > > > > > >    example, a column named ID will not be set as PK
> > > > > > >
> > > > > > >
> > > > > > > - The das is using the ResultSet metadata(column name, column
> > > > data
> > > > > type
> > > > > > > and
> > > > > > > column table) to generate the sdo graph and popule it. The DAS
> > > > > > guarantees
> > > > > > > the table object uniqueness on graph basing on the table PK,
> > > > so the
> > > > > > first
> > > > > > > table retrieved by the ResultSet will be taken, and any other
> > > > table
> > > > > > > containing the same PK ignored:
> > > > > > >
> > > > > > >
> > > > > > >    - A table may contain a simple PK or a composite one.
> > > > > > >    - If no PK is defined for the table, the DAS tries to find
> > > > one
> > > > > using
> > > > > > >    COC.
> > > > > > >    - If the table has a composite PK and not all the columns
> > > > that
> > > > > > >    compound the PK are contained on the ResultSet, the DAS
> > > > ignores the
> > > > > > > defined
> > > > > > >    composite PK and tries to find another PK using COC as
> > > > defined
> > > > > above.
> > > > > > >    - If no PK is found using COC, the DAS sets all columns on
> > > > > ResultSet
> > > > > > >    as PK.
> > > > > > >
> > > > > > > - Setting the references on graph objects basing on table
> > > > > relationships.
> > > > > > >
> > > > > > >    - Actually, there may be up to 1 relationship between 2
> > > > tables.
> > > > > > >    - The columns data that compound the FK are not created on
> > > > the
> > > > > graph.
> > > > > > >    - The DAS accepts simple or composite relationships.
> > > > > > >    - If not all the columns, PK or FK, that compound the
> > > > relationship
> > > > > > are
> > > > > > >    on the ResultSet, the relationship is ignored and the
> > > > remaining FK
> > > > > > are
> > > > > > >    loaded onto graph.
> > > > > > >
> > > > > > > - Actually, the DAS config can only be set from code.
> > > > > > >
> > > > > > > - There are also implemented some testcases.
> > > > > > >
> > > > > > > - DAS is only supporting the following SQL types: INTEGER,
> > > > REAL, CHAR,
> > > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > > >
> > > > > > > Next steps:
> > > > > > >
> > > > > > > - Read the config from a xml file.
> > > > > > >
> > > > > > > - To implement a sample that reads some data from a database
> > > > and print
> > > > > > on
> > > > > > > console.
> > > > > > >
> > > > > > > - Implement support for more SQL types.
> > > > > > >
> > > > > > >
> > > > > > > Comments and suggestions will be appreciated : )
> > > > > > >
> > > > > > > Any volunteer would be helpful ; )
> > > > > > >
> > > > > > >
> > > > > > > Regards,
> > > > > > >
> > > > > > > Adriano Crestani
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Since revision 542742, DAS C++ is only working with SDO on trunk, and not
with SDO C++ M3.

Adriano Crestani

On 5/29/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Added support to one to many relationship under revision 542742
>
> Adriano Crestani
>
> On 5/28/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> >
> > Added support to set up the framework via config xml under revision
> > 542124.
> >
> > Adriano Crestani
> >
> > On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> > >
> > > Thank you for the explanation.
> > >
> > > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > > >
> > > > Yes, it's intergrated with Tuscany SDO C++.
> > > >
> > > > Next step is to implement a sample for it.
> > > >
> > > > I intend to add some info on wiki before the first release.
> > > >
> > > > Regards,
> > > > Adriano Crestani
> > > >
> > > > On 5/21/07, haleh mahbod <hmahbod@gmail.com > wrote:
> > > > >
> > > > > Hi Adriano,
> > > > >
> > > > > Is this integrated with SDO C++?  Is there a sample for it?
> > > > > Can more information be added to the home page and  user guide[1]?
> > > > >
> > > > >
> > > > > [1]
> > > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > >
> > > > >
> > > > > Haleh
> > > > >
> > > > > On 5/20/07, Adriano Crestani <adrianocrestani@apache.org > wrote:
> > > > > >
> > > > > > Actually is being developed the Tuscany DAS C++. So far, the
> > > framework
> > > > > can
> > > > > > perform the following:
> > > > > >
> > > > > > - Convetion Over Configuration(COC):
> > > > > >
> > > > > >    - DAS assumes that a column named xxx_id is a FK to the
> > > column
> > > > named
> > > > > >    id on table xxx.
> > > > > >    - If no PK column is found on the ResultSet, it sets the
> > > column
> > > > named
> > > > > >    id as PK, if exists.
> > > > > >    - The COCs defined above are, actually, case sensitive and,
> > > for
> > > > > >    example, a column named ID will not be set as PK
> > > > > >
> > > > > >
> > > > > > - The das is using the ResultSet metadata(column name, column
> > > data
> > > > type
> > > > > > and
> > > > > > column table) to generate the sdo graph and popule it. The DAS
> > > > > guarantees
> > > > > > the table object uniqueness on graph basing on the table PK, so
> > > the
> > > > > first
> > > > > > table retrieved by the ResultSet will be taken, and any other
> > > table
> > > > > > containing the same PK ignored:
> > > > > >
> > > > > >
> > > > > >    - A table may contain a simple PK or a composite one.
> > > > > >    - If no PK is defined for the table, the DAS tries to find
> > > one
> > > > using
> > > > > >    COC.
> > > > > >    - If the table has a composite PK and not all the columns
> > > that
> > > > > >    compound the PK are contained on the ResultSet, the DAS
> > > ignores the
> > > > > > defined
> > > > > >    composite PK and tries to find another PK using COC as
> > > defined
> > > > above.
> > > > > >    - If no PK is found using COC, the DAS sets all columns on
> > > > ResultSet
> > > > > >    as PK.
> > > > > >
> > > > > > - Setting the references on graph objects basing on table
> > > > relationships.
> > > > > >
> > > > > >    - Actually, there may be up to 1 relationship between 2
> > > tables.
> > > > > >    - The columns data that compound the FK are not created on
> > > the
> > > > graph.
> > > > > >    - The DAS accepts simple or composite relationships.
> > > > > >    - If not all the columns, PK or FK, that compound the
> > > relationship
> > > > > are
> > > > > >    on the ResultSet, the relationship is ignored and the
> > > remaining FK
> > > > > are
> > > > > >    loaded onto graph.
> > > > > >
> > > > > > - Actually, the DAS config can only be set from code.
> > > > > >
> > > > > > - There are also implemented some testcases.
> > > > > >
> > > > > > - DAS is only supporting the following SQL types: INTEGER, REAL,
> > > CHAR,
> > > > > > VARCHAR, FLOAT, DOUBLE.
> > > > > >
> > > > > > Next steps:
> > > > > >
> > > > > > - Read the config from a xml file.
> > > > > >
> > > > > > - To implement a sample that reads some data from a database and
> > > print
> > > > > on
> > > > > > console.
> > > > > >
> > > > > > - Implement support for more SQL types.
> > > > > >
> > > > > >
> > > > > > Comments and suggestions will be appreciated : )
> > > > > >
> > > > > > Any volunteer would be helpful ; )
> > > > > >
> > > > > >
> > > > > > Regards,
> > > > > >
> > > > > > Adriano Crestani
> > > > > >
> > > > >
> > > >
> > >
> >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Added support to one to many relationship under revision 542742

Adriano Crestani

On 5/28/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Added support to set up the framework via config xml under revision
> 542124.
>
> Adriano Crestani
>
> On 5/22/07, haleh mahbod < hmahbod@gmail.com> wrote:
> >
> > Thank you for the explanation.
> >
> > On 5/21/07, Adriano Crestani < adrianocrestani@apache.org> wrote:
> > >
> > > Yes, it's intergrated with Tuscany SDO C++.
> > >
> > > Next step is to implement a sample for it.
> > >
> > > I intend to add some info on wiki before the first release.
> > >
> > > Regards,
> > > Adriano Crestani
> > >
> > > On 5/21/07, haleh mahbod <hm...@gmail.com> wrote:
> > > >
> > > > Hi Adriano,
> > > >
> > > > Is this integrated with SDO C++?  Is there a sample for it?
> > > > Can more information be added to the home page and  user guide[1]?
> > > >
> > > >
> > > > [1]
> > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > > >
> > > > Haleh
> > > >
> > > > On 5/20/07, Adriano Crestani <ad...@apache.org> wrote:
> > > > >
> > > > > Actually is being developed the Tuscany DAS C++. So far, the
> > framework
> > > > can
> > > > > perform the following:
> > > > >
> > > > > - Convetion Over Configuration(COC):
> > > > >
> > > > >    - DAS assumes that a column named xxx_id is a FK to the column
> > > named
> > > > >    id on table xxx.
> > > > >    - If no PK column is found on the ResultSet, it sets the column
> > > named
> > > > >    id as PK, if exists.
> > > > >    - The COCs defined above are, actually, case sensitive and, for
> >
> > > > >    example, a column named ID will not be set as PK
> > > > >
> > > > >
> > > > > - The das is using the ResultSet metadata(column name, column data
> > > type
> > > > > and
> > > > > column table) to generate the sdo graph and popule it. The DAS
> > > > guarantees
> > > > > the table object uniqueness on graph basing on the table PK, so
> > the
> > > > first
> > > > > table retrieved by the ResultSet will be taken, and any other
> > table
> > > > > containing the same PK ignored:
> > > > >
> > > > >
> > > > >    - A table may contain a simple PK or a composite one.
> > > > >    - If no PK is defined for the table, the DAS tries to find one
> > > using
> > > > >    COC.
> > > > >    - If the table has a composite PK and not all the columns that
> > > > >    compound the PK are contained on the ResultSet, the DAS ignores
> > the
> > > > > defined
> > > > >    composite PK and tries to find another PK using COC as defined
> > > above.
> > > > >    - If no PK is found using COC, the DAS sets all columns on
> > > ResultSet
> > > > >    as PK.
> > > > >
> > > > > - Setting the references on graph objects basing on table
> > > relationships.
> > > > >
> > > > >    - Actually, there may be up to 1 relationship between 2 tables.
> > > > >    - The columns data that compound the FK are not created on the
> > > graph.
> > > > >    - The DAS accepts simple or composite relationships.
> > > > >    - If not all the columns, PK or FK, that compound the
> > relationship
> > > > are
> > > > >    on the ResultSet, the relationship is ignored and the remaining
> > FK
> > > > are
> > > > >    loaded onto graph.
> > > > >
> > > > > - Actually, the DAS config can only be set from code.
> > > > >
> > > > > - There are also implemented some testcases.
> > > > >
> > > > > - DAS is only supporting the following SQL types: INTEGER, REAL,
> > CHAR,
> > > > > VARCHAR, FLOAT, DOUBLE.
> > > > >
> > > > > Next steps:
> > > > >
> > > > > - Read the config from a xml file.
> > > > >
> > > > > - To implement a sample that reads some data from a database and
> > print
> > > > on
> > > > > console.
> > > > >
> > > > > - Implement support for more SQL types.
> > > > >
> > > > >
> > > > > Comments and suggestions will be appreciated : )
> > > > >
> > > > > Any volunteer would be helpful ; )
> > > > >
> > > > >
> > > > > Regards,
> > > > >
> > > > > Adriano Crestani
> > > > >
> > > >
> > >
> >
>
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Added support to set up the framework via config xml under revision 542124.

Adriano Crestani

On 5/22/07, haleh mahbod <hm...@gmail.com> wrote:
>
> Thank you for the explanation.
>
> On 5/21/07, Adriano Crestani <ad...@apache.org> wrote:
> >
> > Yes, it's intergrated with Tuscany SDO C++.
> >
> > Next step is to implement a sample for it.
> >
> > I intend to add some info on wiki before the first release.
> >
> > Regards,
> > Adriano Crestani
> >
> > On 5/21/07, haleh mahbod <hm...@gmail.com> wrote:
> > >
> > > Hi Adriano,
> > >
> > > Is this integrated with SDO C++?  Is there a sample for it?
> > > Can more information be added to the home page and  user guide[1]?
> > >
> > >
> > > [1]
> > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> > >
> > > Haleh
> > >
> > > On 5/20/07, Adriano Crestani <ad...@apache.org> wrote:
> > > >
> > > > Actually is being developed the Tuscany DAS C++. So far, the
> framework
> > > can
> > > > perform the following:
> > > >
> > > > - Convetion Over Configuration(COC):
> > > >
> > > >    - DAS assumes that a column named xxx_id is a FK to the column
> > named
> > > >    id on table xxx.
> > > >    - If no PK column is found on the ResultSet, it sets the column
> > named
> > > >    id as PK, if exists.
> > > >    - The COCs defined above are, actually, case sensitive and, for
> > > >    example, a column named ID will not be set as PK
> > > >
> > > >
> > > > - The das is using the ResultSet metadata(column name, column data
> > type
> > > > and
> > > > column table) to generate the sdo graph and popule it. The DAS
> > > guarantees
> > > > the table object uniqueness on graph basing on the table PK, so the
> > > first
> > > > table retrieved by the ResultSet will be taken, and any other table
> > > > containing the same PK ignored:
> > > >
> > > >
> > > >    - A table may contain a simple PK or a composite one.
> > > >    - If no PK is defined for the table, the DAS tries to find one
> > using
> > > >    COC.
> > > >    - If the table has a composite PK and not all the columns that
> > > >    compound the PK are contained on the ResultSet, the DAS ignores
> the
> > > > defined
> > > >    composite PK and tries to find another PK using COC as defined
> > above.
> > > >    - If no PK is found using COC, the DAS sets all columns on
> > ResultSet
> > > >    as PK.
> > > >
> > > > - Setting the references on graph objects basing on table
> > relationships.
> > > >
> > > >    - Actually, there may be up to 1 relationship between 2 tables.
> > > >    - The columns data that compound the FK are not created on the
> > graph.
> > > >    - The DAS accepts simple or composite relationships.
> > > >    - If not all the columns, PK or FK, that compound the
> relationship
> > > are
> > > >    on the ResultSet, the relationship is ignored and the remaining
> FK
> > > are
> > > >    loaded onto graph.
> > > >
> > > > - Actually, the DAS config can only be set from code.
> > > >
> > > > - There are also implemented some testcases.
> > > >
> > > > - DAS is only supporting the following SQL types: INTEGER, REAL,
> CHAR,
> > > > VARCHAR, FLOAT, DOUBLE.
> > > >
> > > > Next steps:
> > > >
> > > > - Read the config from a xml file.
> > > >
> > > > - To implement a sample that reads some data from a database and
> print
> > > on
> > > > console.
> > > >
> > > > - Implement support for more SQL types.
> > > >
> > > >
> > > > Comments and suggestions will be appreciated : )
> > > >
> > > > Any volunteer would be helpful ; )
> > > >
> > > >
> > > > Regards,
> > > >
> > > > Adriano Crestani
> > > >
> > >
> >
>

Re: DAS C++ Status

Posted by haleh mahbod <hm...@gmail.com>.
Thank you for the explanation.

On 5/21/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Yes, it's intergrated with Tuscany SDO C++.
>
> Next step is to implement a sample for it.
>
> I intend to add some info on wiki before the first release.
>
> Regards,
> Adriano Crestani
>
> On 5/21/07, haleh mahbod <hm...@gmail.com> wrote:
> >
> > Hi Adriano,
> >
> > Is this integrated with SDO C++?  Is there a sample for it?
> > Can more information be added to the home page and  user guide[1]?
> >
> >
> > [1]
> http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
> >
> > Haleh
> >
> > On 5/20/07, Adriano Crestani <ad...@apache.org> wrote:
> > >
> > > Actually is being developed the Tuscany DAS C++. So far, the framework
> > can
> > > perform the following:
> > >
> > > - Convetion Over Configuration(COC):
> > >
> > >    - DAS assumes that a column named xxx_id is a FK to the column
> named
> > >    id on table xxx.
> > >    - If no PK column is found on the ResultSet, it sets the column
> named
> > >    id as PK, if exists.
> > >    - The COCs defined above are, actually, case sensitive and, for
> > >    example, a column named ID will not be set as PK
> > >
> > >
> > > - The das is using the ResultSet metadata(column name, column data
> type
> > > and
> > > column table) to generate the sdo graph and popule it. The DAS
> > guarantees
> > > the table object uniqueness on graph basing on the table PK, so the
> > first
> > > table retrieved by the ResultSet will be taken, and any other table
> > > containing the same PK ignored:
> > >
> > >
> > >    - A table may contain a simple PK or a composite one.
> > >    - If no PK is defined for the table, the DAS tries to find one
> using
> > >    COC.
> > >    - If the table has a composite PK and not all the columns that
> > >    compound the PK are contained on the ResultSet, the DAS ignores the
> > > defined
> > >    composite PK and tries to find another PK using COC as defined
> above.
> > >    - If no PK is found using COC, the DAS sets all columns on
> ResultSet
> > >    as PK.
> > >
> > > - Setting the references on graph objects basing on table
> relationships.
> > >
> > >    - Actually, there may be up to 1 relationship between 2 tables.
> > >    - The columns data that compound the FK are not created on the
> graph.
> > >    - The DAS accepts simple or composite relationships.
> > >    - If not all the columns, PK or FK, that compound the relationship
> > are
> > >    on the ResultSet, the relationship is ignored and the remaining FK
> > are
> > >    loaded onto graph.
> > >
> > > - Actually, the DAS config can only be set from code.
> > >
> > > - There are also implemented some testcases.
> > >
> > > - DAS is only supporting the following SQL types: INTEGER, REAL, CHAR,
> > > VARCHAR, FLOAT, DOUBLE.
> > >
> > > Next steps:
> > >
> > > - Read the config from a xml file.
> > >
> > > - To implement a sample that reads some data from a database and print
> > on
> > > console.
> > >
> > > - Implement support for more SQL types.
> > >
> > >
> > > Comments and suggestions will be appreciated : )
> > >
> > > Any volunteer would be helpful ; )
> > >
> > >
> > > Regards,
> > >
> > > Adriano Crestani
> > >
> >
>

Re: DAS C++ Status

Posted by Adriano Crestani <ad...@apache.org>.
Yes, it's intergrated with Tuscany SDO C++.

Next step is to implement a sample for it.

I intend to add some info on wiki before the first release.

Regards,
Adriano Crestani

On 5/21/07, haleh mahbod <hm...@gmail.com> wrote:
>
> Hi Adriano,
>
> Is this integrated with SDO C++?  Is there a sample for it?
> Can more information be added to the home page and  user guide[1]?
>
>
> [1] http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512
>
> Haleh
>
> On 5/20/07, Adriano Crestani <ad...@apache.org> wrote:
> >
> > Actually is being developed the Tuscany DAS C++. So far, the framework
> can
> > perform the following:
> >
> > - Convetion Over Configuration(COC):
> >
> >    - DAS assumes that a column named xxx_id is a FK to the column named
> >    id on table xxx.
> >    - If no PK column is found on the ResultSet, it sets the column named
> >    id as PK, if exists.
> >    - The COCs defined above are, actually, case sensitive and, for
> >    example, a column named ID will not be set as PK
> >
> >
> > - The das is using the ResultSet metadata(column name, column data type
> > and
> > column table) to generate the sdo graph and popule it. The DAS
> guarantees
> > the table object uniqueness on graph basing on the table PK, so the
> first
> > table retrieved by the ResultSet will be taken, and any other table
> > containing the same PK ignored:
> >
> >
> >    - A table may contain a simple PK or a composite one.
> >    - If no PK is defined for the table, the DAS tries to find one using
> >    COC.
> >    - If the table has a composite PK and not all the columns that
> >    compound the PK are contained on the ResultSet, the DAS ignores the
> > defined
> >    composite PK and tries to find another PK using COC as defined above.
> >    - If no PK is found using COC, the DAS sets all columns on ResultSet
> >    as PK.
> >
> > - Setting the references on graph objects basing on table relationships.
> >
> >    - Actually, there may be up to 1 relationship between 2 tables.
> >    - The columns data that compound the FK are not created on the graph.
> >    - The DAS accepts simple or composite relationships.
> >    - If not all the columns, PK or FK, that compound the relationship
> are
> >    on the ResultSet, the relationship is ignored and the remaining FK
> are
> >    loaded onto graph.
> >
> > - Actually, the DAS config can only be set from code.
> >
> > - There are also implemented some testcases.
> >
> > - DAS is only supporting the following SQL types: INTEGER, REAL, CHAR,
> > VARCHAR, FLOAT, DOUBLE.
> >
> > Next steps:
> >
> > - Read the config from a xml file.
> >
> > - To implement a sample that reads some data from a database and print
> on
> > console.
> >
> > - Implement support for more SQL types.
> >
> >
> > Comments and suggestions will be appreciated : )
> >
> > Any volunteer would be helpful ; )
> >
> >
> > Regards,
> >
> > Adriano Crestani
> >
>

Re: DAS C++ Status

Posted by haleh mahbod <hm...@gmail.com>.
Hi Adriano,

Is this integrated with SDO C++?  Is there a sample for it?
Can more information be added to the home page and  user guide[1]?


[1] http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512

Haleh

On 5/20/07, Adriano Crestani <ad...@apache.org> wrote:
>
> Actually is being developed the Tuscany DAS C++. So far, the framework can
> perform the following:
>
> - Convetion Over Configuration(COC):
>
>    - DAS assumes that a column named xxx_id is a FK to the column named
>    id on table xxx.
>    - If no PK column is found on the ResultSet, it sets the column named
>    id as PK, if exists.
>    - The COCs defined above are, actually, case sensitive and, for
>    example, a column named ID will not be set as PK
>
>
> - The das is using the ResultSet metadata(column name, column data type
> and
> column table) to generate the sdo graph and popule it. The DAS guarantees
> the table object uniqueness on graph basing on the table PK, so the first
> table retrieved by the ResultSet will be taken, and any other table
> containing the same PK ignored:
>
>
>    - A table may contain a simple PK or a composite one.
>    - If no PK is defined for the table, the DAS tries to find one using
>    COC.
>    - If the table has a composite PK and not all the columns that
>    compound the PK are contained on the ResultSet, the DAS ignores the
> defined
>    composite PK and tries to find another PK using COC as defined above.
>    - If no PK is found using COC, the DAS sets all columns on ResultSet
>    as PK.
>
> - Setting the references on graph objects basing on table relationships.
>
>    - Actually, there may be up to 1 relationship between 2 tables.
>    - The columns data that compound the FK are not created on the graph.
>    - The DAS accepts simple or composite relationships.
>    - If not all the columns, PK or FK, that compound the relationship are
>    on the ResultSet, the relationship is ignored and the remaining FK are
>    loaded onto graph.
>
> - Actually, the DAS config can only be set from code.
>
> - There are also implemented some testcases.
>
> - DAS is only supporting the following SQL types: INTEGER, REAL, CHAR,
> VARCHAR, FLOAT, DOUBLE.
>
> Next steps:
>
> - Read the config from a xml file.
>
> - To implement a sample that reads some data from a database and print on
> console.
>
> - Implement support for more SQL types.
>
>
> Comments and suggestions will be appreciated : )
>
> Any volunteer would be helpful ; )
>
>
> Regards,
>
> Adriano Crestani
>