Mailing-List: contact jena-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jena-dev@incubator.apache.org
Date: Mon, 12 Mar 2012 22:02:40 +0000 (UTC)
From: "Mark Roth (Updated) (JIRA)" <jira@apache.org>
To: jena-dev@incubator.apache.org
Message-ID: 
 <396101704.5042.1331589760430.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1024403705.42194.1331266338888.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (JENA-219) SDB does not pass slice tests on
 Microsoft SQL Server
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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