My query is pretty simple (to start with): SELECT * FROM ipmgr.client_ip where ip_address = '80.60.92.102';
-----Original Message----- From: Michael Stover [mailto:[EMAIL PROTECTED] Sent: donderdag 28 april 2005 15:25 To: [email protected] Subject: RE: Oracle connection? I'd have to see your query - it appears the query has an invalid character in it - like maybe a non-expanded JMeter variable? -Mike On Thu, 2005-04-28 at 09:58 +0200, Sander Stevens wrote: > Hi Mike, > > I copied the zip file like you said and that solves indeed the message that > it can't find the driver. But I get the following message. Any ideas? > My configuration: > > > > Database URL: jdbc:oracle:thin:@dev12-adm.wxs.nl:1521:PINTST > > > > JDBC Driver class: oracle.jdbc.driver.OracleDriver > > > > Username: xxx > > > > Password: xxx > > 2005/04/28 09:55:21 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error > in JDBC sampling java.sql.SQLException: ORA-00911: invalid character > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) > at > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) > at > oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) > at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:854) > at > org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:82) > at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:255) > at java.lang.Thread.run(Unknown Source) > > > > -----Original Message----- > From: Michael Stover [mailto:[EMAIL PROTECTED] > Sent: dinsdag 26 april 2005 15:27 > To: [email protected] > Subject: RE: Oracle connection? > > For me, my oracle jar file is called "classes12.zip" and I have to > rename it to "classes12.jar" and copy it to jmeter's /lib directory. > > -Mike > > On Tue, 2005-04-26 at 08:11 +0200, Sander Stevens wrote: > > 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] > > > > --------------------------------------------------------------------- > 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]
