Hi Mike,
I copied the zip file like you said and that solves indeed the message that it
can't find the driver. But I get the following message. Any ideas?
My configuration:
> > > Database URL: jdbc:oracle:thin:@dev12-adm.wxs.nl:1521:PINTST
> > > JDBC Driver class: oracle.jdbc.driver.OracleDriver
> > > Username: xxx
> > > Password: xxx
2005/04/28 09:55:21 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error in
JDBC sampling java.sql.SQLException: ORA-00911: invalid character
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:854)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:82)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:255)
at java.lang.Thread.run(Unknown Source)
-----Original Message-----
From: Michael Stover [mailto:[EMAIL PROTECTED]
Sent: dinsdag 26 april 2005 15:27
To: [email protected]
Subject: RE: Oracle connection?
For me, my oracle jar file is called "classes12.zip" and I have to
rename it to "classes12.jar" and copy it to jmeter's /lib directory.
-Mike
On Tue, 2005-04-26 at 08:11 +0200, Sander Stevens wrote:
> I think it can't find the driver.
> What is the name of the jar which should contain the oracle driver?
>
> BTW: my informix connection is working fine. Do I need something extra for
> Oracle?
>
> Like [EMAIL PROTECTED] mentioned:
> You have got the Oracle client loaded haven't you???
>
> No, I didn't load any extra. Is that needed? What do you mean?
>
>
> Thanks,
> Sander
>
> -----Original Message-----
> From: Michael Stover [mailto:[EMAIL PROTECTED]
> Sent: maandag 25 april 2005 16:03
> To: JMeter Users List
> Subject: RE: Oracle connection?
>
> This can mean a number of things.
>
> A) The jar with the driver isn't appearing in JMeter's classpath. The
> jar file should be in JMeter's /lib directory to get picked up. And I
> don't think JMeter picks up *.zip files.
>
> B) Your connection string is wrong (though it looks well-formed to me) -
> JMeter can't find a suitable driver for a db it can't find, and often
> you get this same error in that event.
>
> C) There's some network thing blocking your computer's access to the db
> server.
>
> -Mike
>
>
> On Mon, 2005-04-25 at 15:59 +0200, Sander Stevens wrote:
> > Indeed there was a message in the log:
> >
> > 2005/04/25 15:55:57 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error
> > in JDBC sampling java.sql.SQLException: No suitable driver
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > etc.
> >
> > So obviously I am having problems with the driver. Maybe it can't find the
> > driver? Or the driver of the april 4th version is maybe not correct?
> >
> > Sander
> >
> >
> > -----Original Message-----
> > From: Michael Stover [mailto:[EMAIL PROTECTED]
> > Sent: maandag 25 april 2005 15:31
> > To: [email protected]
> > Subject: Re: Oracle connection?
> >
> > "Not working" can mean a lot. Do you see errors in jmeter.log? What
> > does happen, exactly? Can you create the simplest test plan possible to
> > sample the oracle db (ie, one "select 1" sql query)?
> >
> > I use the same driver here where I work and it works ok.
> >
> > -Mike
> >
> > On Mon, 2005-04-25 at 09:43 +0200, Sander Stevens wrote:
> > > Hi,
> > >
> > > I am using JMeter internal build 20050904.
> > > Trying to create an Oracle connection, but my testplan is not working
> > > anymore with this connection active. Disabling the oracle connection will
> > > make sure that the script is working again. So, something is not correct.
> > > Hope someone can help me.
> > >
> > > I add a JDBC Connection configuration to my testplan and enter the
> > > following configuration:
> > >
> > > Database URL: jdbc:oracle:thin:@dev12-adm.wxs.nl:1521:PINTST
> > > JDBC Driver class: oracle.jdbc.driver.OracleDriver
> > > Username: xxx
> > > Password: xxx
> > >
> > > (and username and password are of course scrambledâ â)
> > >
> > > Any ideas? Maybe the driver is not correct?
> > >
> > > Thanks,
> > > Sander Stevens
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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]
