You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Ke...@act.org on 2006/03/09 18:02:59 UTC
Can't connect to Oracle-JDBC using JMeter
Hello,
I'm new to JMeter, but I'm not so new jakarta related things. It has been
a number of months since I've been directly involved with Java development
projects.
I'm needing to simulate JDBC using JMeter. I have a simple test plan with
a threadgroup that contains a JDBC Connection Configuration and a JDBC
Thread Group.
I put the ojdbc14.jar file in the lib directory (or entered in the Test
Plan classpath, as below). I have the URL, username, and password entered
correctly in the Connection Configuration.
But, when I run the test, I get the following. Can I be missing a
formatting convetion in the URL connection string? (Or something even
stupider?.)
(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?
2006/03/09 09:00:42 INFO - jmeter.testelement.TestPlan: add
H:\GundersK\build\jakarta-jmeter-2.1.1\bin\ojdbc14.jar to classpath
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Preparing
class org.apache.jmeter.protocol.jdbc.config.DataSourceElement
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
dataSource=pool1
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
poolMax=10
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
timeout=10000
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
trimInterval=60000
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
autocommit=true
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
keepAlive=true
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
connectionAge=5000
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
checkQuery=Select * from dual
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
dbUrl=jdbc:oracle:thin@XXXX.X.org:1XX5:d9i
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
driver=oracle.jdbc.driver.OracleDriver
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
username=ddd_ssss_user
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
password=ddd_ssss_user
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Preparing
class org.apache.jmeter.protocol.jdbc.config.DataSourceElement
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
dataSource=pool1
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
poolMax=10
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
timeout=10000
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
trimInterval=60000
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
autocommit=true
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
keepAlive=true
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
connectionAge=5000
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
checkQuery=Select * from dual
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
dbUrl=jdbc:oracle:thin@XXXX.X.org:1XX5:d9i
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
driver=oracle.jdbc.driver.OracleDriver
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
username=ddd_ssss_user
2006/03/09 09:00:42 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
password=ddd_ssss_user
2006/03/09 09:00:43 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement:
MaxPool: 10 Timeout: 10000 TrimInt: 60000
2006/03/09 09:00:43 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement:
KeepAlive: true Age: 5000 CheckQuery: Select * from dual
2006/03/09 09:00:43 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement:
Driver: oracle.jdbc.driver.OracleDriver DbUrl:
jdbc:oracle:thin@XXXX.X.org:1XX5:d9i User: ddd_ssss_user
2006/03/09 09:00:43 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement:
Loading new driver: oracle.jdbc.driver.OracleDriver
2006/03/09 09:00:43 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(true,local)
2006/03/09 09:00:43 INFO - jmeter.engine.StandardJMeterEngine: Starting 1
threads for group ThreadGroup. Ramp up = 1.
2006/03/09 09:00:43 INFO - jmeter.engine.StandardJMeterEngine: Thread will
stop on error
2006/03/09 09:00:43 WARN - jmeter.threads.JMeterThread:
jmeterthread.startearlier=true (see jmeter.properties)
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: Subtracting node,
stack size = 2
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: Subtracting node,
stack size = 2
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: Subtracting node,
stack size = 2
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: adding controller:
org.apache.jmeter.threads.ThreadGroup@1506900 to sampler config
2006/03/09 09:00:43 DEBUG - jmeter.threads.SamplePackage: configs is null:
false
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: Subtracting node,
stack size = 2
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: Subtracting node,
stack size = 2
2006/03/09 09:00:43 DEBUG - jmeter.threads.TestCompiler: Subtracting node,
stack size = 1
2006/03/09 09:00:43 INFO - jmeter.threads.JMeterThread: Thread ThreadGroup
1-1 started
2006/03/09 09:00:43 DEBUG - jmeter.control.GenericController: Calling next
on: org.apache.jmeter.control.LoopController
2006/03/09 09:00:43 DEBUG - jmeter.control.GenericController: Calling next
on: org.apache.jmeter.control.LoopController
2006/03/09 09:00:43 DEBUG - jmeter.control.GenericController: Calling next
on: org.apache.jmeter.control.LoopController
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Preparing
class org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
dataSource=pool1
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
queryType=Select Statement
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
query=select * from dual;
2006/03/09 09:00:46 DEBUG - jmeter.protocol.jdbc.sampler.JDBCSampler:
sampling jdbc
2006/03/09 09:00:46 DEBUG - jmeter.protocol.jdbc.sampler.JDBCSampler:
DataSourceComponent:
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource@126557e
2006/03/09 09:00:46 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement:
Marking 0 objects as old in pool.
2006/03/09 09:00:46 WARN - jmeter.protocol.jdbc.config.DataSourceElement:
Could not return Connection java.sql.SQLException: Invalid Oracle URL
specified
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:538)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:185)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:402)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:80)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247)
at java.lang.Thread.run(Unknown Source)
2006/03/09 09:00:46 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error
in JDBC sampling java.sql.SQLException: Invalid Oracle URL specified
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:538)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:185)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:402)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:80)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:247)
at java.lang.Thread.run(Unknown Source)
2006/03/09 09:00:46 INFO - jmeter.threads.JMeterThread: Stop Thread
detected by thread ThreadGroup 1-1
2006/03/09 09:00:46 INFO - jmeter.threads.JMeterThread: Thread ThreadGroup
1-1 is done
2006/03/09 09:00:46 INFO - jmeter.engine.StandardJMeterEngine: Ending
thread 0
2006/03/09 09:00:46 INFO - jmeter.engine.StandardJMeterEngine: Stopping
test
2006/03/09 09:00:46 INFO - jmeter.engine.StandardJMeterEngine: Notifying
test listeners of end of test
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Preparing
class org.apache.jmeter.protocol.jdbc.config.DataSourceElement
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
dataSource=pool1
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
poolMax=10
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
timeout=10000
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
trimInterval=60000
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
autocommit=true
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
keepAlive=true
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
connectionAge=5000
2006/03/09 09:00:46 DEBUG - jmeter.testbeans.TestBeanHelper: Setting
checkQuery=Select * from dual
.
.
.
2006/03/09 09:00:46 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement:
There were 1 outstanding objects when the pool was disposed.
2006/03/09 09:00:46 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(false,local)
2006/03/09 09:00:46 INFO - jmeter.engine.StandardJMeterEngine: Test has
ended
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
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Can't connect to Oracle-JDBC using JMeter
Posted by sebb <se...@gmail.com>.
On 09/03/06, Keith.Gunderson@act.org <Ke...@act.org> wrote:
> Hello,
>
> I'm new to JMeter, but I'm not so new jakarta related things. It has been
> a number of months since I've been directly involved with Java development
> projects.
>
> I'm needing to simulate JDBC using JMeter. I have a simple test plan with
> a threadgroup that contains a JDBC Connection Configuration and a JDBC
> Thread Group.
>
> I put the ojdbc14.jar file in the lib directory (or entered in the Test
> Plan classpath, as below). I have the URL, username, and password entered
> correctly in the Connection Configuration.
>
> But, when I run the test, I get the following. Can I be missing a
> formatting convetion in the URL connection string? (Or something even
> stupider?.)
>
> (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