For future reference... here's how I got things to work. See this document for full documentation of the URL syntax:
http://download-west.oracle.com/docs/cd/B14117_01/java.101/b10979.pdf This was tested with the ojbdc14.jar (version 10.2x and 10.1x drivers) Basically, I changed the URL syntax from: jdbc:oracle:[EMAIL PROTECTED]:port:service jdbc:oracle:thin:user/pw@//localhost:port/service Keith Gunderson Performance Test Analyst IT Audit and Reporting ACT, Inc. 301 ACT Drive Iowa City, IA 52245 (319) 337-1548 Voice (319) 337-1766 Fax |---------+----------------------------> | | [EMAIL PROTECTED]| | | ct.org | | | | | | 03/09/2006 12:42 | | | PM | | | Please respond to| | | "JMeter Users | | | List" | | | | |---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: "JMeter Users List" <jmeter-user@jakarta.apache.org> | | cc: | | Subject: Re: Can't connect to Oracle-JDBC using JMeter | >--------------------------------------------------------------------------------------------------------------| I have confirmed the same SQLException happens when I run the URL-query through a small Java app. So, it seems to not a JMeter problem. I'm back to playing with the URL. I'm using JMeter 2.1.1 (Windows-bin) And the Select query type is being used. Sorry to waste the bandwidth! Thanks! Keith On 09/03/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, > > (I can connect to the database from other tools, but they don't use JDBC.) > Should I test things useing a simple, simple java app first? If you can do so easily, it might be an idea. Or you can try playing with the query and/or the URL. [snip] > Could not return Connection java.sql.SQLException: Invalid Oracle URL > specified This suggests that there is a problem with the syntax, rather than a problem finding the driver, so at least some of it is working. Did you set the query type to select? [snip] Which version of JMeter are you using? S. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
