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]
