Hi Sebb, Thanks for the reply. It is running now. Actually, I was trying to create the connection pool from the stand-alone program. And then use it in JMeter. Because I didn't realise that all that is done automatically through JDBC Connection Configuration. As an open source tool, JMeter actually does a lot of stuff, which is not quite evident from the documentation. Regards, Kakoli
-----Original Message----- From: sebb [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 5:03 PM To: JMeter Users List Subject: Re: Error in running JDBC Request You need to create the pool using the JDBC Connection config, and use the same pool name in the JDBC Sampler. See: http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request You can create a pool with 1 connection, and use 1 thread, and that might work with Access. See also: http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html JMeter works fine with MySQL; others have used it with Oracle etc. S. On 09/08/06, Sen, Kakoli <[EMAIL PROTECTED]> wrote: > Hi, > The Java standalone program connects through standalone connection, not > pooled one. > And in JMeter, isn't there a way to run JDBC request through standalone > connection? If not, then I have to create a connection pool? But I don't know > how to do that with MSAcces-Atinav. > My basic objective is to try running successfully JDBC request through > JMeter as part of JMeter evaluation. I tried with MSAccess since that was the > db available on Windows. And Atinav was the only driver I could get hold of > from internet for eval. purpose. > Anyone has tried it on any non-commercial db like MSAccess/HSQL/MySQL? > > Regards, > Kakoli > > -----Original Message----- > From: sebb [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 08, 2006 6:22 PM > To: JMeter Users List > Subject: Re: Error in running JDBC Request > > > Make sure you create the pool using the same name as you use for the > JDBC sampler. > > > > On 08/08/06, Sen, Kakoli <[EMAIL PROTECTED]> wrote: > > Hi all, > > I am running JDBC request with JMeter 2.2. Database is MSAccess2000. > > And driver used is Atinav aveConnect 2.0 JDBC Driver which is type3 and > > supports JDBC2.0 API(including connection pooling). But on running, the > > test plan error comes : > > 2006/08/08 16:16:17 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error > > in JDBC sampling java.sql.SQLException: No pool created > > at > > org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:86) > > at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247) > > at java.lang.Thread.run(Thread.java:595) > > I am able to connect to the db via this driver through JDBC > > API(java.sql.Connection) in standalone Java program. > > Any idea anyone as to what the problem is? > > Thanks & Regards, > > Kakoli > > > > > > --------------------------------------------------------------------- > > 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] > > --------------------------------------------------------------------- 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]
