Return-Path: X-Original-To: apmail-lucenenet-user-archive@www.apache.org Delivered-To: apmail-lucenenet-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C606710A66 for ; Tue, 12 Nov 2013 06:24:47 +0000 (UTC) Received: (qmail 61297 invoked by uid 500); 12 Nov 2013 06:24:46 -0000 Delivered-To: apmail-lucenenet-user-archive@lucenenet.apache.org Received: (qmail 61275 invoked by uid 500); 12 Nov 2013 06:24:45 -0000 Mailing-List: contact user-help@lucenenet.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@lucenenet.apache.org Delivered-To: mailing list user@lucenenet.apache.org Received: (qmail 61255 invoked by uid 99); 12 Nov 2013 06:24:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Nov 2013 06:24:44 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of anders@lybecker.com designates 209.85.212.48 as permitted sender) Received: from [209.85.212.48] (HELO mail-vb0-f48.google.com) (209.85.212.48) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Nov 2013 06:24:34 +0000 Received: by mail-vb0-f48.google.com with SMTP id m10so1493180vbh.7 for ; Mon, 11 Nov 2013 22:24:13 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=ag/6dSdgsiwZOBg5vVEWIbQCvQCZ8MOJvSanu2sUJ4g=; b=WRJjmmjQx/CRv/eE73OqxEzk6tEVRa2tiheKT6TVfRb9JMg0GqwtjIZCOyFBIBgTnW FaiVfFF1nFhVsqdmYBqkJXM51EJDEU22KLMKyFi0X5JenlwI0UfpVO8hf7r/nGnMA9Rg xJds4iaK3ss9jZIBhVfLiTkr4vH0DzttKHBBHc5ZGH3VnNVLckvFphpIzLwBjvQSEaYX lXR5fOne81j8sFAu1RtCCgH7B+XJkQLzaWbFqnRu8pVx92v4Jfw2RoOZ9tbrG5OOZcSF uqlqwIJDaR01PDYUlLISJaUVB9Al1MT3iw6CLH0nVDyNLwDbcaTVeawK8NrdEFdYKQxq npkQ== X-Gm-Message-State: ALoCoQkzWY7BTlvaesHWUzdft+lh9XGo9wrtimB8cIlI9RkwwR6Fm9TWKkhr9r/Mtpm2JCffP3ro X-Received: by 10.52.37.69 with SMTP id w5mr1055832vdj.32.1384237452622; Mon, 11 Nov 2013 22:24:12 -0800 (PST) MIME-Version: 1.0 Received: by 10.220.124.210 with HTTP; Mon, 11 Nov 2013 22:23:52 -0800 (PST) In-Reply-To: <67D8669FB9D24EF1A62CBBE03B5EEFF6@userPC> References: <67D8669FB9D24EF1A62CBBE03B5EEFF6@userPC> From: Anders Lybecker Date: Tue, 12 Nov 2013 07:23:52 +0100 Message-ID: Subject: Re: Assistance in calling lucene search from SQL Server 2008 trigger To: user@lucenenet.apache.org Content-Type: multipart/alternative; boundary=20cf30780db0a615a304eaf4e59e X-Virus-Checked: Checked by ClamAV on apache.org --20cf30780db0a615a304eaf4e59e Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi, This is not a Lucene.Net issue. You could make a Web API project and call via SQLCLR WebRequest ( http://blogs.msdn.com/b/sqllive/archive/2008/06/18/accessing-rest-based-web= -services-using-sql-clr.aspx ). The architecture you describe is not what I would recommend. If you requirements are fixed, I would rather create a service endpoint that first called the SQL Server and then Lucene. It is a much cleaner solution. Regards, Anders Lybecker On Tue, Nov 12, 2013 at 3:44 AM, Jackson wrote= : > Dear Developers, > > We are new to using Lucene.net. The solution developed required specific > searching of names from 1000=92s of names, which is happening well using = your > developed > Lucene 3.0.3 search engine library. We had tested calling the lucene > search from a aspx page and were very excited with the speed it was getti= ng > the result. > > Our requirement is to call the lucene 3.0.3 search from a database trigge= r > and we are unable to find a solution. If there is a help / link, that cou= ld > be provided > to know how it could be called from the Sql server 2008 database trigger, > we would highly appreciate your support. > > > Best Regards, > > Jackson Vadakkan > SMART Infotech > Post Box 28046, Abu Dhabi, > United Arab Emirates. > Phone : +971-2-6438460 > Mobile : +971-50-7724164 > > DISCLAIMER: This Electronic Mail and any attached information is sent on > behalf of SMART Infotech. The information is confidential and may also be > privileged. It is intended only for the use of authorized persons. > If you are not an addressee, or have received the message in error, you > are not authorized to read, copy, disseminate, distribute or use the > Electronic Mail or any attachment in any way. > Please notify the sender by return E-Mail or over the telephone and delet= e > this e-mail. --20cf30780db0a615a304eaf4e59e--