On 01/06/2009, sebb <seb...@gmail.com> wrote: > 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 >
Also, make sure you disable connection pooling, set Max Number of Connections = 0. > > > 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