On 01/06/2009, Shadar <shaul...@gmail.com> wrote: > > 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
.jms ? + Sorry, meant .jmx > 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". Check the JMeter log file as well. + No errors in log file. > 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. Try removing this just in case. + I did. No effect. > This seems to be related to JDBC connection. Has this changed in 2.3.3? Yes - see the changes document - but the changes are unlikely to affect the behavior in the way you are reporting. Are you using exactly the same JDBC driver? + Yes. If I remove the driver I get a missing driver error. It is enough to have a JDBC Connection config + JDBC request (e.g. "select 1") to create this error, on iteration 2 and higher > 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? See: http://jakarta.apache.org/jmeter/usermanual/functions.html#__Random + Yes, I read about that. What I meant is how di I use it in a select statement? Also is there a workaround in 2.3.2 to the nice functionality added in 2.3.3 of saving JDBC Request query results to variables (allows for continuation queries)? Thanks again, -- 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-tp23818467p23830470.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
