[Biojava-l] how to get specific data from biosql database

[gang wu]

Sorry for posting to the wrong list.Seems my mail client(Thunderbird) 
filters has a little problem and some BioJava list mails are saved in my 
BioSQL list folder. And I happened to pick one from BioJava and posed to 
the list address. I'll double check the list address in the future. Thanks.

Gang

David Huen wrote:
> On Sep 26 2006, gang wu wrote:
>
> Have you mailed the wrong list inadvertently? It would seem to be 
> intended for Bioperl-l.
>
> Best wishes,
> David Huen
>
>> Hi Everyone,
>>
>> I finally finished loading some Genbank genome sequences(Arabidopsis 
>> thaliana and C. elegans) into my MySQL(5.0.19 on Redhad AS 4) BioSQL 
>> database though the load_seqdatabase.pl works extremely slow(If 
>> turning on -debug, a lot of messages about not able to find adaptor 
>> class for Bio::Annotation::TypeManager, is this about the dynamic 
>> library loading issue mention in one of Hilmar's message?).
>>
>> Now I'm writing views and stored procedures so other projects can 
>> easily retrieve specific information. It's quite easy to write views 
>> like  showing all organisms, showing all version information etc. But 
>> so far I have not figured out how to write a SQL statement to list 
>> all genes corresponding to the genbank files. Can anyone show me how 
>> to get the information or let me know where to find related guide? 
>> Thanks in advance.
>>
>