I think it can't find the driver. What is the name of the jar which should contain the oracle driver?
BTW: my informix connection is working fine. Do I need something extra for Oracle? Like [EMAIL PROTECTED] mentioned: You have got the Oracle client loaded haven't you??? No, I didn't load any extra. Is that needed? What do you mean? Thanks, Sander -----Original Message----- From: Michael Stover [mailto:[EMAIL PROTECTED] Sent: maandag 25 april 2005 16:03 To: JMeter Users List Subject: RE: Oracle connection? This can mean a number of things. A) The jar with the driver isn't appearing in JMeter's classpath. The jar file should be in JMeter's /lib directory to get picked up. And I don't think JMeter picks up *.zip files. B) Your connection string is wrong (though it looks well-formed to me) - JMeter can't find a suitable driver for a db it can't find, and often you get this same error in that event. C) There's some network thing blocking your computer's access to the db server. -Mike On Mon, 2005-04-25 at 15:59 +0200, Sander Stevens wrote: > Indeed there was a message in the log: > > 2005/04/25 15:55:57 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error > in JDBC sampling java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getConnection(Unknown Source) > at java.sql.DriverManager.getConnection(Unknown Source) > etc. > > So obviously I am having problems with the driver. Maybe it can't find the > driver? Or the driver of the april 4th version is maybe not correct? > > Sander > > > -----Original Message----- > From: Michael Stover [mailto:[EMAIL PROTECTED] > Sent: maandag 25 april 2005 15:31 > To: [email protected] > Subject: Re: Oracle connection? > > "Not working" can mean a lot. Do you see errors in jmeter.log? What > does happen, exactly? Can you create the simplest test plan possible to > sample the oracle db (ie, one "select 1" sql query)? > > I use the same driver here where I work and it works ok. > > -Mike > > On Mon, 2005-04-25 at 09:43 +0200, Sander Stevens wrote: > > Hi, > > > > I am using JMeter internal build 20050904. > > Trying to create an Oracle connection, but my testplan is not working > > anymore with this connection active. Disabling the oracle connection will > > make sure that the script is working again. So, something is not correct. > > Hope someone can help me. > > > > I add a JDBC Connection configuration to my testplan and enter the > > following configuration: > > > > Database URL: jdbc:oracle:thin:@dev12-adm.wxs.nl:1521:PINTST > > JDBC Driver class: oracle.jdbc.driver.OracleDriver > > Username: xxx > > Password: xxx > > > > (and username and password are of course scrambledâ â) > > > > Any ideas? Maybe the driver is not correct? > > > > Thanks, > > Sander Stevens > > > > --------------------------------------------------------------------- > 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]
