[
https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13231427#comment-13231427
]
Rob Vesse commented on JENA-219:
--------------------------------
What environment did you run the tests in?
I got the patches applied fine but I have been unable to test so far because
our corporate network is so locked down I can't access the SQL Server instances
on my local VM (we run OS X as our main OS) or on the remote servers to which I
have access.
This means I will probably not get to test till the weekend when I have time to
test at home and can freely expose my SQL Server instances
> 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
> 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
