[BioSQL-l] _removeSequence

Martina boehme at mpiib-berlin.mpg.de
Tue Jun 21 09:55:15 EDT 2005


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
>>


More information about the BioSQL-l mailing list