On 09/03/12 04:15, Mark Roth wrote:
I've filed issue JENA-219 to track this.
https://issues.apache.org/jira/browse/JENA-219
I also have a patch that fixes it. Will post once it's cleaned up a bit.
Excellent news.
Which version of SDB are you using?
Andy
- Mark
From: Mark Roth
Sent: Thursday, March 08, 2012 5:28 PM
To: '[email protected]'
Subject: SDB - Microsoft SQL Server support? But what about LIMIT and OFFSET?
According to [1], SDB supports Microsoft SQL Server. However, when I follow the
instructions and run the test suite, all the Slice tests fail with
com.hp.hpl.jena.sdb.test.junit.QueryTestSDB: "SQLException in executing SQL
statement". When I debug further, I see that this is because SQL statements are
being executed with LIMIT and OFFSET keywords, which are not supported by Microsoft SQL
Server (OFFSET is coming in SQL Server 2012, though). I checked the code and I'm not sure
how this would have ever worked with Microsoft SQL Server.
Is this database engine really supported? How important are the "Slice" tests
to the functionality of the server? Is there a way to switch off functionality such that
LIMIT and OFFSET queries are never sent to the DB server?
It's relatively easy to patch the code to use "SELECT TOP" instead of "LIMIT" but to replace
"OFFSET" with something like "SELECT ROW_NUMBER() ..." requires that there is a consistent ordering
of the rows so I don't see an easy patch. I'd be willing to work on one if someone gave me some direction of what
needed to be patched.
Thanks,
- Mark
[1] http://incubator.apache.org/jena/documentation/sdb/databases_supported.html
