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 2016/08/12 03:38:35 UTC

[Bug 59992] New: Jmeter3.0---Get info from oracle database with Jdbc request, get Response message: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found

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

            Bug ID: 59992
           Summary: Jmeter3.0---Get info from oracle database with Jdbc
                    request, get Response message: java.sql.SQLException:
                    Cannot create PoolableConnectionFactory (ORA-00923:
                    FROM keyword not found
           Product: JMeter
           Version: 3.0
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: Main
          Assignee: issues@jmeter.apache.org
          Reporter: changhongyan0@hotmail.com

Created attachment 34141
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34141&action=edit
JDBC script sample

DataBase:oracle
JDBC connection configuration:
    database url:jdbc:oracle:thin:@(DESCRIPTION
=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1.1.0.0)(PORT=1521)))(CONNECT_DATA=(SID=ora)))
    JDBC Driver class:oracle.jdbc.driver.OracleDriver
    UserName:oracle
    Password:123456
Adding ojbc14.jar in lib directory


Note:with Jmeter version 2.11 run this script,it works fine.With version 3.0,
get error java.sql.SQLException: Cannot create PoolableConnectionFactory
(ORA-00923: FROM keyword not found with result view tree.

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

[Bug 59992] Jmeter3.0---Get info from oracle database with Jdbc request, get Response message: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found

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

Acelin <ch...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from Acelin <ch...@hotmail.com> ---
Above info with Client Jmeter3.0,and get this tool from Apache Jmeter offical
site.

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

[Bug 59992] Jmeter3.0---Get info from oracle database with Jdbc request, get Response message: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found

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

--- Comment #2 from Acelin <ch...@hotmail.com> ---
Additional,oracle version is 10.0.2

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