Re: Solr - db-data-config.xml general asking to entity

2012-10-14 Thread Lance Norskog
Two answers: 1) Do you have maybe user names or timestamps for the comments? Usually people want those also. 2) You can store the comments as one long string, or as multiple entries in a field. Your database should have a concatenate function that will take field X from multiple documents in a

Re: Solr - db-data-config.xml general asking to entity

2012-10-14 Thread Marvin
Thanks for the response! Its a bad news that it isnt that simple I hoped. Certainly I need names and a timestamp for the comment. There are any problems if I want to add a timestamp in the one long string? Apart from this can I add this one long string to the index? Example: table blog: id,

Solr - db-data-config.xml general asking to entity

2012-10-13 Thread Marvin
Hi there! I have 2 tables 'blog' and 'comment'. A blog can contains n comments (blog --1:n-- comment). Up to date I use following select to insert the data into solr index: entity name=blog dataSource=mssqlDatasource pk=id transformer=ClobTransformer query=SELECT