You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@jmeter.apache.org by bu...@apache.org on 2019/05/08 07:17:44 UTC

[Bug 63410] New: Jmeter > JDBC Sampler> Desc command not working for oracle.

https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

            Bug ID: 63410
           Summary: Jmeter > JDBC Sampler> Desc command not working for
                    oracle.
           Product: JMeter
           Version: 5.0
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: Main
          Assignee: issues@jmeter.apache.org
          Reporter: rahul.dhoundiyal0790@gmail.com
  Target Milestone: JMETER_5.1.1

Created attachment 36575
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36575&action=edit
JDBC Error Desc Statement

Jmeter > JDBC Sampler> Desc command not working for oracle.

Using this command:

desc <table_name>

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

--- Comment #2 from Rahul Dhoundiyal <ra...@gmail.com> ---
Oracle version - 12g
Java Version - 1.8
OS - Windows 10


Test Case Step :

1. Simple describe query from Oracle DB.
Example:

desc <table_name>

Same query works in MYSQL DB but not in oracle.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

Felix Schumacher <fe...@internetallee.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|major                       |minor
                 OS|                            |All
             Status|NEW                         |NEEDINFO

--- Comment #1 from Felix Schumacher <fe...@internetallee.de> ---
Can you provide a minimal test case, that reproduces this issue (a screenshot
is not a test case).

Please provide more information about your setup. That includes Oracle Version,
JDBC Version, Java Version, OS, ...

And please do a search for the ORA-0900 error.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

--- Comment #4 from venkatesh.i87@gmail.com ---
Can you confirm if ANY other select statement is working for example

SELECT count(*) FROM EMPLOYEES;

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

Rahul Dhoundiyal <ra...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|minor                       |critical
             Status|NEEDINFO                    |NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

Philippe Mouawad <p....@ubik-ingenierie.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|NEEDINFO                    |RESOLVED
                 CC|                            |p.mouawad@ubik-ingenierie.c
                   |                            |om

--- Comment #5 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
AFAIK, DESC is an SQL+ command:
https://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12019.htm

So it will not work with select.

See
https://dba.stackexchange.com/questions/87141/unable-to-describe-table-in-oracle

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

Venkatesh Ilango <ve...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 63410] Jmeter > JDBC Sampler> Desc command not working for oracle.

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63410

--- Comment #3 from Rahul Dhoundiyal <ra...@gmail.com> ---
Created attachment 36576
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36576&action=edit
desc query

-- 
You are receiving this mail because:
You are the assignee for the bug.