Re: [PERFORM] ERROR: no value found for parameter 1 with JDBC and Explain Analyze

2005-11-18 Thread Tom Lane
"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

[PERFORM] ERROR: no value found for parameter 1 with JDBC and Explain Analyze

2005-11-18 Thread Virag Saksena
Hi, I am trying to use Explain Analyze to trace a slow SQL statement called from JDBC. The SQL statement with the parameters taked 11 seconds. When I run a explain analyze from psql, it takes < 50 ms with a reasonable explain plan. However when I try to run an explain analyze from JDBC with the