That means, that I can't have 2 features refering to the same bioentry with the same type (= type_term_id)and source (=source_term_id) but different parent features because of the composite key bioentry_id in the seqfeature table? Or what does "rank" in that table mean (its part of that key), how can I get different ranks?

Martina

Hilmar Lapp wrote:

The Biojava people will respond to this. Note though that Term_Relationship is for storing subject-predicate-object triples of terms, so I'm not sure why you want to use it for storing/associating annotation. Maybe you meant bioentry_qualifier_value?

    -hilmar

On Jun 21, 2005, at 3:10 AM, Martina wrote:


Yes. When you insert a sequence you must be prepared that when inserting its ontology term or tag/value annotation the term may already be present because another bioentry uses it too.


Ok, the proper way is to catch the SQLException in BIOSQLFeature, test if it is a Dublicate key entry, get the identifier of the term (would that be the BioSQLfeatureId ?) and insert it in the term_relationship table? And there is no nice BioJava method for this, I have to do it "manually", like conn.prepareStatement(..) and stuff? BioJava spoiled me so!

Martina

_______________________________________________
Biojava-l mailing list  -  Biojava-l@biojava.org
http://biojava.org/mailman/listinfo/biojava-l

Reply via email to