Try a select statement instead - might give more information
Try enabling debug for the jmeter classes - in jmeter.properties,
remove the # from the line:
#log_level.jmeter.protocol.jdbc=DEBUG
or add the following to the jmeter command line:
-Jjmeter.protocol.jdbc=DEBUG
S.
On 23/03/06, Sayali Kanade <[EMAIL PROTECTED]> wrote:
> Hi,
> First of all, thanks for updating the documentation at such short
> notice.
> I am using the edbc driver to connect to Ingres.
>
> Also, I was trying a sample test to connect to an Oracle db like shown
> in the example. I have carried the instructions to the letter, but the
> queries that I fire do not reach the db (I have checked via the
> kill/trace session and firing an update query) nor does the graph
> listener record anything.
>
> There is nothing in the Jmeter logs either :
>
> 11:16:07 INFO - jmeter.engine.StandardJMeterEngine: Running the test!
> 2006/03/23 11:16:07 INFO - jmeter.gui.util.JMeterMenuBar:
> setRunning(true,local)
> 2006/03/23 11:16:07 INFO - jmeter.engine.StandardJMeterEngine: Starting
> 1 threads for group Thread Group. Ramp up = 10.
> 2006/03/23 11:16:07 INFO - jmeter.engine.StandardJMeterEngine: Continue
> on error
> 2006/03/23 11:16:07 INFO - jmeter.threads.JMeterThread: Thread Thread
> Group 1-1 started
> 2006/03/23 11:16:07 INFO - jmeter.threads.JMeterThread: Thread Thread
> Group 1-1 is done
> 2006/03/23 11:16:07 INFO - jmeter.engine.StandardJMeterEngine: Ending
> thread 0
> 2006/03/23 11:16:07 INFO - jmeter.engine.StandardJMeterEngine: Stopping
> test
> 2006/03/23 11:16:07 INFO - jmeter.engine.StandardJMeterEngine:
> Notifying test listeners of end of test
> 2006/03/23 11:16:07 INFO - jmeter.gui.util.JMeterMenuBar:
> setRunning(false,local)
> 2006/03/23 11:16:07 INFO - jmeter.engine.StandardJMeterEngine: Test has
> ended
>
> These are the details of my test :
> Thread Group : 1 thread looping twice
> -->JDBC Connection Configuration
> Name : JDBC Connection Configuration
> Variable Name Bound to Pool : myPool
> (Here all defaults)
> Validation Query : select * from emp; (What is this?)
> db Connection Config :
> db URL : jdbc:oracle:thin:@172.16.117.206:1521:asdb
> driver class : oracle.jdbc.driver.OracleDriver
> username : scott
> pwd : tiger
> --> JDBC Request
> Name : JDBC Request
> Variable Name : myPool
> SQL Query : Update statement
> Query : update emp set comm=225 where empno=7782
>
> Also have attached a "results in table" listener.
>
> What could I be doing wrong? I am not getting any errors or intimations
> even after supplying the wrong password. Though I did prev get errors
> when I had not put the classes111.jar in Jmeter/lib folder.
>
> Thanks for your help and have a pleasant day!
>
> Best Regards,
> Sayali
>
> MASTEK
> "Making a valuable difference"
> Mastek in NASSCOM's 'India Top 20' Software Service Exporters List.
> In the US, we're called MAJESCOMASTEK
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Opinions expressed in this e-mail are those of the individual and not that of
> Mastek Limited, unless specifically indicated to that effect. Mastek Limited
> does not accept any responsibility or liability for it. This e-mail and
> attachments (if any) transmitted with it are confidential and/or privileged
> and solely for the use of the intended person or entity to which it is
> addressed. Any review, re-transmission, dissemination or other use of or
> taking of any action in reliance upon this information by persons or entities
> other than the intended recipient is prohibited. This e-mail and its
> attachments have been scanned for the presence of computer viruses. It is the
> responsibility of the recipient to run the virus check on e-mails and
> attachments before opening them. If you have received this e-mail in error,
> kindly delete this e-mail from all computers.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> ---------------------------------------------------------------------
> 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]
