I don't know Oracle, but the error message seems clear that there is an error in the SQL statement.
Could this be generated locally by the JDBC driver? If so, it would explain why the request is not reaching the database. So do all UPDATE statements fail, or just this one? If you change the UPDATE statement in the sampler into the corresponding SELECT, i.e. SELECT count(*) from ipmgr.client_ip WHERE status = '1' AND ip_address = '80.60.92.102' what happens? S On 7/14/05, Sander Stevens <[EMAIL PROTECTED]> wrote: > Yes, but the thing I don't understand is that a select statement works > perfect. So the connection is no problem in my opinion. Same script, two > jdbc requests: a select and an update. And the update will always fail. > The select works fine. > > -----Original Message----- > From: Peter Lin [mailto:[EMAIL PROTECTED] > Sent: donderdag 14 juli 2005 16:52 > To: JMeter Users List > Subject: Re: Strange Oracle database problem > > one you fix the connectivity problem, it should work. though it's > hard for me to guess what could be causing it. > > peter > > > On 7/14/05, Sander Stevens <[EMAIL PROTECTED]> wrote: > > 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]
