Re: Oracle JDBC Connection Problem
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 wrote: > On 28/01/2009, Shelli D. Orton 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:@//:/ > > > > > 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=)(PORT=)) > > (CONNECT_DATA=(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:@:: > > > > > > 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
Re: Oracle JDBC Connection Problem
On 28/01/2009, Shelli D. Orton 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:@//:/ > 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=)(PORT=)) > (CONNECT_DATA=(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:@:: > > > > 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
RE: Oracle JDBC Connection Problem
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:@//:/ jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)) (CONNECT_DATA=(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:@:: > > 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
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:@:: > > 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
