Ah, in that case, have a read of this previous post on the same subject:
http://www.nabble.com/How-to-query-%27value%27-in-%27seqfeature_qualifier_value%27-using-HQL-td17511584.html
2008/9/12 Augusto Fernandes Vellozo <[EMAIL PROTECTED]>:
> Hi Richard,
>
> The problem is to obtain the sequence object, because the sequence object I
> require depends on the seqfeature_qualifier_value.
> I don't have the sequence object, i need to search and obtain the sequence
> related to one value stored in seqfeature_qualifier_value.
> I know how to do this using SQL query directly, but i don't know how do this
> using hibernate.
>
> Thanks,
>
> Augusto
>
> 2008/9/12 Richard Holland <[EMAIL PROTECTED]>
>>
>> Augusto,
>>
>> If you can adapt Zagato's code to load the sequence object you
>> require, then you will find the seqfeature_qualifier_value entries are
>> accessible by iterating over the sequence object's features then
>> within each feature iterating over the Notes.
>>
>> cheers,
>> RIchard
>>
>> 2008/9/11 Zagato <[EMAIL PROTECTED]>:
>> > The proccess to get an object using hibernate it's something like this:
>> >
>> > TestClass // This is the class
>> > objTestClass // this is the object from the class
>> >
>> > @@@@@@@@@@
>> >
>> > TestClass objTestClass = null;
>> > hbn_session.clear();
>> > Query query = hbn_session.createQuery( "from TestClass where attribute =
>> > :attribute" );
>> > query.setParameter("attribute", 55); // Here you set the value for the
>> > specific where..
>> > List list = query.list(); // You get the result that match
>> > if( list.size() == 1 )
>> > objTestClass = (TestClass)list.get(0);
>> >
>> > Remenber, you must have the map file in xml to hibernate, i don't
>> > remember
>> > well but in the documentacion from biojava it's a better example...
>> >
>> > (http://www.biojava.org/wiki/BioJava:Cookbook#BioSQL_and_Sequence_Databases)
>> >
>> > I hope this helps you.. Bye !!!
>> >
>> > Alan Jairo Acosta
>> >
>> >
>> > On Thu, Sep 11, 2008 at 4:54 AM, Augusto Fernandes Vellozo <
>> > [EMAIL PROTECTED]> wrote:
>> >
>> >> Hi all.
>> >>
>> >> I don't know very well hibernate, and I am with problems to do one
>> >> query
>> >> into database BIOSQL using Biojavax.
>> >>
>> >> Given one organism (NVBITaxon), I need to get the feature with one
>> >> specific
>> >> value of one property (field value of table
>> >> SeqFeature_qualifier_value).
>> >>
>> >> Please, somebody knows how can i do this?
>> >>
>> >> Thanks a lot,
>> >>
>> >> --
>> >> Augusto F. Vellozo
>> >>
>> >>
>> >>
>> >> --
>> >> Augusto F. Vellozo
>> >> _______________________________________________
>> >> Biojava-l mailing list - Biojava-l@lists.open-bio.org
>> >> http://lists.open-bio.org/mailman/listinfo/biojava-l
>> >>
>> >
>> >
>> >
>> > --
>> > Farewell.
>> > http://www.youtube.com/zagatogekko
>> > ruby << __EOF__
>> > puts [ 111, 116, 97, 103, 97, 90 ].collect{|v| v.chr}.join.reverse
>> > __EOF__
>> > _______________________________________________
>> > Biojava-l mailing list - Biojava-l@lists.open-bio.org
>> > http://lists.open-bio.org/mailman/listinfo/biojava-l
>> >
>>
>>
>>
>> --
>> Richard Holland, BSc
>> Finance Director, Eagle Genomics Ltd
>> M: +44 7500 438846 | E: [EMAIL PROTECTED]
>> http://www.eaglegenomics.com/
>
>
>
> --
> Augusto F. Vellozo
>
--
Richard Holland, BSc
Finance Director, Eagle Genomics Ltd
M: +44 7500 438846 | E: [EMAIL PROTECTED]
http://www.eaglegenomics.com/
_______________________________________________
Biojava-l mailing list - Biojava-l@lists.open-bio.org
http://lists.open-bio.org/mailman/listinfo/biojava-l
