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 Mon, 16 Jul 2007 13:12:10 GMT
Hi,
I'm sorry, but I didn't get it working. Following settings:
JMeter:
jdbc:oracle:thin:icr/xxx@//localhost:1521/appl
oracle.jdbc.driver.OracleDriver
icr
xxx

DB (tnsnames.ora):
APPL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = infitel)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = appl.yyy.zz)
    )
  )

I can connect to the database with SQL Developer (oracle) using
//localhost:1521/appl as connection string. But with JMeter I still
get:
<sample t="0" lt="0" ts="1184591110765" s="false" lb="JDBC Request"
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/appl
" tn="Thread Gruppe 1-1" dt="text" by="0"/>

Thanks for any hints!

cheers,
dominik


2007/7/13, Dominik Karall <dominik.karall@gmail.com>:
> 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