I've just found the following Oracle FAQ which might be helpful: http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#05_03
On 28/01/2009, sebb <seb...@gmail.com> wrote: > On 28/01/2009, Shelli D. Orton <shelli.or...@wmode.com> wrote: > > Hi All, > > > > I found the solution to my problem. The URL connect string has to be in a > > different format. Either of these worked for me: > > > > > > jdbc:oracle:thin:@//<server>:<port>/<service name> > > > > > Which agrees with the sample in the table at the end of the following section: > > > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Connection_Configuration > > I guess it might be worth adding the following as an alternative: > > > > > > jdbc:oracle:thin:@(DESCRIPTION= > > (ADDRESS=(PROTOCOL=TCP)(HOST=<server>)(PORT=<port>)) > > (CONNECT_DATA=(SERVICE_NAME=<service name>))) > > > > > > Shelli > > > > > > -----Original Message----- > > From: da...@davidwbrown.name [mailto:da...@davidwbrown.name] > > Sent: January 28, 2009 9:53 AM > > To: JMeter Users List > > Subject: Re: Oracle JDBC Connection Problem > > > > Hello Shelli, what is the contents of your tns.ora file? David. > > > > Shelli D. Orton wrote .. > > > Hello, > > > > > > I'm using JMeter 2.3.2 and the Oracle JDBC ojdbc14_10.2.0.4.0.jar file. > > I'm trying > > > to connect to a database that is using a service name, not a SID. I've > > set up > > > my JDBC Connection Configuration/Database URL to be in the format: > > > > > > jdbc:oracle:thin:@<server>:<port>:<service name> > > > > > > I realize this is not a JMeter issue per se, but am hoping somebody else > > has had > > > experience with this issue and can tell me how I can connect to the > > database. > > > > > > Thanks for all help! > > > > > > Shelli > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org > > > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org > > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
