Ok,
so, Xander you can select Test Plan and add user defined variable
for example
name jss_id and value ${__CSVRead(jsession.txt,0)}
this will read value from file jsession.txt from 1st column
or you can use properties as Deepak suggested
On Thu, Jun 16, 2011 at 7:26 PM, sebb <seb...@gmail.com> wrote:
> 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
>
>
