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]
