Solr
  1. Solr
  2. SOLR-2376

Stored Proc not working with SQL Server

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 4.0-ALPHA
    • Fix Version/s: None
    • Labels:
      None

      Description

      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>

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Bill Bell
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development