jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dominik Karall" <dominik.kar...@gmail.com>
Subject Re: Oracle JDBC Connection
Date Fri, 13 Jul 2007 14:33:53 GMT
ah, ok, thank you for the information Allan!
I will check those parameters on monday at work.

so long, thank you for your help!

cheers,
dominik


2007/7/13, allan.hagan@bt.com <allan.hagan@bt.com>:
> Dominik,
>
> It's basically what it says: the oracle Listener on your machine cannot
> find a database dbname. Have you created database dbname successfully?
> Can you run the same query from sqlplus and get a successful answer?
> Have you got an entry for dbname in your local TNSNAMES.ORA file
> /ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA?
>
> This is nothing to do with Jmeter it's an Oracle communications issue.
>
> Regards,
>
> Allan
>
> -----Original Message-----
> From: Dominik Karall [mailto:dominik.karall@gmail.com]
> Sent: 13 July 2007 15:05
> To: jmeter-user@jakarta.apache.org
> Subject: Oracle JDBC Connection
>
> 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
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
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