Re: [XMLPipeDB-developer] PreparedStatement query parameters

[Richard B. <rbr...@gm...>]

OK, spent some time digging through it with an eye to that 3rd '?'

I believe I simply need to add as many ps.setString(?,
Integer.*toString*(selected.getTaxon()));
as there are species selected.

Exports for single species work fine but if I want to export 2 species I
need the following (example is hardcoded):



ps = ConnectionManager.*getRelationalDBConnection*().prepareStatement(
basePrepareStatement.toString() );

*

for* ( SpeciesProfile selected : selectedSpeciesProfiles ) {

 ps.setString(1, Integer.*toString*(selected.getTaxon()));

ps.setString(2, Integer.*toString*(selected.getTaxon()));

ps.setString(3, systemTable.getKey());

result = ps.executeQuery();

etc...

 The solve is to programmatically build the ps.set... going forward.

Richard



On Tue, Aug 23, 2011 at 8:53 PM, John David N. Dionisio <do...@lm...>wrote:


> Hi Rich,
>
> Sure, I don't think it will do any harm to give the method another
> once-over.  What you have to see solidly are:
>
> - What information does this method extract from the relational database?
> - What information does this method send to the Gene Database?
>
> As to the code --- no, I did not change anything.  I only added comments.
>  Not sure about the successful export then.  What I thought was that you did
> execute the changes I described, and that is how you successfully exported
> the .gdb.
>
>  John David N. Dionisio, PhD
> Associate Professor, Computer Science
> Loyola Marymount University
>
>
>
>
>  On Aug 23, 2011, at 8:41 PM, Richard Brous wrote:
>
> > Yes your comments make sense but I feel as though my understanding of
> this method is the weak link... I'll work through it again tomorrow.
> >
> > Also, in thinking back over our discussions regarding
> getSystemTableManager(), I read through the code again and saw your
> comments.
> >
> > Then I realized I may have assumed you corrected the method when you may
> only in fact had commented... Was this the case?
> >
> > But then how did I get a successful two species export yesterday?
> >
> > OK, my brain is starting to hurt...
> >
> > I'm going to head to bed and start fresh tomorrow.
> >
> > Richard
> >
> > On Tue, Aug 23, 2011 at 8:18 PM, John David N. Dionisio <do...@lm...>
> wrote:
> > Hi Rich,
> >
> > The key is this message:
> >
> > org.postgresql.util.PSQLException: No value specified for parameter 3.
> >
> > That means the third question mark in the query (which turns out to be
> type = ?) was never given a value.  Check that method and make sure that the
> code invokes as many set's as there are question marks in the query.  And
> for this particular query, the last set is for the gene database type.
> >
> > John David N. Dionisio, PhD
> > Associate Professor, Computer Science
> > Loyola Marymount University
> >
> >
> > On Aug 23, 2011, at 7:59 PM, Richard Brous <rbr...@gm...> wrote:
> >
> >> org.postgresql.util.PSQLException: No value specified for parameter 3.
> >
> >
> ------------------------------------------------------------------------------
> > EMC VNX: the world's simplest storage, starting under $10K
> > The only unified storage solution that offers unified management
> > Up to 160% more powerful than alternatives and 25% more efficient.
> > Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> > _______________________________________________
> > xmlpipedb-developer mailing list
> > xml...@li...
> > https://lists.sourceforge.net/lists/listinfo/xmlpipedb-developer
> >
> >
>
> > <ATT00001..txt><ATT00002..txt>
>
>
>
> ------------------------------------------------------------------------------
> EMC VNX: the world's simplest storage, starting under $10K
> The only unified storage solution that offers unified management
> Up to 160% more powerful than alternatives and 25% more efficient.
> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
> _______________________________________________
> xmlpipedb-developer mailing list
> xml...@li...
> https://lists.sourceforge.net/lists/listinfo/xmlpipedb-developer
>
>