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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [email protected] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
