"Virag Saksena" <[EMAIL PROTECTED]> writes: > ERROR: no value found for parameter 1
> Here is sample code which causes this exception ... > pst=prodconn.prepareStatement("explain analyze select count(*) from > jam_heaprel r where heap_id = ? and parentaddr = ?"); I don't think EXPLAIN can take parameters (most of the "utility" statements don't take parameters). The usual workaround is to use PREPARE: PREPARE foo(paramtype,paramtype) AS SELECT ...; EXPLAIN EXECUTE foo(x,y); This will generate the same parameterized plan as you'd get from the other way, so it's a reasonable approximation to the behavior with JDBC parameters. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly