jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Lin <wool...@gmail.com>
Subject Re: Strange Oracle database problem
Date Thu, 14 Jul 2005 14:12:11 GMT
if you're using classes12.zip it should be fine. if it's newer, I
don't know if that might cause an incompatability issue.

peter


On 7/14/05, Sander Stevens <S.Stevens@kpn-is.nl> wrote:
> BTW: I am using 9i client (read: jdbc driver)  and 8i database.
> 
> -----Original Message-----
> From: Peter Lin [mailto:woolfel@gmail.com]
> Sent: donderdag 14 juli 2005 16:00
> To: JMeter Users List
> Subject: Re: Strange Oracle database problem
> 
> it shouldn't. I've used 1.4.2_03 to 08 with oracle without any problems.
> 
> peter
> 
> 
> On 7/14/05, Sander Stevens <S.Stevens@kpn-is.nl> wrote:
> > The database administrator will have a look for me.
> > BTW: I am using java 1.4.2_08. Could that give any problems?
> >
> > -----Original Message-----
> > From: Peter Lin [mailto:woolfel@gmail.com]
> > Sent: donderdag 14 juli 2005 15:25
> > To: JMeter Users List
> > Subject: Re: Strange Oracle database problem
> >
> > have you tried looking in the TNSListener log?
> >
> > there's probably something there that will tell you why the queries
> > failed.
> >
> >
> > peter
> >
> > On 7/14/05, Sander Stevens <S.Stevens@kpn-is.nl> wrote:
> > > Peter,
> > >
> > > I am using Oracle8i and copied the driver (dated 25-4-2002) from my
> > > client environment to the lib folder of jmeter.
> > >
> > > Yes, SQL*Plus directly to the database (with the same user).
> > >
> > > Sander
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Peter Lin [mailto:woolfel@gmail.com]
> > > Sent: donderdag 14 juli 2005 15:18
> > > To: JMeter Users List
> > > Subject: Re: Strange Oracle database problem
> > >
> > > which version of the driver are you using in jmeter versus using
> > > sqlplus. I assume you're using sqlplus to test it directly against
> > > Oracle.
> > >
> > > also, which version of oracle are you using?  8i, 9i or 10g
> > >
> > > peter
> > >
> > > On 7/14/05, Sander Stevens <S.Stevens@kpn-is.nl> wrote:
> > > > I gave the table description to Alan (we spoke off line about the
> > > > topic), but no luck. Can't figure out why jmeter can execute an
> > update
> > > > statement where SQL*Plus and SQL Tools have no problem with it
> (same
> > > > statement, direct copy of the text). A select statement in jmeter
> is
> > > no
> > > > problem and works fine.
> > > >
> > > > Anyone any clues left?
> > > >
> > > > Sander
> > > >
> > > > -----Original Message-----
> > > > From: allan.hagan@bt.com [mailto:allan.hagan@bt.com]
> > > > Sent: donderdag 14 juli 2005 11:20
> > > > To: jmeter-user@jakarta.apache.org
> > > > Subject: RE: Strange Oracle database problem
> > > >
> > > > Table description please.
> > > >
> > > > Allan
> > > >
> > > > -----Original Message-----
> > > > From: Sander Stevens [mailto:S.Stevens@kpn-is.nl]
> > > > Sent: 14 July 2005 08:10
> > > > To: jmeter-user@jakarta.apache.org
> > > > Subject: Strange Oracle database problem
> > > >
> > > > Hi all,
> > > >
> > > > I have my database settings configured and a select statement is
> > > working
> > > > fine.
> > > > select * from ipmgr.client_ip where ip_address = '80.60.92.102'
> > > >
> > > > The next statement is an update.
> > > > UPDATE ipmgr.client_ip SET status = '1' WHERE ip_address =
> > > > '80.60.92.102'
> > > >
> > > > And this is giving me some problems. No result in the result tree
> > and
> > > > the following error message in the jmeter.log. The same statement
> is
> > > > working fine is e.g SQL Tools. So, I use the same database
> > > > configuration, the same drivers, etc and the select is workign
> fine
> > > and
> > > > the update is giving me problems. Any ideas to solve to this?
> > > >
> > > > 2005/07/14 09:04:25 ERROR -
> > jmeter.protocol.jdbc.sampler.JDBCSampler:
> > > > Error in JDBC sampling java.sql.SQLException: ORA-00900: invalid
> SQL
> > > > statement
> > > >
> > > >         at
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> > > >         at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> > > >         at
> oracle.jdbc.ttc7.v8Odscrarr.receive(v8Odscrarr.java:205)
> > > >         at
> > > oracle.jdbc.ttc7.TTC7Protocol.describe(TTC7Protocol.java:754)
> > > >         at
> > > >
> > oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:6195)
> > > >         at
> > > >
> > >
> >
> oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaDat
> > > > a.java:55)
> > > >         at
> > > >
> > >
> >
> oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.j
> > > > ava:152)
> > > >         at
> > > >
> > >
> >
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.getDataFromResultSet
> > > > (JDBCSampler.java:168)
> > > >         at
> > > >
> > >
> >
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
> > > > ava:89)
> > > >         at
> > > > org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:255)
> > > >         at java.lang.Thread.run(Unknown Source)
> > > >
> > > > Best regards,
> > > > Sander Stevens
> > > >
> > > >
> > ---------------------------------------------------------------------
> > > > 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
> >
> >
> 
> ---------------------------------------------------------------------
> 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