The default SQLAttributeFilter in OpenIG doesn’t handle result sets very well: it doesn’t allow to browse the results in any direction.

To workaround this problem, simply modify the following line in the SQLFilter source code, this way:

PreparedStatement ps = c.prepareStatement(preparedStatement,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

The original code lies below:

PreparedStatement ps = c.prepareStatement(preparedStatement);

See this URL for full details ..

Les derniers articles par janua (tout voir)