You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Mitch White <MW...@atonesoftware.com> on 2006/03/24 20:43:21 UTC
RE: JDBC Connection Configuration
Hi,
I'm getting the following response from a JDBC sample:
Load time: 0
HTTP response code: null
HTTP response message: java.sql.SQLException: No suitable driver
I am told we use the following executable jar, and have copied it to
jmeter\lib: mysql-connector-java-bin.jar
Also, I have entered my JDBC driver class as follows:
com.mysql.jdbc.Driver
I use eclipse to open this file, but it is unreadable, so I can't check
for any classes. How do I open a jar file to read it???
One more question, what is the "variable name bound to pool" used for?
Much Thanks,
Mitch
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Monday, February 20, 2006 7:23 AM
To: JMeter Users List
Subject: Re: JDBC Connection Configuration
Have a look at the jar files, and see if the class
com.microsoft.jdbc.sqlserver.SQLServerDriver
is in any of them.
JMeter should find this if it is in a jar file in the lib directory.
JMeter does *not* add zip files to the classpath, but this should not
be the problem here.
S.
On 20/02/06, Yiping Yang <Yi...@icims.com> wrote:
> Hi,
>
> I just found after I run the setup.exe of JDBC driver I downloaded
from
> Microsoft, I find the three jar files in the \Microsoft SQL Server
2000
> Driver for JDBC\lib dir. I copied them to \jakarta-jmeter-2.1.1\lib
> And in Database Connection Configuration I wrote like this:
>
> Database URL: jdbc:ruffo\sql2k.test_yiping
> JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver
> Username: ***
> Password: ***
>
> But after I ran the script, I got this error.
> " HTTP response message: java.sql.SQLException: No suitable driver"
> Is my Database URL and JDBC Driver class set correctly?
>
> Thanks,
> Yiping
>
>
>
> -----Original Message-----
> From: Yiping Yang
> Sent: Monday, February 20, 2006 9:41 AM
> To: jmeter-user@jakarta.apache.org
> Subject: JDBC Connection Configuration
>
> Hi all,
>
>
>
> I'm trying to create a database connection pool using "JDBC Connection
> Configuration".
>
> Our database is SQL server 2000.
>
> I went to Microsoft website to find JDBC drivers for SQL server. They
only
> have .exe and .tar format files.
>
> How can I use them and put it into Jmeter /lib dir? Can I find a jar
file of
> the driver? Is it possible to let jmeter connect to SQL server?
>
>
>
> Thanks,
>
> yiping
>
>
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Connection Configuration
Posted by sebb <se...@gmail.com>.
You can also use a Zip program such as WinZip to see the contents of jar files.
The "variable name bound to pool" is used to tie the JDBC Config and
JDBC Sampler test elements together.
You need to create the pool with the JDBC Config element, and use it
with the JDBC Sampler.
It appears that the message "no suitable driver" can mean either that
the driver class really was not found, or that there was some problem
with the driver parameters.
S.
On 24/03/06, Vikrant Sharma <xb...@yahoo.com> wrote:
> Hi Mitch,
>
> You can use the jar command to see the contents of the jar file.
> run - $JAVA_HOME/bin/jar -tvf mysql-connector-java-bin.jar
> to see the contents(all files) of mysql-connector-java-bin.jar file.
>
> Not sure about your other questions :(
>
> cheers!!
> Vikrant
>
>
> Mitch White <MW...@atonesoftware.com> wrote: Hi,
> I'm getting the following response from a JDBC sample:
> Load time: 0
> HTTP response code: null
> HTTP response message: java.sql.SQLException: No suitable driver
>
> I am told we use the following executable jar, and have copied it to
> jmeter\lib: mysql-connector-java-bin.jar
> Also, I have entered my JDBC driver class as follows:
> com.mysql.jdbc.Driver
>
> I use eclipse to open this file, but it is unreadable, so I can't check
> for any classes. How do I open a jar file to read it???
> One more question, what is the "variable name bound to pool" used for?
>
> Much Thanks,
> Mitch
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Monday, February 20, 2006 7:23 AM
> To: JMeter Users List
> Subject: Re: JDBC Connection Configuration
>
> Have a look at the jar files, and see if the class
>
> com.microsoft.jdbc.sqlserver.SQLServerDriver
>
> is in any of them.
>
> JMeter should find this if it is in a jar file in the lib directory.
>
> JMeter does *not* add zip files to the classpath, but this should not
> be the problem here.
>
>
> S.
> On 20/02/06, Yiping Yang wrote:
> > Hi,
> >
> > I just found after I run the setup.exe of JDBC driver I downloaded
> from
> > Microsoft, I find the three jar files in the \Microsoft SQL Server
> 2000
> > Driver for JDBC\lib dir. I copied them to \jakarta-jmeter-2.1.1\lib
> > And in Database Connection Configuration I wrote like this:
> >
> > Database URL: jdbc:ruffo\sql2k.test_yiping
> > JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver
> > Username: ***
> > Password: ***
> >
> > But after I ran the script, I got this error.
> > " HTTP response message: java.sql.SQLException: No suitable driver"
> > Is my Database URL and JDBC Driver class set correctly?
> >
> > Thanks,
> > Yiping
> >
> >
> >
> > -----Original Message-----
> > From: Yiping Yang
> > Sent: Monday, February 20, 2006 9:41 AM
> > To: jmeter-user@jakarta.apache.org
> > Subject: JDBC Connection Configuration
> >
> > Hi all,
> >
> >
> >
> > I'm trying to create a database connection pool using "JDBC Connection
> > Configuration".
> >
> > Our database is SQL server 2000.
> >
> > I went to Microsoft website to find JDBC drivers for SQL server. They
> only
> > have .exe and .tar format files.
> >
> > How can I use them and put it into Jmeter /lib dir? Can I find a jar
> file of
> > the driver? Is it possible to let jmeter connect to SQL server?
> >
> >
> >
> > Thanks,
> >
> > yiping
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
>
> ---------------------------------
> New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: JDBC Connection Configuration
Posted by Vikrant Sharma <xb...@yahoo.com>.
Hi Mitch,
You can use the jar command to see the contents of the jar file.
run - $JAVA_HOME/bin/jar -tvf mysql-connector-java-bin.jar
to see the contents(all files) of mysql-connector-java-bin.jar file.
Not sure about your other questions :(
cheers!!
Vikrant
Mitch White <MW...@atonesoftware.com> wrote: Hi,
I'm getting the following response from a JDBC sample:
Load time: 0
HTTP response code: null
HTTP response message: java.sql.SQLException: No suitable driver
I am told we use the following executable jar, and have copied it to
jmeter\lib: mysql-connector-java-bin.jar
Also, I have entered my JDBC driver class as follows:
com.mysql.jdbc.Driver
I use eclipse to open this file, but it is unreadable, so I can't check
for any classes. How do I open a jar file to read it???
One more question, what is the "variable name bound to pool" used for?
Much Thanks,
Mitch
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Monday, February 20, 2006 7:23 AM
To: JMeter Users List
Subject: Re: JDBC Connection Configuration
Have a look at the jar files, and see if the class
com.microsoft.jdbc.sqlserver.SQLServerDriver
is in any of them.
JMeter should find this if it is in a jar file in the lib directory.
JMeter does *not* add zip files to the classpath, but this should not
be the problem here.
S.
On 20/02/06, Yiping Yang wrote:
> Hi,
>
> I just found after I run the setup.exe of JDBC driver I downloaded
from
> Microsoft, I find the three jar files in the \Microsoft SQL Server
2000
> Driver for JDBC\lib dir. I copied them to \jakarta-jmeter-2.1.1\lib
> And in Database Connection Configuration I wrote like this:
>
> Database URL: jdbc:ruffo\sql2k.test_yiping
> JDBC Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver
> Username: ***
> Password: ***
>
> But after I ran the script, I got this error.
> " HTTP response message: java.sql.SQLException: No suitable driver"
> Is my Database URL and JDBC Driver class set correctly?
>
> Thanks,
> Yiping
>
>
>
> -----Original Message-----
> From: Yiping Yang
> Sent: Monday, February 20, 2006 9:41 AM
> To: jmeter-user@jakarta.apache.org
> Subject: JDBC Connection Configuration
>
> Hi all,
>
>
>
> I'm trying to create a database connection pool using "JDBC Connection
> Configuration".
>
> Our database is SQL server 2000.
>
> I went to Microsoft website to find JDBC drivers for SQL server. They
only
> have .exe and .tar format files.
>
> How can I use them and put it into Jmeter /lib dir? Can I find a jar
file of
> the driver? Is it possible to let jmeter connect to SQL server?
>
>
>
> Thanks,
>
> yiping
>
>
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates.