lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romi <>
Subject fetch whole data from a database table in to solr
Date Thu, 19 May 2011 13:07:03 GMT
Hi, i want to fetch all data( all rows and columns) of a table from MySQL
database to solr. how can i achieve this.currently i am able to fetch
specific columns from the database table. 
my db-data-config.xml is:
    <dataSource type="JdbcDataSource" driver=""
url="jdbc:mysql://" user="root" password="ampliflex"
         <entity name="tdiamonds" query="select UID_PK, ProductUID, name,
price,Weight from tdiamonds">

            <field column="UID_PK" name="id"/>
            <field column="ProductUID" name="product_uid"/>
            <field column="name" name="dname"/>
            <field column="price" name="dprice"/>
            <field column="Weight" name="dweight"/>


now i want to know what query syntax i should use so that i can fetch all
data or is it really possible??

View this message in context:
Sent from the Lucene - General mailing list archive at

View raw message