Hi, I am using JMeter to test against a postgresql 8.3 DB, using JDBC. I want to run random SQL queries (working with CSV till now -- that went well, and JMeter is great once you figure it out!).
I just upgraded from JMeter 2.3.2 to 2.3.3 in order to get the new random variable config element. When I loaded in JMeter 2.3.3 the same .jms test plan I used before with JMeter 2.3.2 the first query went fine, but all the following ones give a JDBC error: "org.postgresql.util.PSQLException: This statement has been closed". Note: after untarring 2.3.3 I placed the JDBC driver postgresql-8.3-603.jdbc4.jar in the lib folder, as I have done for 2.3.2. Also (though not relevant IMHO) I am using the StatAggVisualizer.jar, placed under lib/ext in 2.3.2 and 2.3.3. This seems to be related to JDBC connection. Has this changed in 2.3.3? I tried using only 1 thread and playing with the connection properties, but error persists. Please see if http://forums.sun.com/thread.jspa?threadID=782570 http://forums.sun.com/thread.jspa?threadID=782570 is related, in particular comment on the bottom. Also if I need to go back to 2.3.2, can you point me to explanation of how to use the __Random() function in a JDBC request SQL query, instead of the random variable config element? Thanks, -- Shaul -- View this message in context: http://www.nabble.com/Bug-report-for-JMeter-2.3.3-%28regression-from-2.3.2%29%3A-JDBC-error---org.postgresql.util.PSQLException%3A-This-statement-has-been-closed-tp23818467p23818467.html Sent from the JMeter - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-dev-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-dev-h...@jakarta.apache.org
