On Tue, 3 Nov 2009, Carl Shelbourne wrote:
> The SQL shown below works if I do not have any parameters, but when I add
> the parameters, I get:
> Caused by: org.postgresql.util.PSQLException: The column index is out of ra
> nge: 1, number of columns: 0.
The ? parameters you've used are inside a string literal, so they are not
considered parameters. Consider:
SELECT 'Does this work?';
The question mark is part of the literal, not a parameter.
In response to
pgsql-jdbc by date
|Next:||From: Michael Wood||Date: 2009-11-03 18:29:08|
|Subject: Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list|
|Previous:||From: Kris Jurka||Date: 2009-11-03 18:16:15|
|Subject: Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't
get list of databases with \list|