You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Dominik Karall <do...@gmail.com> on 2007/07/13 16:04:31 UTC
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
Re: Oracle JDBC Connection
Posted by Dominik Karall <do...@gmail.com>.
thank you keerat!!
it works now :)
cheers,
dominik
2007/7/22, keerat <ke...@gmail.com>:
> Try and assemble your JDBC URL to the database in this format:
>
> jdbc:oracle:thin:@server:port:instance
>
> In your case, this might be:
> jdbc:oracle:thin:@localhost:1521:appl
>
> Note the colon separator instead of the normal slash.
>
> On 7/16/07, Dominik Karall <do...@gmail.com> wrote:
> >
> > 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 <do...@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 <al...@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
> >
> >
>
>
> --
> http://recursor.blogspot.com
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Oracle JDBC Connection
Posted by keerat <ke...@gmail.com>.
Try and assemble your JDBC URL to the database in this format:
jdbc:oracle:thin:@server:port:instance
In your case, this might be:
jdbc:oracle:thin:@localhost:1521:appl
Note the colon separator instead of the normal slash.
On 7/16/07, Dominik Karall <do...@gmail.com> wrote:
>
> 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 <do...@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 <al...@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
>
>
--
http://recursor.blogspot.com
Re: Oracle JDBC Connection
Posted by Dominik Karall <do...@gmail.com>.
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 <do...@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 <al...@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
Re: Oracle JDBC Connection
Posted by Dominik Karall <do...@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 <al...@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
RE: Oracle JDBC Connection
Posted by al...@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