Re: [XMLPipeDB-developer] PreparedStatement query parameters

[John D. N. D. <do...@lm...>]

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>