Add property for sql limit clause

[drungrin]

Hi,

Can you parametrize the "FETCH FIRST 1 ROWS ONLY" of the DAO classes (org.serviio.library.dao) so I can replace it with "LIMIT 1" and my mysql edit works fine?

(I reversed it for my own usage, but I want to pay to use the mobile features and keep it updated).

You can add a property on serviio.properties to use the limit, like (default):

limit_statment=FETCH FIRST %d ROWS ONLY

and I can change to:

limit_statment=LIMIT %d

So I can use viewtopic.php?f=6&t=15531 without reverse engineering.

EDIT: CURRENT TIMESTAMP also should have a property. Updating as I get more issues.

[zip]

please create a ticket on Bitbucket and add all the needed changes there.

[drungrin]

Filled as Issue #750

Working as a charm on my box.