A snapshot from the listener log: 14-JUL-2005 16:30:52 * (CONNECT_DATA=(SID=PINTST)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.94.24.66)(PORT=3602)) * establish * PINTST * 0 14-JUL-2005 16:30:53 * (CONNECT_DATA=(SID=pintst)(CID=(PROGRAM=)(HOST=preprod01)(USER=nobody))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.94.14.27)(PORT=48979)) * establish * pintst * 0
It seems that the query doesn't reach the oracle database. A trace on the database didn't give any result while running the script. Sander -----Original Message----- From: Peter Lin [mailto:[EMAIL PROTECTED] Sent: donderdag 14 juli 2005 16:12 To: JMeter Users List Subject: Re: Strange Oracle database problem 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 <[EMAIL PROTECTED]> wrote: > BTW: I am using 9i client (read: jdbc driver) and 8i database. > > -----Original Message----- > From: Peter Lin [mailto:[EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > Sent: donderdag 14 juli 2005 11:20 > > > > To: [email protected] > > > > Subject: RE: Strange Oracle database problem > > > > > > > > Table description please. > > > > > > > > Allan > > > > > > > > -----Original Message----- > > > > From: Sander Stevens [mailto:[EMAIL PROTECTED] > > > > Sent: 14 July 2005 08:10 > > > > To: [email protected] > > > > 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: [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] > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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] > > > > > > --------------------------------------------------------------------- > > 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] > > --------------------------------------------------------------------- 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]
