RE: Oracle and JMeter configuration

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Wed, 03 Dec 2003 20:54:26 -0800
Message-ID: <F001.005D8B48.20031203205426@fatcity.com>

What's your CLASSPATH? It seems that the classes12.zip isn't on your CLASSPATH.

-----Original Message-----

From:	Louis Avrami [mailto:avramil_at_concentric.net]
Sent:	Wed 12/3/2003 7:44 PM
To:	Multiple recipients of list ORACLE-L
Cc:	
Subject:	Oracle and JMeter configuration

Hello all,

I'm trying to set up JMeter version 1.9.1,

http://jakarta.apache.org/jmeter/index.html

for some testing on an Oracle 8.1.7.4 database on Solaris 2.8. We're running JDK 1.3, which according to the JMeter website should work with JMeter 1.9.

I've unpacked JMeter and copied the Oracle JDBC driver files classes12.zip and nls_charset12.zip into JMeter's lib directory. However, when I try to run a test case the connection fails with the log error of

jmeter.protocol.jdbc: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

The JMeter JDBC URL settings that I am using are:

jdbc:oracle:thin:@servername:1521:ORACLE_SID (I've also tried using the IP address)

The JMeter Driver Class setting is:

oracle.jdbc.driver.OracleDriver

Has anyone out there set up JMeter to run against an Oracle database? If so, could you share your setup with me? From what I've read in the JMeter archives, it has been done, but it seems that no one has detailed exactly what needs to be done.

Thanks,
Lou Avrami

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Louis Avrami
INET: avramil_at_concentric.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Richard Ji
INET: Richard.Ji_at_ztango.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------