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] > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > 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] > > > > > > --------------------------------------------------------------------- > 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]
