Return-Path: 
 <dev-return-65156-apmail-lucene-dev-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-dev-archive@www.apache.org
Received: (qmail 76106 invoked from network); 18 Feb 2011 19:47:06 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 18 Feb 2011 19:47:06 -0000
Received: (qmail 84471 invoked by uid 500); 18 Feb 2011 19:47:05 -0000
Delivered-To: apmail-lucene-dev-archive@lucene.apache.org
Received: (qmail 82815 invoked by uid 500); 18 Feb 2011 19:47:02 -0000
Mailing-List: contact dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@lucene.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@lucene.apache.org>
List-Post: <mailto:dev@lucene.apache.org>
List-Id: <dev.lucene.apache.org>
Reply-To: dev@lucene.apache.org
Delivered-To: mailing list dev@lucene.apache.org
Received: (qmail 82575 invoked by uid 99); 18 Feb 2011 19:46:59 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Feb 2011 19:46:59 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED,T_RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Feb 2011 19:46:58 +0000
Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116])
	by hel.zones.apache.org (Postfix) with ESMTP id 75C34198309
	for <dev@lucene.apache.org>; Fri, 18 Feb 2011 19:46:38 +0000 (UTC)
Date: Fri, 18 Feb 2011 19:46:38 +0000 (UTC)
From: "Bill Bell (JIRA)" <jira@apache.org>
To: dev@lucene.apache.org
Message-ID: 
 <493307673.1815.1298058398478.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] Commented: (SOLR-2376) Stored Proc not working with SQL
 Server
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


    [ https://issues.apache.org/jira/browse/SOLR-2376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12996578#comment-12996578 ] 

Bill Bell commented on SOLR-2376:
---------------------------------

As the same user I call -

exec ERMart1.Facility.spuFacilityIndexTest

And I get results in SQL Server 2008.

> Stored Proc not working with SQL Server
> ---------------------------------------
>
>                 Key: SOLR-2376
>                 URL: https://issues.apache.org/jira/browse/SOLR-2376
>             Project: Solr
>          Issue Type: Bug
>          Components: contrib - DataImportHandler
>    Affects Versions: 4.0
>            Reporter: Bill Bell
>
> Using JDBC Driver v3 from Microsoft. SOLR Trunk.
> Here is an example that does not work.
> <entity name="item" threads="4" transformer="RegexTransformer" pk="id" 
>                  query="{call ERMart1.Facility.spuFacilityIndexTest}"
> CREATE PROCEDURE [Facility].[spuFacilityIndexTest]
> AS
>       SELECT top 10 *
>       from vwuFacilityIndex
>       insert into Facility.SolrTest
>       select GETDATE()
>       
> GO
> I call the full index, and I get:
> - <lst name="statusMessages">
>   <str name="Total Requests made to DataSource">0</str> 
>   <str name="Total Rows Fetched">0</str> 
>   <str name="Total Documents Skipped">0</str> 
>   <str name="Full Dump Started">2011-02-18 12:40:02</str> 
>   <str name="">Indexing completed. Added/Updated: 0 documents. Deleted 0 documents.</str> 
>   <str name="Committed">2011-02-18 12:40:02</str> 
>   <str name="Optimized">2011-02-18 12:40:02</str> 
>   <str name="Total Documents Processed">0</str> 
>   <str name="Time taken">0:0:0.51</str> 
>   </lst>

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org