Return-Path: X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 90F7810503 for ; Wed, 12 Jun 2013 21:38:00 +0000 (UTC) Received: (qmail 87881 invoked by uid 500); 12 Jun 2013 21:37:57 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 87826 invoked by uid 500); 12 Jun 2013 21:37:57 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 87817 invoked by uid 99); 12 Jun 2013 21:37:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Jun 2013 21:37:57 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=FORGED_YAHOO_RCVD,URI_HEX X-Spam-Check-By: apache.org Received-SPF: error (athena.apache.org: local policy) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Jun 2013 21:37:52 +0000 Received: from ben.nabble.com ([192.168.236.152]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1UmsjA-0007si-4e for solr-user@lucene.apache.org; Wed, 12 Jun 2013 14:37:12 -0700 Date: Wed, 12 Jun 2013 14:37:12 -0700 (PDT) From: srinalluri To: solr-user@lucene.apache.org Message-ID: <1371073032131-4070059.post@n3.nabble.com> In-Reply-To: <8F0D0142CA7ECC4287A9EC1BD8CB880C1A08064841@USLVDCMBVP01.ingramcontent.com> References: <1367253647648-4059815.post@n3.nabble.com> <8F0D0142CA7ECC4287A9EC1BD8CB880C1A07EAC51D@USLVDCMBVP01.ingramcontent.com> <1367337206680-4060043.post@n3.nabble.com> <8F0D0142CA7ECC4287A9EC1BD8CB880C1A08064841@USLVDCMBVP01.ingramcontent.com> Subject: RE: java.lang.NullPointerException. I am trying to use CachedSqlEntityProcessor MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I have solved this problem and able work with CachedSqlEntityProcessor successfully after a very long struggle. I tried this on 4.2. There are still existing bugs it seems: 1. What ever you mention in cacheKey, that field name must in the select statement explicitly. 2. If I am correct, the field name in cacheKey and in the select statement are case sensitive. 3. We have ID field in our table, I tried to give cacheKey="ID". But that got conflicted with the uniqueKey as uniqueKey is also "ID". So I wrote it as "SELECT ID AS AID,....." and cacheKey="AID" thanks Srini -- View this message in context: http://lucene.472066.n3.nabble.com/java-lang-NullPointerException-I-am-trying-to-use-CachedSqlEntityProcessor-tp4059815p4070059.html Sent from the Solr - User mailing list archive at Nabble.com.