Re: [XMLPipeDB-developer] PreparedStatement query parameters

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

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.