jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dominik Karall" <dominik.kar...@gmail.com>
Subject Oracle JDBC Connection
Date Fri, 13 Jul 2007 14:04:31 GMT
Hi,
I would like to use JMeter in our company for webinterface testing in
connection with database. At the moment I try to get an small proof of
concept for database testing, but it doesn't work. My steps I have
done so far:
1) created an oracle jdbc connection
 - jdbc:oracle:thin:@localhost:1521:dbname
 - oracle.jdbc.driver.OracleDriver
2) created select statement with a simple
 SELECT * FROM TABLENAME
3) added simple data writer object for output

When I run the test, I get following error in the output file:
<sample t="0" lt="0" ts="1184316353328" s="false" lb="SELECT from
ServiceNo" rc="" rm="java.sql.SQLException: ORA-00911: invalid
character
" tn="Thread Group 1-1" dt="text" by="0"/>

Changing the connection url to jdbc:oracle:thin:@//localhost:1521/dbname i get:
<sample t="0" lt="0" ts="1184315626578" s="false" lb="SELECT from
ServiceNo" rc="" rm="java.sql.SQLException: Listener refused the
connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
//localhost:1521/dbname
" tn="Thread Group 1-1" dt="text" by="0"/>

Could you give me some hints on solving this problem please?

Thanks in advance!

cheers,
dominik

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message