Re: [Adding] Entities when indexing a DB

2010-12-15 Thread Adam Estrada
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 ;-)



  
  

  
  
  
  
  
  
  



  
  
  
  
  
  
  

  


Solr Rocks!
Adam



On Wed, Dec 15, 2010 at 3:53 PM, Allistair Crossley 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?
> >
> > 
> > 
> >   >   driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> >   url="jdbc:sqlserver://10.0.2.93;databaseName="50_DEV"
> >   user="adam"
> >   password="password"/>
> >  
> > >query = "SELECT IdMission AS id,
> >CoreGroup AS cat,
> >StrMissionname AS subject,
> >strDescription AS description,
> >DateCreated AS pubdate
> >FROM dbo.tblMission">
> >  
> >  
> >  
> >  
> >  
> >
> > > query = "SELECT strsubject AS subject,
> >strsummary as description,
> >datecreated as date,
> >CoreGroup as cat,
> >idevent as id
> >FROM dbo.tblEvent">
> >  
> >  
> >  
> >  
> >  
> >
> >  
> > 
>
>


Re: [Adding] Entities when indexing a DB

2010-12-15 Thread Allistair Crossley
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?
> 
> 
> 
> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>   url="jdbc:sqlserver://10.0.2.93;databaseName="50_DEV"
>   user="adam"
>   password="password"/>
>  
>query = "SELECT IdMission AS id,
>CoreGroup AS cat,
>StrMissionname AS subject,
>strDescription AS description,
>DateCreated AS pubdate
>FROM dbo.tblMission">
>  
>  
>  
>  
>  
>
> query = "SELECT strsubject AS subject,
>strsummary as description,
>datecreated as date,
>CoreGroup as cat,
>idevent as id
>FROM dbo.tblEvent">
>  
>  
>  
>  
>  
>
>  
> 



[Adding] Entities when indexing a DB

2010-12-15 Thread Adam Estrada
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?