Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-275

Streaming result without result throw "Current position is before the first row"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.4.0, 1.4.1
    • 1.4.2
    • Other
    • None

    Description

      message from Huber Greg Huber
      Hello,
      I am using quartz scheduler and get this error when upgrading to 1.4. (1.3.7 works OK). Any ideas?
      2016-04-07 14:38:40,946 ERROR org.quartz.core.ErrorLogger ErrorLogger:schedulerError - An error occurred while scanning for the next triggers to fire.
      org.quartz.JobPersistenceException: Couldn't acquire next trigger: Current position is before the first row
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2860) ~[quartz-2.2.2.jar:?]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759) ~[quartz-2.2.2.jar:?]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757) ~[quartz-2.2.2.jar:?]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3799) ~[quartz-2.2.2.jar:?]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756) ~[quartz-2.2.2.jar:?]
      at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272) [quartz-2.2.2.jar:?]
      Caused by: java.sql.SQLDataException: Current position is before the first row
      at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:115) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.throwError(MariaSelectResultSet.java:553) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.checkObjectRange(MariaSelectResultSet.java:536) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getString(MariaSelectResultSet.java:811) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getString(MariaSelectResultSet.java:819) ~[mariadb-java-client-1.4.0.jar:?]
      at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) ~[commons-dbcp-1.4.jar:1.4]
      at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) ~[commons-dbcp-1.4.jar:1.4]
      at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2616) ~[quartz-2.2.2.jar:?]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2800) ~[quartz-2.2.2.jar:?]
      ... 5 more
      Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Current position is before the first row
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.throwError(MariaSelectResultSet.java:553) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.checkObjectRange(MariaSelectResultSet.java:536) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getString(MariaSelectResultSet.java:811) ~[mariadb-java-client-1.4.0.jar:?]
      at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getString(MariaSelectResultSet.java:819) ~[mariadb-java-client-1.4.0.jar:?]
      at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) ~[commons-dbcp-1.4.jar:1.4]
      at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) ~[commons-dbcp-1.4.jar:1.4]
      at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2616) ~[quartz-2.2.2.jar:?]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2800) ~[quartz-2.2.2.jar:?]
      ... 5 more

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.