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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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:[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 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] > > > > > --------------------------------- > New Yahoo! Messenger with Voice. Call regular phones from your PC for low, > low rates. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
