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]
