Thanks Ryan for the quick reply and for your contribution to solr. I did write some code to generate a xml document from a sql query (generates a general xml file that with few changes to a properties file will generate a solr add xml document), so I'll use that for the time being.
Maybe we can use the field database type to add a suffix/prefix to the field name and have dynamic fields set. I have posted another question to the group regarding the usage of dynamic fields. It would be useful to have a solr setting for stripping the dynamic field suffix/prefix on index field name to get back the original field name. Does it make sense? Thank you, Debra ryan mckinley wrote: > > SOLR-103 is waiting for SOLR-139 to solidify before i post more updates... > > I have it running successfully, but it requires too many other patches > to suggest trying to get it running unless you are up for a bit of > work. If you are, i can easily post an update. > > About the schema... SOLR-103 uses the ResultSetMetaData to decide what > field to push the value into - you will need to make sure the column > names correspond to the fields in schema.sql. If you use SELECT * > FROM, your tables will need the same names, if you use: SELECT > mysqlfield as mysolrfieldname FROM ... you don't. > > ryan > > > On 3/6/07, Debra <[EMAIL PROTECTED]> wrote: >> >> What is the status of the SQL update? >> Should all database fields used in sql updates be added to schema.xml >> before >> running the sql update? >> >> -- >> View this message in context: >> http://www.nabble.com/SQL-Update-tf3358303.html#a9341018 >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/SQL-Update-tf3358303.html#a9341943 Sent from the Solr - User mailing list archive at Nabble.com.
