Ahhh...I found that I did not set a dataSource name and when I did that and
then referred each entity to that dataSource all went according to plan ;-)
<?xml version="1.0" encoding="utf-8" ?>
<dataConfig>
<dataSource type="JdbcDataSource"
name="bleh"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://<server>;databaseName=50_DEV"
user="adam"
password="pw"/>
<document>
<entity name="Missions" dataSource="bleh"
query = "SELECT (IdMission + 1000000) AS id,
idMission as missionid,
CoreGroup AS cat,
StrMissionname AS subject,
strDescription AS description,
DateCreated AS pubdate,
'Mission' AS cat2
FROM dbo.tblMission">
<field column="id" name="id" />
<field column="missionid" name="missionid" />
<field column="cat" name="cat" />
<field column="cat2" name="cat2" />
<field column="subject" name="subject" />
<field column="description" name="description" />
<field column="pubdate" name="date" />
</entity>
<entity name="Events" dataSource="bleh"
query = "SELECT strsubject AS subject,
strsummary as description,
datecreated as date,
CoreGroup as cat,
idevent as id,
'Event' AS cat2,
IdEvent AS missionid
FROM dbo.tblEvent">
<field column="id" name="id" />
<field column="missionid" name="missionid" />
<field column="cat" name="cat" />
<field column="cat2" name="cat2" />
<field column="subject" name="subject" />
<field column="description" name="description" />
<field column="pubdate" name="date" />
</entity>
</document>
</dataConfig>
Solr Rocks!
Adam
On Wed, Dec 15, 2010 at 3:53 PM, Allistair Crossley <a...@roxxor.co.uk>wrote:
> mission.id and event.id if the same value will be overwriting the indexed
> document. your ids need to be unique across all documents. i usually have a
> field id_original that i map the table id to, and then for id per entity i
> usually prefix it with the entity name in the value mapped to the schema id
> field
>
> On 15 Dec 2010, at 20:49, Adam Estrada wrote:
>
> > All,
> >
> > I have successfully indexed a single entity but when I try multiple
> entities
> > is the second is skipped all together. Is there something wrong with my
> > config file?
> >
> > <?xml version="1.0" encoding="utf-8" ?>
> > <dataConfig>
> > <dataSource type="JdbcDataSource"
> > driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> > url="jdbc:sqlserver://10.0.2.93;databaseName="50_DEV"
> > user="adam"
> > password="password"/>
> > <document name="events">
> > <entity datasource="MISSIONS"
> > query = "SELECT IdMission AS id,
> > CoreGroup AS cat,
> > StrMissionname AS subject,
> > strDescription AS description,
> > DateCreated AS pubdate
> > FROM dbo.tblMission">
> > <field column="id" name="id" />
> > <field column="cat" name="cat" />
> > <field column="subject" name="subject" />
> > <field column="description" name="description" />
> > <field column="pubdate" name="date" />
> > </entity>
> > <entity datasource="EVENTS"
> > query = "SELECT strsubject AS subject,
> > strsummary as description,
> > datecreated as date,
> > CoreGroup as cat,
> > idevent as id
> > FROM dbo.tblEvent">
> > <field column="id" name="id" />
> > <field column="cat" name="cat" />
> > <field column="subject" name="subject" />
> > <field column="description" name="description" />
> > <field column="pubdate" name="date" />
> > </entity>
> > </document>
> > </dataConfig>
>
>
