You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by "Stevens, S." <S....@eneco.nl> on 2008/01/14 11:34:45 UTC
Connection to Oracle database with JDBC
Hi,
I try to connect to an Oracle database.
Downloaded classes12.zip, copied it to the lib folder and renamed it to
classes12.jar.
Started Jmeter (version 2.3.1) and added JDBC configuration
configuration to my testplan with the following settings: JDBC Driver
Class : oracle.jdbc.driver.OracleDriver.
Run my testplan and I see in the log the following warning:
2008/01/14 11:20:31 WARN -
jmeter.protocol.jdbc.config.DataSourceElement: Could not return
Connection java.sql.SQLException: No suitable driver
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(Resour
ceLimitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolab
le (ValidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnection
Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimiti
ngPool.java:402)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Valid
atedResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.ge
tConnection(ResourceLimitingJdbcDataSource.java:222)
at
org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCompo
nentImpl.getConnection(DataSourceElement.java:271)
at
org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(D
ataSourceElement.java:141)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
ava:152)
at
org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
at java.lang.Thread.run(Unknown Source)
Looks like Jmeter can't find the (correct) driver. Can anybody tell me
what's wrong???
Thanks!
Sander
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: Connection to Oracle database with JDBC
Posted by "Stevens, S." <S....@eneco.nl>.
Aneez,
I followed your instructions and it works. Couple of details different
than in my configuration (classes.zip, ojdbc14.jar, driver class).
Thanks for the assistance!
Sander
__________________________________
Met vriendelijke groet,
Sander Stevens
Test manager SOURCE
Tel.: +31 (0)6 - 46 40 46 73
-----Oorspronkelijk bericht-----
Van: A.Aneez [mailto:aaneez@googlemail.com]
Verzonden: maandag 14 januari 2008 16:26
Aan: JMeter Users List
Onderwerp: Re: Connection to Oracle database with JDBC
I have this working..
a) get ojdbc14.jar from Oracle..
Classes12.zip should not be renamed and used.
This should be copied to JMETER_HOME/Lib directory..
b) Add a JDBC Config element..use thin client url.
URL should be something like:
jdbc:oracle:thin:@//<IP>:<PORT>/<SID>
JDBC Driver class should be : *oracle.jdbc.OracleDriver*
c) Add a JDBC sampler..
see if this helps..
Aneez.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Connection to Oracle database with JDBC
Posted by "A.Aneez" <aa...@googlemail.com>.
I have this working..
a) get ojdbc14.jar from Oracle..
Classes12.zip should not be renamed and used.
This should be copied to JMETER_HOME/Lib directory..
b) Add a JDBC Config element..use thin client url.
URL should be something like:
jdbc:oracle:thin:@//<IP>:<PORT>/<SID>
JDBC Driver class should be : *oracle.jdbc.OracleDriver*
c) Add a JDBC sampler..
see if this helps..
Aneez.
RE: Connection to Oracle database with JDBC
Posted by al...@bt.com.
S,
Should look something like:
DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@hostname:1526:orcl", "scott", "tiger");
// @machineName:port:SID, userid,
password
Regards,
Allan
-----Original Message-----
From: Stevens, S. [mailto:S.Stevens@eneco.nl]
Sent: 14 January 2008 15:09
To: JMeter Users List
Subject: RE: Connection to Oracle database with JDBC
Hi Allan,
The database url you mean?
That is something like [user]@//[IP]:[port]/MVS_A
Very strange, because the classes12,jar is loaded (can't rename the jar
if jmeter is running), but the driver is nog found. Some other setting I
didn't thought about?
S.
__________________________________
Met vriendelijke groet,
Sander Stevens
Test manager SOURCE
Tel.: +31 (0)6 - 46 40 46 73
-----Oorspronkelijk bericht-----
Van: allan.hagan@bt.com [mailto:allan.hagan@bt.com]
Verzonden: maandag 14 januari 2008 16:04
Aan: jmeter-user@jakarta.apache.org
Onderwerp: RE: Connection to Oracle database with JDBC
Classes12 should work - what does your connection string look like?
Allan
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: 14 January 2008 14:34
To: JMeter Users List
Subject: Re: Connection to Oracle database with JDBC
On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> Hi Sebb,
>
> I checked the content of the JAR and this looks good (the
> oracledriver.class is in the folder oracle.jdbc.driver). I also tried
I assume mean OracleDriver ?
> the same trick with ojdbc14.jar. This file is (looking at info on the
> internet) compatible with JDK 1.4. But same problem. Can't find
driver.
>
> Any hints?
>
> BTW: I am using java 1.4.1_02. Do I need classes12.jar or ojdbc14.jar?
>
Sorry, no idea. I don't use Oracle.
The Oracle documentation should be able to help here.
> Thanks,
> Sander
>
> __________________________________
> Met vriendelijke groet,
> Sander Stevens
> Test manager SOURCE
> Tel.: +31 (0)6 - 46 40 46 73
>
>
>
> -----Oorspronkelijk bericht-----
> Van: sebb [mailto:sebbaz@gmail.com]
> Verzonden: maandag 14 januari 2008 12:06
> Aan: JMeter Users List
> Onderwerp: Re: Connection to Oracle database with JDBC
>
>
> On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> > Hi,
> >
> > I try to connect to an Oracle database.
> > Downloaded classes12.zip, copied it to the lib folder and renamed it
> > to classes12.jar.
>
> OK.
>
> > Started Jmeter (version 2.3.1) and added JDBC configuration
> > configuration to my testplan with the following settings: JDBC
> > Driver
>
> > Class : oracle.jdbc.driver.OracleDriver.
> >
> > Run my testplan and I see in the log the following warning:
> >
> > 2008/01/14 11:20:31 WARN -
> > jmeter.protocol.jdbc.config.DataSourceElement: Could not return
> > Connection java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at
> > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInst
> > an
> > ce
> > (JdbcConnectionFactory.java:185)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(Reso
> ur
> > ceLimitingPool.java:672)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPool
> ab
> > le (ValidatedResourceLimitingPool.java:178)
> > at
> > org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectio
> > n
> > Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimi
> ti
> > ngPool.java:402)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Val
> id
> > atedResourceLimitingPool.java:130)
> > at
> >
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.
> ge
> > tConnection(ResourceLimitingJdbcDataSource.java:222)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCom
> po
> > nentImpl.getConnection(DataSourceElement.java:271)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection
> (D
> > ataSourceElement.java:141)
> > at
> >
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler
> .j
> > ava:152)
> > at
> > org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
> > at java.lang.Thread.run(Unknown Source)
> >
> > Looks like Jmeter can't find the (correct) driver. Can anybody tell
> > me
>
> > what's wrong???
> >
>
> Yes, JMeter cannot find the driver. This could be due to a
> misspelling, or maybe other jar files are needed, or maybe the jar
> file is for a later version of Java.
>
> You can use jar or another archive program to check the contents of
> the jar file. Check the jar requirements in the Oracle documentation.
>
> > Thanks!
> > Sander
> >
> > --------------------------------------------------------------------
> > - 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
>
>
---------------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: Connection to Oracle database with JDBC
Posted by "Stevens, S." <S....@eneco.nl>.
Hi Allan,
The database url you mean?
That is something like [user]@//[IP]:[port]/MVS_A
Very strange, because the classes12,jar is loaded (can't rename the jar
if jmeter is running), but the driver is nog found. Some other setting I
didn't thought about?
S.
__________________________________
Met vriendelijke groet,
Sander Stevens
Test manager SOURCE
Tel.: +31 (0)6 - 46 40 46 73
-----Oorspronkelijk bericht-----
Van: allan.hagan@bt.com [mailto:allan.hagan@bt.com]
Verzonden: maandag 14 januari 2008 16:04
Aan: jmeter-user@jakarta.apache.org
Onderwerp: RE: Connection to Oracle database with JDBC
Classes12 should work - what does your connection string look like?
Allan
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: 14 January 2008 14:34
To: JMeter Users List
Subject: Re: Connection to Oracle database with JDBC
On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> Hi Sebb,
>
> I checked the content of the JAR and this looks good (the
> oracledriver.class is in the folder oracle.jdbc.driver). I also tried
I assume mean OracleDriver ?
> the same trick with ojdbc14.jar. This file is (looking at info on the
> internet) compatible with JDK 1.4. But same problem. Can't find
driver.
>
> Any hints?
>
> BTW: I am using java 1.4.1_02. Do I need classes12.jar or ojdbc14.jar?
>
Sorry, no idea. I don't use Oracle.
The Oracle documentation should be able to help here.
> Thanks,
> Sander
>
> __________________________________
> Met vriendelijke groet,
> Sander Stevens
> Test manager SOURCE
> Tel.: +31 (0)6 - 46 40 46 73
>
>
>
> -----Oorspronkelijk bericht-----
> Van: sebb [mailto:sebbaz@gmail.com]
> Verzonden: maandag 14 januari 2008 12:06
> Aan: JMeter Users List
> Onderwerp: Re: Connection to Oracle database with JDBC
>
>
> On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> > Hi,
> >
> > I try to connect to an Oracle database.
> > Downloaded classes12.zip, copied it to the lib folder and renamed it
> > to classes12.jar.
>
> OK.
>
> > Started Jmeter (version 2.3.1) and added JDBC configuration
> > configuration to my testplan with the following settings: JDBC
> > Driver
>
> > Class : oracle.jdbc.driver.OracleDriver.
> >
> > Run my testplan and I see in the log the following warning:
> >
> > 2008/01/14 11:20:31 WARN -
> > jmeter.protocol.jdbc.config.DataSourceElement: Could not return
> > Connection java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at
> > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInst
> > an
> > ce
> > (JdbcConnectionFactory.java:185)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(Reso
> ur
> > ceLimitingPool.java:672)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPool
> ab
> > le (ValidatedResourceLimitingPool.java:178)
> > at
> > org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectio
> > n
> > Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimi
> ti
> > ngPool.java:402)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Val
> id
> > atedResourceLimitingPool.java:130)
> > at
> >
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.
> ge
> > tConnection(ResourceLimitingJdbcDataSource.java:222)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCom
> po
> > nentImpl.getConnection(DataSourceElement.java:271)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection
> (D
> > ataSourceElement.java:141)
> > at
> >
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler
> .j
> > ava:152)
> > at
> > org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
> > at java.lang.Thread.run(Unknown Source)
> >
> > Looks like Jmeter can't find the (correct) driver. Can anybody tell
> > me
>
> > what's wrong???
> >
>
> Yes, JMeter cannot find the driver. This could be due to a
> misspelling, or maybe other jar files are needed, or maybe the jar
> file is for a later version of Java.
>
> You can use jar or another archive program to check the contents of
> the jar file. Check the jar requirements in the Oracle documentation.
>
> > Thanks!
> > Sander
> >
> > --------------------------------------------------------------------
> > - 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
>
>
---------------------------------------------------------------------
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
RE: Connection to Oracle database with JDBC
Posted by al...@bt.com.
Classes12 should work - what does your connection string look like?
Allan
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: 14 January 2008 14:34
To: JMeter Users List
Subject: Re: Connection to Oracle database with JDBC
On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> Hi Sebb,
>
> I checked the content of the JAR and this looks good (the
> oracledriver.class is in the folder oracle.jdbc.driver). I also tried
I assume mean OracleDriver ?
> the same trick with ojdbc14.jar. This file is (looking at info on the
> internet) compatible with JDK 1.4. But same problem. Can't find
driver.
>
> Any hints?
>
> BTW: I am using java 1.4.1_02. Do I need classes12.jar or ojdbc14.jar?
>
Sorry, no idea. I don't use Oracle.
The Oracle documentation should be able to help here.
> Thanks,
> Sander
>
> __________________________________
> Met vriendelijke groet,
> Sander Stevens
> Test manager SOURCE
> Tel.: +31 (0)6 - 46 40 46 73
>
>
>
> -----Oorspronkelijk bericht-----
> Van: sebb [mailto:sebbaz@gmail.com]
> Verzonden: maandag 14 januari 2008 12:06
> Aan: JMeter Users List
> Onderwerp: Re: Connection to Oracle database with JDBC
>
>
> On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> > Hi,
> >
> > I try to connect to an Oracle database.
> > Downloaded classes12.zip, copied it to the lib folder and renamed it
> > to classes12.jar.
>
> OK.
>
> > Started Jmeter (version 2.3.1) and added JDBC configuration
> > configuration to my testplan with the following settings: JDBC
> > Driver
>
> > Class : oracle.jdbc.driver.OracleDriver.
> >
> > Run my testplan and I see in the log the following warning:
> >
> > 2008/01/14 11:20:31 WARN -
> > jmeter.protocol.jdbc.config.DataSourceElement: Could not return
> > Connection java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at
> > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInst
> > an
> > ce
> > (JdbcConnectionFactory.java:185)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(Reso
> ur
> > ceLimitingPool.java:672)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPool
> ab
> > le (ValidatedResourceLimitingPool.java:178)
> > at
> > org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectio
> > n
> > Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimi
> ti
> > ngPool.java:402)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Val
> id
> > atedResourceLimitingPool.java:130)
> > at
> >
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.
> ge
> > tConnection(ResourceLimitingJdbcDataSource.java:222)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCom
> po
> > nentImpl.getConnection(DataSourceElement.java:271)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection
> (D
> > ataSourceElement.java:141)
> > at
> >
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler
> .j
> > ava:152)
> > at
> > org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
> > at java.lang.Thread.run(Unknown Source)
> >
> > Looks like Jmeter can't find the (correct) driver. Can anybody tell
> > me
>
> > what's wrong???
> >
>
> Yes, JMeter cannot find the driver. This could be due to a
> misspelling, or maybe other jar files are needed, or maybe the jar
> file is for a later version of Java.
>
> You can use jar or another archive program to check the contents of
> the jar file. Check the jar requirements in the Oracle documentation.
>
> > Thanks!
> > Sander
> >
> > --------------------------------------------------------------------
> > - 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
>
>
---------------------------------------------------------------------
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
Re: Connection to Oracle database with JDBC
Posted by sebb <se...@gmail.com>.
On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> Hi Sebb,
>
> I checked the content of the JAR and this looks good (the
> oracledriver.class is in the folder oracle.jdbc.driver). I also tried
I assume mean OracleDriver ?
> the same trick with ojdbc14.jar. This file is (looking at info on the
> internet) compatible with JDK 1.4. But same problem. Can't find driver.
>
> Any hints?
>
> BTW: I am using java 1.4.1_02. Do I need classes12.jar or ojdbc14.jar?
>
Sorry, no idea. I don't use Oracle.
The Oracle documentation should be able to help here.
> Thanks,
> Sander
>
> __________________________________
> Met vriendelijke groet,
> Sander Stevens
> Test manager SOURCE
> Tel.: +31 (0)6 - 46 40 46 73
>
>
>
> -----Oorspronkelijk bericht-----
> Van: sebb [mailto:sebbaz@gmail.com]
> Verzonden: maandag 14 januari 2008 12:06
> Aan: JMeter Users List
> Onderwerp: Re: Connection to Oracle database with JDBC
>
>
> On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> > Hi,
> >
> > I try to connect to an Oracle database.
> > Downloaded classes12.zip, copied it to the lib folder and renamed it
> > to classes12.jar.
>
> OK.
>
> > Started Jmeter (version 2.3.1) and added JDBC configuration
> > configuration to my testplan with the following settings: JDBC Driver
>
> > Class : oracle.jdbc.driver.OracleDriver.
> >
> > Run my testplan and I see in the log the following warning:
> >
> > 2008/01/14 11:20:31 WARN -
> > jmeter.protocol.jdbc.config.DataSourceElement: Could not return
> > Connection java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at
> > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstan
> > ce
> > (JdbcConnectionFactory.java:185)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(Resour
> > ceLimitingPool.java:672)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolab
> > le (ValidatedResourceLimitingPool.java:178)
> > at
> > org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnection
> > Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
> > at
> >
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimiti
> > ngPool.java:402)
> > at
> >
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Valid
> > atedResourceLimitingPool.java:130)
> > at
> >
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.ge
> > tConnection(ResourceLimitingJdbcDataSource.java:222)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCompo
> > nentImpl.getConnection(DataSourceElement.java:271)
> > at
> >
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(D
> > ataSourceElement.java:141)
> > at
> >
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
> > ava:152)
> > at
> > org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
> > at java.lang.Thread.run(Unknown Source)
> >
> > Looks like Jmeter can't find the (correct) driver. Can anybody tell me
>
> > what's wrong???
> >
>
> Yes, JMeter cannot find the driver. This could be due to a misspelling,
> or maybe other jar files are needed, or maybe the jar file is for a
> later version of Java.
>
> You can use jar or another archive program to check the contents of the
> jar file. Check the jar requirements in the Oracle documentation.
>
> > Thanks!
> > Sander
> >
> > ---------------------------------------------------------------------
> > 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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: Connection to Oracle database with JDBC
Posted by "Stevens, S." <S....@eneco.nl>.
Hi Sebb,
I checked the content of the JAR and this looks good (the
oracledriver.class is in the folder oracle.jdbc.driver). I also tried
the same trick with ojdbc14.jar. This file is (looking at info on the
internet) compatible with JDK 1.4. But same problem. Can't find driver.
Any hints?
BTW: I am using java 1.4.1_02. Do I need classes12.jar or ojdbc14.jar?
Thanks,
Sander
__________________________________
Met vriendelijke groet,
Sander Stevens
Test manager SOURCE
Tel.: +31 (0)6 - 46 40 46 73
-----Oorspronkelijk bericht-----
Van: sebb [mailto:sebbaz@gmail.com]
Verzonden: maandag 14 januari 2008 12:06
Aan: JMeter Users List
Onderwerp: Re: Connection to Oracle database with JDBC
On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> Hi,
>
> I try to connect to an Oracle database.
> Downloaded classes12.zip, copied it to the lib folder and renamed it
> to classes12.jar.
OK.
> Started Jmeter (version 2.3.1) and added JDBC configuration
> configuration to my testplan with the following settings: JDBC Driver
> Class : oracle.jdbc.driver.OracleDriver.
>
> Run my testplan and I see in the log the following warning:
>
> 2008/01/14 11:20:31 WARN -
> jmeter.protocol.jdbc.config.DataSourceElement: Could not return
> Connection java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at
> org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstan
> ce
> (JdbcConnectionFactory.java:185)
> at
>
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(Resour
> ceLimitingPool.java:672)
> at
>
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolab
> le (ValidatedResourceLimitingPool.java:178)
> at
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnection
> Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
> at
>
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimiti
> ngPool.java:402)
> at
>
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Valid
> atedResourceLimitingPool.java:130)
> at
>
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.ge
> tConnection(ResourceLimitingJdbcDataSource.java:222)
> at
>
org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCompo
> nentImpl.getConnection(DataSourceElement.java:271)
> at
>
org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(D
> ataSourceElement.java:141)
> at
>
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
> ava:152)
> at
> org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
> at java.lang.Thread.run(Unknown Source)
>
> Looks like Jmeter can't find the (correct) driver. Can anybody tell me
> what's wrong???
>
Yes, JMeter cannot find the driver. This could be due to a misspelling,
or maybe other jar files are needed, or maybe the jar file is for a
later version of Java.
You can use jar or another archive program to check the contents of the
jar file. Check the jar requirements in the Oracle documentation.
> Thanks!
> Sander
>
> ---------------------------------------------------------------------
> 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
Re: Connection to Oracle database with JDBC
Posted by sebb <se...@gmail.com>.
On 14/01/2008, Stevens, S. <S....@eneco.nl> wrote:
> Hi,
>
> I try to connect to an Oracle database.
> Downloaded classes12.zip, copied it to the lib folder and renamed it to
> classes12.jar.
OK.
> Started Jmeter (version 2.3.1) and added JDBC configuration
> configuration to my testplan with the following settings: JDBC Driver
> Class : oracle.jdbc.driver.OracleDriver.
>
> Run my testplan and I see in the log the following warning:
>
> 2008/01/14 11:20:31 WARN -
> jmeter.protocol.jdbc.config.DataSourceElement: Could not return
> Connection java.sql.SQLException: No suitable driver
> 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(Resour
> ceLimitingPool.java:672)
> at
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolab
> le (ValidatedResourceLimitingPool.java:178)
> at
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnection
> Pool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
> at
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimiti
> ngPool.java:402)
> at
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Valid
> atedResourceLimitingPool.java:130)
> at
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.ge
> tConnection(ResourceLimitingJdbcDataSource.java:222)
> at
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceCompo
> nentImpl.getConnection(DataSourceElement.java:271)
> at
> org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(D
> ataSourceElement.java:141)
> at
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
> ava:152)
> at
> org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:300)
> at java.lang.Thread.run(Unknown Source)
>
> Looks like Jmeter can't find the (correct) driver. Can anybody tell me
> what's wrong???
>
Yes, JMeter cannot find the driver. This could be due to a
misspelling, or maybe other jar files are needed, or maybe the jar
file is for a later version of Java.
You can use jar or another archive program to check the contents of
the jar file.
Check the jar requirements in the Oracle documentation.
> Thanks!
> Sander
>
> ---------------------------------------------------------------------
> 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