jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Keith.Gunder...@act.org
Subject Re: Can't connect to Oracle-JDBC using JMeter (solution)
Date Thu, 09 Mar 2006 19:39:11 GMT
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:thin@localhost: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


|---------+---------------------------->
|         |           Keith.Gunderson@a|
|         |           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, Keith.Gunderson@act.org <Keith.Gunderson@act.org> 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: 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