-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Wick.
Syed and I used your schema to set up a test server and by doing so I discovered a bug in MBuilder which was causing the exception about foreign keys/relations that you were seeing. I have committed patches to the 0.6 branch, and also to the current development branch. Using the patched MBuilder I am now able to successfully add your schema to a mart. I hope it works for you too now! :) cheers, Richard WICK GANKANDA wrote: > Dear Richard, > > I am a software developer working for Computational Regulatory Genomics > Center at > the California Institute of Technology. > We are trying to use BioMart for the sea urchin genome and would > appreciate your help. > Since I am new to BioMart, its configurations and the sea urchin genome > database, > pardon the lack of formal details. > > I read your comments on "Tips on making tables from sequence/annotation > data" > at URL: http://www.mail-archive.com/[email protected]/msg01214.html. > I followed the steps on Creating the mart as stated in this doc: > http://www.biomart.org/user-docs.pdf > We were able to successfully test connect to the database. > But when we click on the Add button to connect to the database, it > errors out: > > Error: BioMartError: org.biomart.common.exceptions.AssociationException: > A foreign key can be associated once to the same table or many times to > other tables, but not both. > > I am not sure how to fix this. Have you experienced this before? > > Regards, > > Wick Gankanda > California Institute of Technology > Pasadena, California > 626-395-5816 - -- Richard Holland (BioMart) EMBL EBI, Wellcome Trust Genome Campus, Hinxton, Cambridgeshire CB10 1SD, UK Tel. +44 (0)1223 494416 http://www.biomart.org/ http://www.biojava.org/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHowpc4C5LeMEKA/QRApnIAJ9rKgkx62KcWr2OmPOia4dQ6uUZ+gCghwkE 9LGTH91SVf2ydLg+nC5+4NY= =j6kv -----END PGP SIGNATURE-----
