Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-2376

Stored Proc not working with SQL Server

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 4.0-ALPHA
    • None
    • 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>

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              billnbell Bill Bell
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: