Hi Joan, hmm .... this looks like a bug. I am cc'ing Yong, the MConfigurator expert, in case he wants to chip in and confirm that this is the case
a On Mon, Jan 23, 2012 at 3:04 PM, <[email protected]> wrote: > No I don't see the relations between tables, that's the problem. I also > have tried to introduce only the main tables and I see that if I clik into > the schema editor the other tables ( related with the constraints with main > one) are introduced automatically by Biomart. In this case I can add a tab > with a new entry and I can select the attributes of the main table (by the > web) but unfortunately I neither see the relations nor the attributes of > the other tables. > > > Thanks > > -----Mensaje original----- > De: [email protected] en nombre de Arek Kasprzyk > Enviado el: lun 23/01/2012 17:01 > Para: PROTASIO, JOAN (IDIBAPS) > CC: [email protected] > Asunto: Re: [BioMart Users] Problems adding source with constraints > > Hi Joan, > do you see the relations between tables as well? > > a > > On Mon, Jan 23, 2012 at 10:44 AM, <[email protected]> wrote: > > > Hi Arek,**** > > > > ** ** > > > > well I'm choosing exactly the params source schema-> MySQL and I uncheck > > the MYlSAM option because the schema of my local db works with InnoDB. > > Afterthat I can see the source with all the tables involved in the > schema. > > Then if I select all of them I see various sources in my > MartConfigurator. > > **** > > > > ** ** > > > > Salutacions, **** > > > > Joan **** > > > > **** > > > > > > > ------------------------------------------------------------------------------ > > **** > > > > **** > > > > Joan Protasio**** > > > > *Bioinformatics Unit: * > http://bioinformatics.fcrb.es/bioinformatics/**** > > > > August Pi i Sunyer Biomedical Research Institute (IDIBAPS)**** > > > > Phone: 93.227.54.00 (Ext. 4522)**** > > > > C/ Rosselló 153**** > > > > 08036 Barcelona**** > > > > ** ** > > > > ** ** > > > > ** ** > > > > ** ** > > > > ** ** > > > > ** ** > > ------------------------------ > > > > *De:* [email protected] [mailto:[email protected]] *En > > nombre de *Arek Kasprzyk > > *Enviado el:* lunes, 23 de enero de 2012 16:04 > > *Para:* PROTASIO, JOAN (IDIBAPS) > > *CC:* [email protected] > > *Asunto:* Re: [BioMart Users] Problems adding source with constraints**** > > > > ** ** > > > > Hi Joan,**** > > > > first of all you need to be aware that rc7 has not been officially > > released. I am not sure how much testing gone into that. The last > official > > release is rc6. InnoDB should definitely work and behave just like oracle > > or postgres. Are you choosing the right DB platform option ei NOT MySQL > > MyISM?**** > > > > ** ** > > > > a**** > > > > ** ** > > > > On Mon, Jan 23, 2012 at 7:35 AM, <[email protected]> wrote:**** > > > > Hi all,**** > > > > **** > > > > I have problems adding new source from a local database. I am working > with > > the new Biomart version r7 and the local database works with constraints > in > > InnoDB format. If I try to add the source using the MartConfigurator and > > click into the Schema Editor I don't see the relations like the mysql > > constraints. I have read the paper "Biomart: a data federation > framework." > > and if I understand it well it says the source must be a relational db as > > we have but I am not sure if the InnoDB format is good for Biomart. Could > > you help me?**** > > > > **** > > > > Thanks a lot,**** > > > > **** > > > > Salutacions, **** > > > > Joan **** > > > > **** > > > > > > > ------------------------------------------------------------------------------ > > **** > > > > **** > > > > Joan Protasio**** > > > > *Bioinformatics Unit: * > http://bioinformatics.fcrb.es/bioinformatics/**** > > > > August Pi i Sunyer Biomedical Research Institute (IDIBAPS)**** > > > > Phone: 93.227.54.00 (Ext. 4522)**** > > > > C/ Rosselló 153**** > > > > 08036 Barcelona**** > > > > > > _______________________________________________ > > Users mailing list > > [email protected] > > https://lists.biomart.org/mailman/listinfo/users**** > > > > > > > > **** > > > > ** ** > > > > -- **** > > > > Arek Kasprzyk, MD, MSc, PhD > > BioMart Project Lead**** > > > > ** ** > > > > > > -- > > Arek Kasprzyk, MD, MSc, PhD > BioMart Project Lead > > -- Arek Kasprzyk, MD, MSc, PhD BioMart Project Lead
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
