You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by sijay reddy <si...@gmail.com> on 2007/09/24 12:58:11 UTC
Connecting to database by using JDBC request
Hi i have a doubt regarding how to connect to database by using jmeter...
i have prepared the test plan as specified in the usermanual...i dounloaded
the "mysql-connector-java-bin.jar " file and copied that jar file to lib
directory
hear am listing the details which i had given in Database Connection
Configuration
Database URL: jdbc:mysql://192.168.1.101:3306/ams_newaug9
JDBC Driver Class:com.mysql.jdbc.Driver
Username: xxxx
Password:xxxx
but while running the testplan am getting the Response message:
java.sql.SQLException: No suitable driver
am not getting where i committed mistake...please let me know
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
Hi sebb is there any thing to add in* user.classpath *in jmeter.properties
?????????????
On 9/26/07, sebb <se...@gmail.com> wrote:
>
> This is getting rather tedious:
>
> Check that the classname field in the test plan does not have any
> extraneous spaces in it.
>
> JMeter does not include any JDBC drivers; you have to download the
> appropriate driver from whoever provides the database you are using.
>
> On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > How to check ....am not getting how to check the jar file
> > am generally asking why we are copying that JDBC driver???
> >
> >
> > On 9/26/07, sebb <se...@gmail.com> wrote:
> > >
> > > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > Hi sebb please clarify my doubts
> > > > 1)what is the use of copying the jar file to the bin ...
> > >
> > > Where did I write that?
> > >
> > > > 2)hear am not at all using any thing belongs to java ...am just
> trying
> > > to
> > > > access the data base...then why you are asking about java version
> > >
> > > Because older versions of Java don't work properly with JMeter.
> > >
> > > > if you feel these are silly questions ...please dont mind....am new
> to
> > > > jmeter and dont have much knowledge about java...so am asking
> > > >
> > > > On 9/26/07, sijay reddy <si...@gmail.com> wrote:
> > > > >
> > > > > java version is 1.4
> > >
> > > OK, assuming it is a Sun version.
> > >
> > > > > On 9/26/07, sebb <se...@gmail.com> wrote:
> > > > > >
> > > > > > Should be OK, given what you have told us.
> > > > > >
> > > > > > Which version of Java?
> > > > > >
> > > > > > Just had a thought - spaces are invisible in log files - check
> that
> > > you
> > > > > > don't have a trailing space in the driver class name field.
> > >
> > > Did you check for trailing spaces in the class name???
> > >
> > > > > >
> > > > > > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > > > >
> > > > > > > Have you checked to see if the class is actually in the jar?
> > > > > > > yes ...Driver class is present in the jar file
> > > > > > >
> > > > > > > Which version of JMeter and Java are you using?
> > > > > > > am using jmeter 2.3RC3 version ...hear am just trying to
> connect
> > > to
> > > > > > the
> > > > > > > database ...
> > > > > > > First of all i will explain how i created test plan...
> > > > > > > my testplan contains only one JDBC request which contining the
> > > > > > required
> > > > > > > query and
> > > > > > > one JDBC connection configuration which containg the details
> of
> > > > > > Database
> > > > > > > URL,JDBC driver class ,username and password
> > > > > > > is there any thing wrong in m testplan??????
> > > > > > >
> > > > > > > What command are you using to start JMeter?
> > > > > > > i fallowed two procedures to start jmeter
> > > > > > > 1)just by clicking the jmeter batch file which is located in
> bin
> > > > > > > 2)by using command prompt giving the command jmeter -H
> > > 192.168.1.101-P
> > > > > > > 8080
> > > > > > >
> > > > > > >
> > > > > > > whats the wrong in my test plan
> > > > > > >
> > > > > > >
> > > > > > > On 9/25/07, sebb < sebbaz@gmail.com> wrote:
> > > > > > > >
> > > > > > > > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > > > > > >
> > > > > > > > > Hi sebb hear am attaching the contents of the log
> > > file....please
> > > > > > once
> > > > > > > go
> > > > > > > > > through it and tell me what
> > > > > > > > > is missing..
> > > > > > > > > 2007/09/25 15:53:27 INFO -
> jmeter.engine.StandardJMeterEngine
> > > :
> > > > > > > Running
> > > > > > > > > the
> > > > > > > > > test!
> > > > > > > > >
> > > > > > > > > 2007/09/25 15:53:27 WARN -
> > > > > > > > jmeter.protocol.jdbc.config.DataSourceElement:
> > > > > > > > > Could not load driver: com.mysql.jdbc.Driver
> > > > > > > > > java.lang.ClassNotFoundException : com/mysql/jdbc/Driver
> > > > > > > > > at java.lang.Class.forName0(Native Method)
> > > > > > > > > at java.lang.Class.forName(Class.java:219)
> > > > > > > >
> > > > > > > >
> > > > > > > > The problem is just that JMeter cannot find the driver.
> > > > > > > >
> > > > > > > > I don't know why this should be.
> > > > > > > >
> > > > > > > > Have you checked to see if the class is actually in the jar?
> > > > > > > >
> > > > > > > > Which version of JMeter and Java are you using?
> > > > > > > >
> > > > > > > > What command are you using to start JMeter?
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >
> > >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Re: Connecting to database by using JDBC request
Posted by sebb <se...@gmail.com>.
This is getting rather tedious:
Check that the classname field in the test plan does not have any
extraneous spaces in it.
JMeter does not include any JDBC drivers; you have to download the
appropriate driver from whoever provides the database you are using.
On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> How to check ....am not getting how to check the jar file
> am generally asking why we are copying that JDBC driver???
>
>
> On 9/26/07, sebb <se...@gmail.com> wrote:
> >
> > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > Hi sebb please clarify my doubts
> > > 1)what is the use of copying the jar file to the bin ...
> >
> > Where did I write that?
> >
> > > 2)hear am not at all using any thing belongs to java ...am just trying
> > to
> > > access the data base...then why you are asking about java version
> >
> > Because older versions of Java don't work properly with JMeter.
> >
> > > if you feel these are silly questions ...please dont mind....am new to
> > > jmeter and dont have much knowledge about java...so am asking
> > >
> > > On 9/26/07, sijay reddy <si...@gmail.com> wrote:
> > > >
> > > > java version is 1.4
> >
> > OK, assuming it is a Sun version.
> >
> > > > On 9/26/07, sebb <se...@gmail.com> wrote:
> > > > >
> > > > > Should be OK, given what you have told us.
> > > > >
> > > > > Which version of Java?
> > > > >
> > > > > Just had a thought - spaces are invisible in log files - check that
> > you
> > > > > don't have a trailing space in the driver class name field.
> >
> > Did you check for trailing spaces in the class name???
> >
> > > > >
> > > > > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > > >
> > > > > > Have you checked to see if the class is actually in the jar?
> > > > > > yes ...Driver class is present in the jar file
> > > > > >
> > > > > > Which version of JMeter and Java are you using?
> > > > > > am using jmeter 2.3RC3 version ...hear am just trying to connect
> > to
> > > > > the
> > > > > > database ...
> > > > > > First of all i will explain how i created test plan...
> > > > > > my testplan contains only one JDBC request which contining the
> > > > > required
> > > > > > query and
> > > > > > one JDBC connection configuration which containg the details of
> > > > > Database
> > > > > > URL,JDBC driver class ,username and password
> > > > > > is there any thing wrong in m testplan??????
> > > > > >
> > > > > > What command are you using to start JMeter?
> > > > > > i fallowed two procedures to start jmeter
> > > > > > 1)just by clicking the jmeter batch file which is located in bin
> > > > > > 2)by using command prompt giving the command jmeter -H
> > 192.168.1.101-P
> > > > > > 8080
> > > > > >
> > > > > >
> > > > > > whats the wrong in my test plan
> > > > > >
> > > > > >
> > > > > > On 9/25/07, sebb < sebbaz@gmail.com> wrote:
> > > > > > >
> > > > > > > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > > > > >
> > > > > > > > Hi sebb hear am attaching the contents of the log
> > file....please
> > > > > once
> > > > > > go
> > > > > > > > through it and tell me what
> > > > > > > > is missing..
> > > > > > > > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine
> > :
> > > > > > Running
> > > > > > > > the
> > > > > > > > test!
> > > > > > > >
> > > > > > > > 2007/09/25 15:53:27 WARN -
> > > > > > > jmeter.protocol.jdbc.config.DataSourceElement:
> > > > > > > > Could not load driver: com.mysql.jdbc.Driver
> > > > > > > > java.lang.ClassNotFoundException : com/mysql/jdbc/Driver
> > > > > > > > at java.lang.Class.forName0(Native Method)
> > > > > > > > at java.lang.Class.forName(Class.java:219)
> > > > > > >
> > > > > > >
> > > > > > > The problem is just that JMeter cannot find the driver.
> > > > > > >
> > > > > > > I don't know why this should be.
> > > > > > >
> > > > > > > Have you checked to see if the class is actually in the jar?
> > > > > > >
> > > > > > > Which version of JMeter and Java are you using?
> > > > > > >
> > > > > > > What command are you using to start JMeter?
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
How to check ....am not getting how to check the jar file
am generally asking why we are copying that JDBC driver???
On 9/26/07, sebb <se...@gmail.com> wrote:
>
> On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > Hi sebb please clarify my doubts
> > 1)what is the use of copying the jar file to the bin ...
>
> Where did I write that?
>
> > 2)hear am not at all using any thing belongs to java ...am just trying
> to
> > access the data base...then why you are asking about java version
>
> Because older versions of Java don't work properly with JMeter.
>
> > if you feel these are silly questions ...please dont mind....am new to
> > jmeter and dont have much knowledge about java...so am asking
> >
> > On 9/26/07, sijay reddy <si...@gmail.com> wrote:
> > >
> > > java version is 1.4
>
> OK, assuming it is a Sun version.
>
> > > On 9/26/07, sebb <se...@gmail.com> wrote:
> > > >
> > > > Should be OK, given what you have told us.
> > > >
> > > > Which version of Java?
> > > >
> > > > Just had a thought - spaces are invisible in log files - check that
> you
> > > > don't have a trailing space in the driver class name field.
>
> Did you check for trailing spaces in the class name???
>
> > > >
> > > > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > >
> > > > > Have you checked to see if the class is actually in the jar?
> > > > > yes ...Driver class is present in the jar file
> > > > >
> > > > > Which version of JMeter and Java are you using?
> > > > > am using jmeter 2.3RC3 version ...hear am just trying to connect
> to
> > > > the
> > > > > database ...
> > > > > First of all i will explain how i created test plan...
> > > > > my testplan contains only one JDBC request which contining the
> > > > required
> > > > > query and
> > > > > one JDBC connection configuration which containg the details of
> > > > Database
> > > > > URL,JDBC driver class ,username and password
> > > > > is there any thing wrong in m testplan??????
> > > > >
> > > > > What command are you using to start JMeter?
> > > > > i fallowed two procedures to start jmeter
> > > > > 1)just by clicking the jmeter batch file which is located in bin
> > > > > 2)by using command prompt giving the command jmeter -H
> 192.168.1.101-P
> > > > > 8080
> > > > >
> > > > >
> > > > > whats the wrong in my test plan
> > > > >
> > > > >
> > > > > On 9/25/07, sebb < sebbaz@gmail.com> wrote:
> > > > > >
> > > > > > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > > > >
> > > > > > > Hi sebb hear am attaching the contents of the log
> file....please
> > > > once
> > > > > go
> > > > > > > through it and tell me what
> > > > > > > is missing..
> > > > > > > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine
> :
> > > > > Running
> > > > > > > the
> > > > > > > test!
> > > > > > >
> > > > > > > 2007/09/25 15:53:27 WARN -
> > > > > > jmeter.protocol.jdbc.config.DataSourceElement:
> > > > > > > Could not load driver: com.mysql.jdbc.Driver
> > > > > > > java.lang.ClassNotFoundException : com/mysql/jdbc/Driver
> > > > > > > at java.lang.Class.forName0(Native Method)
> > > > > > > at java.lang.Class.forName(Class.java:219)
> > > > > >
> > > > > >
> > > > > > The problem is just that JMeter cannot find the driver.
> > > > > >
> > > > > > I don't know why this should be.
> > > > > >
> > > > > > Have you checked to see if the class is actually in the jar?
> > > > > >
> > > > > > Which version of JMeter and Java are you using?
> > > > > >
> > > > > > What command are you using to start JMeter?
> > > > > >
> > > > >
> > > >
> > >
> > >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Re: Connecting to database by using JDBC request
Posted by sebb <se...@gmail.com>.
On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> Hi sebb please clarify my doubts
> 1)what is the use of copying the jar file to the bin ...
Where did I write that?
> 2)hear am not at all using any thing belongs to java ...am just trying to
> access the data base...then why you are asking about java version
Because older versions of Java don't work properly with JMeter.
> if you feel these are silly questions ...please dont mind....am new to
> jmeter and dont have much knowledge about java...so am asking
>
> On 9/26/07, sijay reddy <si...@gmail.com> wrote:
> >
> > java version is 1.4
OK, assuming it is a Sun version.
> > On 9/26/07, sebb <se...@gmail.com> wrote:
> > >
> > > Should be OK, given what you have told us.
> > >
> > > Which version of Java?
> > >
> > > Just had a thought - spaces are invisible in log files - check that you
> > > don't have a trailing space in the driver class name field.
Did you check for trailing spaces in the class name???
> > >
> > > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > >
> > > > Have you checked to see if the class is actually in the jar?
> > > > yes ...Driver class is present in the jar file
> > > >
> > > > Which version of JMeter and Java are you using?
> > > > am using jmeter 2.3RC3 version ...hear am just trying to connect to
> > > the
> > > > database ...
> > > > First of all i will explain how i created test plan...
> > > > my testplan contains only one JDBC request which contining the
> > > required
> > > > query and
> > > > one JDBC connection configuration which containg the details of
> > > Database
> > > > URL,JDBC driver class ,username and password
> > > > is there any thing wrong in m testplan??????
> > > >
> > > > What command are you using to start JMeter?
> > > > i fallowed two procedures to start jmeter
> > > > 1)just by clicking the jmeter batch file which is located in bin
> > > > 2)by using command prompt giving the command jmeter -H 192.168.1.101-P
> > > > 8080
> > > >
> > > >
> > > > whats the wrong in my test plan
> > > >
> > > >
> > > > On 9/25/07, sebb < sebbaz@gmail.com> wrote:
> > > > >
> > > > > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > > >
> > > > > > Hi sebb hear am attaching the contents of the log file....please
> > > once
> > > > go
> > > > > > through it and tell me what
> > > > > > is missing..
> > > > > > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine:
> > > > Running
> > > > > > the
> > > > > > test!
> > > > > >
> > > > > > 2007/09/25 15:53:27 WARN -
> > > > > jmeter.protocol.jdbc.config.DataSourceElement:
> > > > > > Could not load driver: com.mysql.jdbc.Driver
> > > > > > java.lang.ClassNotFoundException : com/mysql/jdbc/Driver
> > > > > > at java.lang.Class.forName0(Native Method)
> > > > > > at java.lang.Class.forName(Class.java:219)
> > > > >
> > > > >
> > > > > The problem is just that JMeter cannot find the driver.
> > > > >
> > > > > I don't know why this should be.
> > > > >
> > > > > Have you checked to see if the class is actually in the jar?
> > > > >
> > > > > Which version of JMeter and Java are you using?
> > > > >
> > > > > What command are you using to start JMeter?
> > > > >
> > > >
> > >
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
Hi sebb please clarify my doubts
1)what is the use of copying the jar file to the bin ...
2)hear am not at all using any thing belongs to java ...am just trying to
access the data base...then why you are asking about java version
if you feel these are silly questions ...please dont mind....am new to
jmeter and dont have much knowledge about java...so am asking
On 9/26/07, sijay reddy <si...@gmail.com> wrote:
>
> java version is 1.4
>
> On 9/26/07, sebb <se...@gmail.com> wrote:
> >
> > Should be OK, given what you have told us.
> >
> > Which version of Java?
> >
> > Just had a thought - spaces are invisible in log files - check that you
> > don't have a trailing space in the driver class name field.
> >
> >
> > On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> > >
> > > Have you checked to see if the class is actually in the jar?
> > > yes ...Driver class is present in the jar file
> > >
> > > Which version of JMeter and Java are you using?
> > > am using jmeter 2.3RC3 version ...hear am just trying to connect to
> > the
> > > database ...
> > > First of all i will explain how i created test plan...
> > > my testplan contains only one JDBC request which contining the
> > required
> > > query and
> > > one JDBC connection configuration which containg the details of
> > Database
> > > URL,JDBC driver class ,username and password
> > > is there any thing wrong in m testplan??????
> > >
> > > What command are you using to start JMeter?
> > > i fallowed two procedures to start jmeter
> > > 1)just by clicking the jmeter batch file which is located in bin
> > > 2)by using command prompt giving the command jmeter -H 192.168.1.101-P
> > > 8080
> > >
> > >
> > > whats the wrong in my test plan
> > >
> > >
> > > On 9/25/07, sebb < sebbaz@gmail.com> wrote:
> > > >
> > > > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > > >
> > > > > Hi sebb hear am attaching the contents of the log file....please
> > once
> > > go
> > > > > through it and tell me what
> > > > > is missing..
> > > > > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine:
> > > Running
> > > > > the
> > > > > test!
> > > > >
> > > > > 2007/09/25 15:53:27 WARN -
> > > > jmeter.protocol.jdbc.config.DataSourceElement:
> > > > > Could not load driver: com.mysql.jdbc.Driver
> > > > > java.lang.ClassNotFoundException : com/mysql/jdbc/Driver
> > > > > at java.lang.Class.forName0(Native Method)
> > > > > at java.lang.Class.forName(Class.java:219)
> > > >
> > > >
> > > > The problem is just that JMeter cannot find the driver.
> > > >
> > > > I don't know why this should be.
> > > >
> > > > Have you checked to see if the class is actually in the jar?
> > > >
> > > > Which version of JMeter and Java are you using?
> > > >
> > > > What command are you using to start JMeter?
> > > >
> > >
> >
>
>
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
java version is 1.4
On 9/26/07, sebb <se...@gmail.com> wrote:
>
> Should be OK, given what you have told us.
>
> Which version of Java?
>
> Just had a thought - spaces are invisible in log files - check that you
> don't have a trailing space in the driver class name field.
>
>
> On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
> >
> > Have you checked to see if the class is actually in the jar?
> > yes ...Driver class is present in the jar file
> >
> > Which version of JMeter and Java are you using?
> > am using jmeter 2.3RC3 version ...hear am just trying to connect to the
> > database ...
> > First of all i will explain how i created test plan...
> > my testplan contains only one JDBC request which contining the required
> > query and
> > one JDBC connection configuration which containg the details of Database
> > URL,JDBC driver class ,username and password
> > is there any thing wrong in m testplan??????
> >
> > What command are you using to start JMeter?
> > i fallowed two procedures to start jmeter
> > 1)just by clicking the jmeter batch file which is located in bin
> > 2)by using command prompt giving the command jmeter -H 192.168.1.101 -P
> > 8080
> >
> >
> > whats the wrong in my test plan
> >
> >
> > On 9/25/07, sebb <se...@gmail.com> wrote:
> > >
> > > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > >
> > > > Hi sebb hear am attaching the contents of the log file....please
> once
> > go
> > > > through it and tell me what
> > > > is missing..
> > > > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine:
> > Running
> > > > the
> > > > test!
> > > >
> > > > 2007/09/25 15:53:27 WARN -
> > > jmeter.protocol.jdbc.config.DataSourceElement:
> > > > Could not load driver: com.mysql.jdbc.Driver
> > > > java.lang.ClassNotFoundException: com/mysql/jdbc/Driver
> > > > at java.lang.Class.forName0(Native Method)
> > > > at java.lang.Class.forName(Class.java:219)
> > >
> > >
> > > The problem is just that JMeter cannot find the driver.
> > >
> > > I don't know why this should be.
> > >
> > > Have you checked to see if the class is actually in the jar?
> > >
> > > Which version of JMeter and Java are you using?
> > >
> > > What command are you using to start JMeter?
> > >
> >
>
Re: Connecting to database by using JDBC request
Posted by sebb <se...@gmail.com>.
Should be OK, given what you have told us.
Which version of Java?
Just had a thought - spaces are invisible in log files - check that you
don't have a trailing space in the driver class name field.
On 26/09/2007, sijay reddy <si...@gmail.com> wrote:
>
> Have you checked to see if the class is actually in the jar?
> yes ...Driver class is present in the jar file
>
> Which version of JMeter and Java are you using?
> am using jmeter 2.3RC3 version ...hear am just trying to connect to the
> database ...
> First of all i will explain how i created test plan...
> my testplan contains only one JDBC request which contining the required
> query and
> one JDBC connection configuration which containg the details of Database
> URL,JDBC driver class ,username and password
> is there any thing wrong in m testplan??????
>
> What command are you using to start JMeter?
> i fallowed two procedures to start jmeter
> 1)just by clicking the jmeter batch file which is located in bin
> 2)by using command prompt giving the command jmeter -H 192.168.1.101 -P
> 8080
>
>
> whats the wrong in my test plan
>
>
> On 9/25/07, sebb <se...@gmail.com> wrote:
> >
> > On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> > >
> > > Hi sebb hear am attaching the contents of the log file....please once
> go
> > > through it and tell me what
> > > is missing..
> > > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine:
> Running
> > > the
> > > test!
> > >
> > > 2007/09/25 15:53:27 WARN -
> > jmeter.protocol.jdbc.config.DataSourceElement:
> > > Could not load driver: com.mysql.jdbc.Driver
> > > java.lang.ClassNotFoundException: com/mysql/jdbc/Driver
> > > at java.lang.Class.forName0(Native Method)
> > > at java.lang.Class.forName(Class.java:219)
> >
> >
> > The problem is just that JMeter cannot find the driver.
> >
> > I don't know why this should be.
> >
> > Have you checked to see if the class is actually in the jar?
> >
> > Which version of JMeter and Java are you using?
> >
> > What command are you using to start JMeter?
> >
>
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
Have you checked to see if the class is actually in the jar?
yes ...Driver class is present in the jar file
Which version of JMeter and Java are you using?
am using jmeter 2.3RC3 version ...hear am just trying to connect to the
database ...
First of all i will explain how i created test plan...
my testplan contains only one JDBC request which contining the required
query and
one JDBC connection configuration which containg the details of Database
URL,JDBC driver class ,username and password
is there any thing wrong in m testplan??????
What command are you using to start JMeter?
i fallowed two procedures to start jmeter
1)just by clicking the jmeter batch file which is located in bin
2)by using command prompt giving the command jmeter -H 192.168.1.101 -P 8080
whats the wrong in my test plan
On 9/25/07, sebb <se...@gmail.com> wrote:
>
> On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> >
> > Hi sebb hear am attaching the contents of the log file....please once go
> > through it and tell me what
> > is missing..
> > 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine: Running
> > the
> > test!
> >
> > 2007/09/25 15:53:27 WARN -
> jmeter.protocol.jdbc.config.DataSourceElement:
> > Could not load driver: com.mysql.jdbc.Driver
> > java.lang.ClassNotFoundException: com/mysql/jdbc/Driver
> > at java.lang.Class.forName0(Native Method)
> > at java.lang.Class.forName(Class.java:219)
>
>
> The problem is just that JMeter cannot find the driver.
>
> I don't know why this should be.
>
> Have you checked to see if the class is actually in the jar?
>
> Which version of JMeter and Java are you using?
>
> What command are you using to start JMeter?
>
Re: Connecting to database by using JDBC request
Posted by sebb <se...@gmail.com>.
On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
>
> Hi sebb hear am attaching the contents of the log file....please once go
> through it and tell me what
> is missing..
> 2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine: Running
> the
> test!
>
> 2007/09/25 15:53:27 WARN - jmeter.protocol.jdbc.config.DataSourceElement:
> Could not load driver: com.mysql.jdbc.Driver
> java.lang.ClassNotFoundException: com/mysql/jdbc/Driver
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:219)
The problem is just that JMeter cannot find the driver.
I don't know why this should be.
Have you checked to see if the class is actually in the jar?
Which version of JMeter and Java are you using?
What command are you using to start JMeter?
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
Hi sebb hear am attaching the contents of the log file....please once go
through it and tell me what
is missing..
2007/09/25 15:53:27 INFO - jmeter.engine.StandardJMeterEngine: Running the
test!
2007/09/25 15:53:27 WARN - jmeter.protocol.jdbc.config.DataSourceElement:
Could not load driver: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com/mysql/jdbc/Driver
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:219)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.configure
(ResourceLimitingJdbcDataSource.java:297)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.initPool(
DataSourceElement.java:204)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.testStarted(
DataSourceElement.java:106)
at org.apache.jmeter.engine.StandardJMeterEngine.notifyTestListenersOfStart
(StandardJMeterEngine.java:209)
at org.apache.jmeter.engine.StandardJMeterEngine.run(
StandardJMeterEngine.java:336)
at java.lang.Thread.run(Thread.java:534)
2007/09/25 15:53:27 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(true,local)
2007/09/25 15:53:28 INFO - jmeter.engine.StandardJMeterEngine: Starting 1
threads for group Thread Group. Ramp up = 0.
2007/09/25 15:53:28 INFO - jmeter.engine.StandardJMeterEngine: Continue on
error
2007/09/25 15:53:28 INFO - jmeter.threads.JMeterThread: Thread Thread Group
1-1 started
2007/09/25 15:53:28 WARN - jmeter.protocol.jdbc.config.DataSourceElement:
Could not return Connection java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance
(JdbcConnectionFactory.java:185)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(
ResourceLimitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(
ValidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable
(ResourceLimitingJdbcConnectionPool.java:123)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(
ResourceLimitingPool.java:402)
at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(
ValidatedResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection
(ResourceLimitingJdbcDataSource.java:222)
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(
JDBCSampler.java:150)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:298)
at java.lang.Thread.run(Thread.java:534)
2007/09/25 15:53:28 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error
in JDBC sampling java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance
(JdbcConnectionFactory.java:185)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(
ResourceLimitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(
ValidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable
(ResourceLimitingJdbcConnectionPool.java:123)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(
ResourceLimitingPool.java:402)
at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(
ValidatedResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection
(ResourceLimitingJdbcDataSource.java:222)
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(
JDBCSampler.java:150)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:298)
at java.lang.Thread.run(Thread.java:534)
2007/09/25 15:53:28 INFO - jmeter.threads.JMeterThread: Thread Thread Group
1-1 is done
2007/09/25 15:53:28 INFO - jmeter.engine.StandardJMeterEngine: Ending
thread Thread Group 1-1
2007/09/25 15:53:28 INFO - jmeter.engine.StandardJMeterEngine: Stopping
test
2007/09/25 15:53:28 INFO - jmeter.engine.StandardJMeterEngine: Notifying
test listeners of end of test
2007/09/25 15:53:28 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(false,local)
2007/09/25 15:53:28 INFO - jmeter.engine.StandardJMeterEngine: Test has
ended
On 9/25/07, sebb <se...@gmail.com> wrote:
>
> Choose whatever jar the provider says is suitable.
>
> On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
> >
> > hi sebb thanks for your response...on what basis i need to choose the
> jar
> > file....which jar file is suitable?
> >
> > On 9/24/07, sebb <se...@gmail.com> wrote:
> > >
> > > On 24/09/2007, sijay reddy <si...@gmail.com> wrote:
> > > >
> > > > Hi i have a doubt regarding how to connect to database by using
> > > jmeter...
> > > > i have prepared the test plan as specified in the usermanual...i
> > > > dounloaded
> > > > the "mysql-connector-java-bin.jar " file and copied that jar file to
> > lib
> > > > directory
> > > > hear am listing the details which i had given in Database Connection
> > >
> > >
> > > OK
> > >
> > > Configuration
> > > > Database URL: jdbc:mysql://192.168.1.101:3306/ams_newaug9
> > > > JDBC Driver Class:com.mysql.jdbc.Driver
> > >
> > >
> > > OK
> > >
> > > Username: xxxx
> > > > Password:xxxx
> > > > but while running the testplan am getting the Response message:
> > > > java.sql.SQLException: No suitable driver
> > >
> > >
> > > That means Java could not find the class "com.mysql.jdbc.Driver".
> > >
> > > This should not happen if the correct jar file is in the JMeter lib
> > > directory.
> > > What you have described should have worked.
> > >
> > > Check for any other messages in jmeter.log file in case some other
> > problem
> > > occurred.
> > >
> > > Also check that the class really is in the jar.
> > >
> > >
> > > > am not getting where i committed mistake...please let me know
> > > >
> > > Remember that the same pool name needs to be used in the Config and
> > > Request
> > > test elements.
> > > However this would give a different error message.
> > >
> >
>
Re: Connecting to database by using JDBC request
Posted by sebb <se...@gmail.com>.
Choose whatever jar the provider says is suitable.
On 25/09/2007, sijay reddy <si...@gmail.com> wrote:
>
> hi sebb thanks for your response...on what basis i need to choose the jar
> file....which jar file is suitable?
>
> On 9/24/07, sebb <se...@gmail.com> wrote:
> >
> > On 24/09/2007, sijay reddy <si...@gmail.com> wrote:
> > >
> > > Hi i have a doubt regarding how to connect to database by using
> > jmeter...
> > > i have prepared the test plan as specified in the usermanual...i
> > > dounloaded
> > > the "mysql-connector-java-bin.jar " file and copied that jar file to
> lib
> > > directory
> > > hear am listing the details which i had given in Database Connection
> >
> >
> > OK
> >
> > Configuration
> > > Database URL: jdbc:mysql://192.168.1.101:3306/ams_newaug9
> > > JDBC Driver Class:com.mysql.jdbc.Driver
> >
> >
> > OK
> >
> > Username: xxxx
> > > Password:xxxx
> > > but while running the testplan am getting the Response message:
> > > java.sql.SQLException: No suitable driver
> >
> >
> > That means Java could not find the class "com.mysql.jdbc.Driver".
> >
> > This should not happen if the correct jar file is in the JMeter lib
> > directory.
> > What you have described should have worked.
> >
> > Check for any other messages in jmeter.log file in case some other
> problem
> > occurred.
> >
> > Also check that the class really is in the jar.
> >
> >
> > > am not getting where i committed mistake...please let me know
> > >
> > Remember that the same pool name needs to be used in the Config and
> > Request
> > test elements.
> > However this would give a different error message.
> >
>
Re: Connecting to database by using JDBC request
Posted by sijay reddy <si...@gmail.com>.
hi sebb thanks for your response...on what basis i need to choose the jar
file....which jar file is suitable?
On 9/24/07, sebb <se...@gmail.com> wrote:
>
> On 24/09/2007, sijay reddy <si...@gmail.com> wrote:
> >
> > Hi i have a doubt regarding how to connect to database by using
> jmeter...
> > i have prepared the test plan as specified in the usermanual...i
> > dounloaded
> > the "mysql-connector-java-bin.jar " file and copied that jar file to lib
> > directory
> > hear am listing the details which i had given in Database Connection
>
>
> OK
>
> Configuration
> > Database URL: jdbc:mysql://192.168.1.101:3306/ams_newaug9
> > JDBC Driver Class:com.mysql.jdbc.Driver
>
>
> OK
>
> Username: xxxx
> > Password:xxxx
> > but while running the testplan am getting the Response message:
> > java.sql.SQLException: No suitable driver
>
>
> That means Java could not find the class "com.mysql.jdbc.Driver".
>
> This should not happen if the correct jar file is in the JMeter lib
> directory.
> What you have described should have worked.
>
> Check for any other messages in jmeter.log file in case some other problem
> occurred.
>
> Also check that the class really is in the jar.
>
>
> > am not getting where i committed mistake...please let me know
> >
> Remember that the same pool name needs to be used in the Config and
> Request
> test elements.
> However this would give a different error message.
>
Re: Connecting to database by using JDBC request
Posted by sebb <se...@gmail.com>.
On 24/09/2007, sijay reddy <si...@gmail.com> wrote:
>
> Hi i have a doubt regarding how to connect to database by using jmeter...
> i have prepared the test plan as specified in the usermanual...i
> dounloaded
> the "mysql-connector-java-bin.jar " file and copied that jar file to lib
> directory
> hear am listing the details which i had given in Database Connection
OK
Configuration
> Database URL: jdbc:mysql://192.168.1.101:3306/ams_newaug9
> JDBC Driver Class:com.mysql.jdbc.Driver
OK
Username: xxxx
> Password:xxxx
> but while running the testplan am getting the Response message:
> java.sql.SQLException: No suitable driver
That means Java could not find the class "com.mysql.jdbc.Driver".
This should not happen if the correct jar file is in the JMeter lib
directory.
What you have described should have worked.
Check for any other messages in jmeter.log file in case some other problem
occurred.
Also check that the class really is in the jar.
> am not getting where i committed mistake...please let me know
>
Remember that the same pool name needs to be used in the Config and Request
test elements.
However this would give a different error message.