Return-Path: 
 <solr-user-return-40629-apmail-lucene-solr-user-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org
Received: (qmail 78093 invoked from network); 6 Sep 2010 13:49:45 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 6 Sep 2010 13:49:45 -0000
Received: (qmail 78851 invoked by uid 500); 6 Sep 2010 13:49:43 -0000
Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org
Received: (qmail 78646 invoked by uid 500); 6 Sep 2010 13:49:40 -0000
Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:solr-user-help@lucene.apache.org>
List-Unsubscribe: <mailto:solr-user-unsubscribe@lucene.apache.org>
List-Post: <mailto:solr-user@lucene.apache.org>
List-Id: <solr-user.lucene.apache.org>
Reply-To: solr-user@lucene.apache.org
Delivered-To: mailing list solr-user@lucene.apache.org
Received: (qmail 78631 invoked by uid 99); 6 Sep 2010 13:49:39 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Sep 2010 13:49:39 +0000
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=FREEMAIL_FROM,NORMAL_HTTP_TO_IP,SPF_HELO_PASS,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX,WEIRD_PORT
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: 216.139.236.158 is neither permitted
 nor denied by domain of savvas.andreas.moysidis@googlemail.com)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Sep 2010 13:49:33 +0000
Received: from ben.nabble.com ([192.168.236.152])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <savvas.andreas.moysidis@googlemail.com>)
	id 1Osc4O-0004tT-Ip
	for solr-user@lucene.apache.org; Mon, 06 Sep 2010 06:49:12 -0700
Date: Mon, 6 Sep 2010 06:49:12 -0700 (PDT)
From: "savvas.andreas" <savvas.andreas.moysidis@googlemail.com>
To: solr-user@lucene.apache.org
Message-ID: <1283780952578-1426473.post@n3.nabble.com>
Subject: Solr is indexing jdbc properties
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hello,

I am trying to index some data stored in an SQL Server database through DIH.
My setup in data-config.xml is the following:

<dataConfig>
  <dataSource type="JdbcDataSource" 
			  name="mssqlDatasource"
              driver="net.sourceforge.jtds.jdbc.Driver"
             
url="jdbc:jtds:sqlserver://{db.host}:1433/{db};instance=SQLEXPRESS" 
              user="{username}" 
              password="{password}"/>
  <document>
    <entity name="id"
			dataSource="mssqlDatasource"
            query="select id,
			title 
			from WORK">
			<field column="id" name="id" />
			<field column="title" name="title" />
    </entity>
  </document>
</dataConfig>

However, when I run the indexer (invoking
http://127.0.0.1:8983/solr/admin/dataimport.jsp?handler=/dataimport) I get
all the rows in my index but with incorrect data indexed.

More specifically, by examining the top 10 terms for the title field I get:

term	frequency
impl	1241371
jdbc	1241371
net	1241371
sourceforg	1241371
jtds	1241371
clob	1241371
netsourceforgejtdsjdbcclobimpl	1186981
c	185070
a	179901
e	160759

which is clearly wrong..Does anybody know why Solr is indexing the jdbc
properties instead of the actual data?

Any pointers would be much appreciated.

Thank you very much.
-- Savvas
-- 
View this message in context: http://lucene.472066.n3.nabble.com/Solr-is-indexing-jdbc-properties-tp1426473p1426473.html
Sent from the Solr - User mailing list archive at Nabble.com.