gusdev-gusdev

[Gusdev-gusdev] WDK classic install, setting sql

[MICHAEL L. <lu...@cs...>]

Just a quick question, in case anyone knows.  Elsewise I'll still be
digging around:

In the WDK-classic installation, you supply a configuration file which
specifies which pages you want to serve up, and certain paramaters, like
the sql statement that is used.  I've changed some stuff for
GenomicSequencePage to make it more applicable to CTEGD web apps, and
altered following in the supplied config file:

gseqDescrQ.SQL=select ena.source_id, ena.name, ena.description, ed.name
dbname, \
  tn.name, ena.length \
  from dots.ExternalNASequence ena, sres.TaxonName tn,
sres.ExternalDatabase ed, \
  sres.ExternalDatabaseRelease edr \
  where ena.na_sequence_id = $$0$$ \
  and ena.taxon_id = tn.taxon_id \
  and tn.name_class = 'scientific name' \
  and ena.external_database_release_id = edr.external_database_release_id \
  and edr.external_database_id = ed.external_database_id \
  and edr.external_database_release_id not in (@PRIVATE_SEQ_DB_IDS@)

to:

gseqDescrQ.SQL=select *\
  from dots.ExternalNASequence\
  where external_database_release_id = $$0$$ \
  and source_id = $$1$$

I know that this gets set, but for some reason the number of parameters
does not change.  Is this hard coded somewhere?  In my error
file(CATALINA.OUT) I get the following:

Running query:
select *  from dots.ExternalNASequence  where external_database_release_id
= 35   and source_id = $$1$$
java.sql.SQLException: ORA-00911: invalid character

But I know that I am passing an array with two elements in it, and it is
obviously getting the first one.


If any knows why it won't insert the second parameter, please let me know.


Michael Luchtan
http://www.cs.uga.edu/~luchtan

Re: [Gusdev-gusdev] WDK classic install, setting sql

[Angel P. <an...@pc...>]

query parameters (eg. "$$0$$", "$$1$$") get set by the "Params" 
attribute. In your case :

gseqDescrQ.Params=intP

where "intP" is defined later in the file as :

intP.class=IntParam
intP.Prompt=Integer

You must define two parameters for "$$0$$" and $$1$$ in your query.

gseqDescrQ.SQL=select *\
  from dots.ExternalNASequence\
  where external_database_release_id = $$0$$ \
  and source_id = $$1$$

you can keep "intP" for $$0$$, since this is an integer, but source_id is a string, hence you must use a StringParam

change "gseqDescrQ.Params=intP" to "gseqDescrQ.Params=intP,stringP" since "stringP" is already defined in this config file as:

stringP.class=StringParam
stringP.Prompt=Enter a string:
stringP.Description=String


Angel


MICHAEL LUCHTAN wrote:

>Just a quick question, in case anyone knows.  Elsewise I'll still be
>digging around:
>
>In the WDK-classic installation, you supply a configuration file which
>specifies which pages you want to serve up, and certain paramaters, like
>the sql statement that is used.  I've changed some stuff for
>GenomicSequencePage to make it more applicable to CTEGD web apps, and
>altered following in the supplied config file:
>
>gseqDescrQ.SQL=select ena.source_id, ena.name, ena.description, ed.name
>dbname, \
>  tn.name, ena.length \
>  from dots.ExternalNASequence ena, sres.TaxonName tn,
>sres.ExternalDatabase ed, \
>  sres.ExternalDatabaseRelease edr \
>  where ena.na_sequence_id = $$0$$ \
>  and ena.taxon_id = tn.taxon_id \
>  and tn.name_class = 'scientific name' \
>  and ena.external_database_release_id = edr.external_database_release_id \
>  and edr.external_database_id = ed.external_database_id \
>  and edr.external_database_release_id not in (@PRIVATE_SEQ_DB_IDS@)
>
>to:
>
>gseqDescrQ.SQL=select *\
>  from dots.ExternalNASequence\
>  where external_database_release_id = $$0$$ \
>  and source_id = $$1$$
>
>I know that this gets set, but for some reason the number of parameters
>does not change.  Is this hard coded somewhere?  In my error
>file(CATALINA.OUT) I get the following:
>
>Running query:
>select *  from dots.ExternalNASequence  where external_database_release_id
>= 35   and source_id = $$1$$
>java.sql.SQLException: ORA-00911: invalid character
>
>But I know that I am passing an array with two elements in it, and it is
>obviously getting the first one.
>
>
>If any knows why it won't insert the second parameter, please let me know.
>
>
>Michael Luchtan
>http://www.cs.uga.edu/~luchtan
>
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by EclipseCon 2004
>Premiere Conference on Open Tools Development and Integration
>See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
>http://www.eclipsecon.org/osdn
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>  
>

