On 16 June 2011 17:21, Konstantin S. <mko...@gmail.com> wrote: > Response message: java.sql.SQLException: No suitable driver found for > ${databaseUrl} > > It looks like sample ( whichever you use) can not obtain value of variable
Yes, because the JDBC Config reads the variable before CSV Dataset has run. Try defining the variables on the Test Plan. > and tries to pass this ${databaseUrl} instead of the value . > I guess error should be like... > > Response message: java.sql.SQLException: No suitable driver found for > jdbc:mysql://localhost:3306/osax Yes, it would be if the variable were defined but incorrect. > > On Thu, Jun 16, 2011 at 7:12 PM, Alexander Guzman > <aguz...@tlcdelivers.com>wrote: > >> JMeter Version: 2.4 r961953 >> >> >> >> I’m attempting to load the connection information from an external CSV >> file. >> I’ve attached a Debug Sampler and can see that the variables are making it >> into memory as seen below. >> >> >> >> JMeterVariables: >> >> >> DatabaseConnection=org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl@29021f42 >> >> JMeterThread.last_sample_ok=true >> >> JMeterThread.pack=org.apache.jmeter.threads.SamplePackage@4a523b16 >> >> START.HMS=172648 >> >> START.MS=1308094008358 >> >> START.YMD=20110614 >> >> TESTSTART.MS=1308155812780 >> >> databaseJDBCDriverClass=com.mysql.jdbc.Driver >> >> databasePassword=test >> >> databaseUrl=jdbc:mysql://localhost:3306/osax >> >> databaseUser=test >> >> >> >> But I’m unable to use any of the variables in the JDBC Connection >> Configuration as seen below: >> >> >> >> Thread Name: Thread Users 1-1 >> >> Sample Start: 2011-06-15 10:36:51 MDT >> >> Load time: 0 >> >> Latency: 0 >> >> Size in bytes: 0 >> >> Sample Count: 1 >> >> Error Count: 1 >> >> Response code: 08001 0 >> >> Response message: java.sql.SQLException: No suitable driver found for >> ${databaseUrl} >> >> >> >> Does anyone have any input because I’m lost at this point. Any help would >> be >> appreciated. >> >> >> >> Regards, >> >> Xander >> > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org