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: [email protected]
For additional commands, e-mail: [email protected]