Re: [Gusdev-gusdev] WDK classic install, setting sql

[MICHAEL L. <lu...@cs...>]

Gracies-
That works, and saves a lot of hunting, I'm sure.

Michael Luchtan
http://www.cs.uga.edu/~luchtan


On Tue, 10 Feb 2004, Angel Pizarro wrote:

> query parameters (eg. "$$0$$", "$$1$$") get set by the "Params"
> attribute. In your case :
>
> gseqDescrQ.Params=intP
>
> where "intP" is defined later in the file as :
>
> intP.class=IntParam
> intP.Prompt=Integer
>
> You must define two parameters for "$$0$$" and $$1$$ in your query.
>
> gseqDescrQ.SQL=select *\
>   from dots.ExternalNASequence\
>   where external_database_release_id = $$0$$ \
>   and source_id = $$1$$
>
> you can keep "intP" for $$0$$, since this is an integer, but source_id is a string, hence you must use a StringParam
>
> change "gseqDescrQ.Params=intP" to "gseqDescrQ.Params=intP,stringP" since "stringP" is already defined in this config file as:
>
> stringP.class=StringParam
> stringP.Prompt=Enter a string:
> stringP.Description=String
>
>
> Angel
>
>
> MICHAEL LUCHTAN wrote:
>
> >Just a quick question, in case anyone knows.  Elsewise I'll still be
> >digging around:
> >
> >In the WDK-classic installation, you supply a configuration file which
> >specifies which pages you want to serve up, and certain paramaters, like
> >the sql statement that is used.  I've changed some stuff for
> >GenomicSequencePage to make it more applicable to CTEGD web apps, and
> >altered following in the supplied config file:
> >
> >gseqDescrQ.SQL=select ena.source_id, ena.name, ena.description, ed.name
> >dbname, \
> >  tn.name, ena.length \
> >  from dots.ExternalNASequence ena, sres.TaxonName tn,
> >sres.ExternalDatabase ed, \
> >  sres.ExternalDatabaseRelease edr \
> >  where ena.na_sequence_id = $$0$$ \
> >  and ena.taxon_id = tn.taxon_id \
> >  and tn.name_class = 'scientific name' \
> >  and ena.external_database_release_id = edr.external_database_release_id \
> >  and edr.external_database_id = ed.external_database_id \
> >  and edr.external_database_release_id not in (@PRIVATE_SEQ_DB_IDS@)
> >
> >to:
> >
> >gseqDescrQ.SQL=select *\
> >  from dots.ExternalNASequence\
> >  where external_database_release_id = $$0$$ \
> >  and source_id = $$1$$
> >
> >I know that this gets set, but for some reason the number of parameters
> >does not change.  Is this hard coded somewhere?  In my error
> >file(CATALINA.OUT) I get the following:
> >
> >Running query:
> >select *  from dots.ExternalNASequence  where external_database_release_id
> >= 35   and source_id = $$1$$
> >java.sql.SQLException: ORA-00911: invalid character
> >
> >But I know that I am passing an array with two elements in it, and it is
> >obviously getting the first one.
> >
> >
> >If any knows why it won't insert the second parameter, please let me know.
> >
> >
> >Michael Luchtan
> >http://www.cs.uga.edu/~luchtan
> >
> >
> >
> >
> >-------------------------------------------------------
> >The SF.Net email is sponsored by EclipseCon 2004
> >Premiere Conference on Open Tools Development and Integration
> >See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> >http://www.eclipsecon.org/osdn
> >_______________________________________________
> >Gusdev-gusdev mailing list
> >Gus...@li...
> >https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> >
> >
>
>

