lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rachun <rachun.c...@gmail.com>
Subject Re: Import data from mysql to sold
Date Tue, 04 Feb 2014 09:58:33 GMT
please see below code..

<dataConfig>
  <dataSource type="JdbcDataSource" 
              driver="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost:3306/mydb01" 
              user="root" 
              password=""/>
  <document>
    <entity name="users" query="select id,firstname,username from users">
        <field column="id" name="user_id" />           
        <field column="firstname" name="user_firstname" />
    </entity> 
  </document>
</dataConfig>

my question is..
1. what is the url for?  (url="jdbc:mysql://localhost:3306/mydb01" )
does it means my database url?

2. did i do it right with this
<field column="id" name="user_id" /> 
i'm not sure name means the field in Solr?


Thank you very much,
Chun.






--
View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-mysql-to-sold-tp4114982p4115191.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message