[
https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13235767#comment-13235767
]
Mark Roth commented on JENA-219:
--------------------------------
Excellent! Thanks!
> SDB does not pass slice tests on Microsoft SQL Server
> -----------------------------------------------------
>
> Key: JENA-219
> URL: https://issues.apache.org/jira/browse/JENA-219
> Project: Apache Jena
> Issue Type: Bug
> Components: SDB
> Affects Versions: SDB 1.3.4
> Environment: Microsoft SQL Server 2008
> Reporter: Mark Roth
> Assignee: Rob Vesse
> Fix For: SDB 1.3.4
>
> Attachments: JENA-219.patch
>
>
> 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.
> [1]
> http://incubator.apache.org/jena/documentation/sdb/databases_supported.html
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