Re: [Gusdev-gusdev] WDK classic install, setting sql

[Angel P. <an...@pc...>]

No problem.
BTW, your SQL should enclose the string as in sjingle quotes and 
probably use the 'like' operator, instead of the "="

gseqDescrQ.SQL=select *\
  from dots.ExternalNASequence\
  where external_database_release_id = $$0$$ \
  and source_id like  '$$1$$'

Angel




MICHAEL LUCHTAN wrote:

>Gracies-
>That works, and saves a lot of hunting, I'm sure.
>
>Michael Luchtan
>http://www.cs.uga.edu/~luchtan
>
>
>On Tue, 10 Feb 2004, Angel Pizarro wrote:
>
>  
>
>>query parameters (eg. "$$0$$", "$$1$$") get set by the "Params"
>>attribute. In your case :
>>
>>gseqDescrQ.Params=intP
>>
>>where "intP" is defined later in the file as :
>>
>>intP.class=IntParam
>>intP.Prompt=Integer
>>
>>You must define two parameters for "$$0$$" and $$1$$ in your query.
>>
>>gseqDescrQ.SQL=select *\
>>  from dots.ExternalNASequence\
>>  where external_database_release_id = $$0$$ \
>>  and source_id = $$1$$
>>
>>you can keep "intP" for $$0$$, since this is an integer, but source_id is a string, hence you must use a StringParam
>>
>>change "gseqDescrQ.Params=intP" to "gseqDescrQ.Params=intP,stringP" since "stringP" is already defined in this config file as:
>>
>>stringP.class=StringParam
>>stringP.Prompt=Enter a string:
>>stringP.Description=String
>>
>>
>>Angel
>>
>>
>>MICHAEL LUCHTAN wrote:
>>
>>    
>>
>>>Just a quick question, in case anyone knows.  Elsewise I'll still be
>>>digging around:
>>>
>>>In the WDK-classic installation, you supply a configuration file which
>>>specifies which pages you want to serve up, and certain paramaters, like
>>>the sql statement that is used.  I've changed some stuff for
>>>GenomicSequencePage to make it more applicable to CTEGD web apps, and
>>>altered following in the supplied config file:
>>>
>>>gseqDescrQ.SQL=select ena.source_id, ena.name, ena.description, ed.name
>>>dbname, \
>>> tn.name, ena.length \
>>> from dots.ExternalNASequence ena, sres.TaxonName tn,
>>>sres.ExternalDatabase ed, \
>>> sres.ExternalDatabaseRelease edr \
>>> where ena.na_sequence_id = $$0$$ \
>>> and ena.taxon_id = tn.taxon_id \
>>> and tn.name_class = 'scientific name' \
>>> and ena.external_database_release_id = edr.external_database_release_id \
>>> and edr.external_database_id = ed.external_database_id \
>>> and edr.external_database_release_id not in (@PRIVATE_SEQ_DB_IDS@)
>>>
>>>to:
>>>
>>>gseqDescrQ.SQL=select *\
>>> from dots.ExternalNASequence\
>>> where external_database_release_id = $$0$$ \
>>> and source_id = $$1$$
>>>
>>>I know that this gets set, but for some reason the number of parameters
>>>does not change.  Is this hard coded somewhere?  In my error
>>>file(CATALINA.OUT) I get the following:
>>>
>>>Running query:
>>>select *  from dots.ExternalNASequence  where external_database_release_id
>>>= 35   and source_id = $$1$$
>>>java.sql.SQLException: ORA-00911: invalid character
>>>
>>>But I know that I am passing an array with two elements in it, and it is
>>>obviously getting the first one.
>>>
>>>
>>>If any knows why it won't insert the second parameter, please let me know.
>>>
>>>
>>>Michael Luchtan
>>>http://www.cs.uga.edu/~luchtan
>>>
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>The SF.Net email is sponsored by EclipseCon 2004
>>>Premiere Conference on Open Tools Development and Integration
>>>See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
>>>http://www.eclipsecon.org/osdn
>>>_______________________________________________
>>>Gusdev-gusdev mailing list
>>>Gus...@li...
>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>
>>>
>>>      
>>>
>>    
>>