#43 Database select processor always return empty result set

[Anonymous]

I'm using 2.1 snapshot from svn

when trying to make SELECT query, i always get empty result set

i figured out that it happens because DbRowVariable.isEmpty() erroneously always returns true

[Piotr Dyraga]

I tried to reproduce this issue on the release-2.1 branch, but it seems that everything works fine. I used the following sample configuration:

<config xmlns="http://web-harvest.sourceforge.net/schema/2.1/core"
            xmlns:var="http://web-harvest.sourceforge.net/schema/2.1/var"
            xmlns:p="http://web-harvest.sourceforge.net/schema/2.1/param">

      <set var="response">
        <database connection="jdbc:mysql://localhost:3306/testdb" 
          jdbcclass="com.mysql.jdbc.Driver" 
          username="dbuser" 
          password="dbpassword">
            select title from  VIEW_mytable LIMIT 5;
        </database>
      </set>

    </config>

Currently, we are working on 2.1 version - it is hard to anticipate release date, but you can use snapshot version from maven central if you wish. Also, current 2.1 snapshot code is available under release-2.1 branch (we had to do some reorganization in repo)

• status: open --> closed
• assigned_to: Piotr Dyraga