You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jena.apache.org by "Mark Roth (Created) (JIRA)" <ji...@apache.org> on 2012/03/09 05:12:18 UTC
[jira] [Created] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
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
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
[jira] [Resolved] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rob Vesse resolved JENA-219.
----------------------------
Resolution: Fixed
Fix Version/s: SDB 1.3.4
Patch was applied a couple of days ago as previously commented
> 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
[jira] [Closed] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rob Vesse closed JENA-219.
--------------------------
> 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
[jira] [Assigned] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rob Vesse reassigned JENA-219:
------------------------------
Assignee: Rob Vesse
> 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
>
> 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
[jira] [Commented] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Mark Roth (Commented) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13229297#comment-13229297 ]
Rob Vesse commented on JENA-219:
--------------------------------
Will test and confirm later this week
> 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
[jira] [Commented] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13232410#comment-13232410 ]
Rob Vesse commented on JENA-219:
--------------------------------
Verified and applied, will leave this open for a couple of days in case this impacts anybody using other databases (which it shouldn't AFAICT)
> 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
[jira] [Commented] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Mark Roth (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13225825#comment-13225825 ]
Mark Roth commented on JENA-219:
--------------------------------
I have a patch that fixes this issue - will post once the patch is cleaned up.
> 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
>
> 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
[jira] [Commented] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13225887#comment-13225887 ]
Rob Vesse commented on JENA-219:
--------------------------------
Ok, I have both SQL Server 2005 and 2008 so will test and verify once you post the patch
> 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
>
> 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
[jira] [Updated] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Mark Roth (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JENA-219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark Roth updated JENA-219:
---------------------------
Attachment: JENA-219.patch
This patch resolves this issue - all manifest tests pass. Please confirm.
> 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
[jira] [Commented] (JENA-219) SDB does not pass slice tests on
Microsoft SQL Server
Posted by "Rob Vesse (Commented) (JIRA)" <ji...@apache.org>.
[ 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