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 ? > 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. > 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. > 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 behaviour in the way you are reporting. Are you using exactly the same JDBC driver? > 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. No relevant as far as I can tell. > 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 > 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-dev-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-dev-h...@jakarta.apache.org