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]
