jmeter.protocol.jdbc.config.DataSourceElement: Ping of connection failed. java.sql.SQLException: ORA-00923: FROM keyword not found where expected

nabble.com | 4 months ago
  1. 0

    JMeter - User - JDBC issue getting error message Ping of connection failed. java.sql.SQLException: ORA-00923: FROM keyword not found where expected

    nabble.com | 4 months ago
    jmeter.protocol.jdbc.config.DataSourceElement: Ping of connection failed. java.sql.SQLException: ORA-00923: FROM keyword not found where expected
  2. 0

    JMeter can't connect to local database

    Stack Overflow | 12 months ago | ryekayo
    jmeter.protocol.jdbc.config.DataSourceElement: Could not load driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  3. 0

    Unable to find mysql jdbc driver

    GitHub | 5 months ago | winston-lee
    jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/foobar
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. jmeter.protocol.jdbc.config.DataSourceElement

      Ping of connection failed. java.sql.SQLException: ORA-00923: FROM keyword not found where expected

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      1 frame
    3. oracle.jdbc.ttc7
      TTC7Protocol.parseExecuteDescribe
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
      4 frames
    4. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
      2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
      3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
      4 frames
    5. org.apache.avalon
      AbstractJdbcConnection.isClosed
      1. org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.isClosed(AbstractJdbcConnection.java:235)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    7. org.apache.avalon
      AbstractJdbcConnection.invoke
      1. org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.invoke(AbstractJdbcConnection.java:357)
      1 frame
    8. Unknown
      $Proxy0.isClosed
      1. $Proxy0.isClosed(Unknown Source)
      1 frame
    9. org.apache.avalon
      ResourceLimitingJdbcConnectionPool.validatePoolable
      1. org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.validatePoolable(ResourceLimitingJdbcConnectionPool.java:159)
      1 frame
    10. Excalibur Pool API
      ValidatedResourceLimitingPool.get
      1. org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:141)
      1 frame
    11. org.apache.avalon
      ResourceLimitingJdbcDataSource.getConnection
      1. org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
      1 frame
    12. org.apache.jmeter
      JDBCSampler.sample
      1. org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:274)
      2. org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:142)
      3. org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:173)
      3 frames
    13. Apache JMeter Core
      JMeterThread.run
      1. org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:348)
      2. org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:243)
      2 frames
    14. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame