[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