lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romi <romijain3...@gmail.com>
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:
<dataConfig>
    <dataSource type="JdbcDataSource" driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://192.168.1.9:3306/angara" user="root" password="ampliflex"
/>
    <document>
         <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"/>

          </entity>
    </document>
</dataConfig>


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


-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/fetch-whole-data-from-a-database-table-in-to-solr-tp2961195p2961195.html
Sent from the Lucene - General mailing list archive at Nabble.com.

Mime
View raw message