It did work!! \o/ the admin page had been cached in FF.. Thanks very much Alex.
-- Savvas On 6 September 2010 16:02, Savvas-Andreas Moysidis < savvas.andreas.moysi...@googlemail.com> wrote: > Hi Alex, > > Thanks very much for your reply and pointers. > That didn't work I'm afraid.. > > I'll try to see if sql server supports a conversion function. > > Regards, > -- Savvas > > > On 6 September 2010 15:49, Alexey-34 [via Lucene] < > ml-node+1426936-1702828919-54...@n3.nabble.com<ml-node%2b1426936-1702828919-54...@n3.nabble.com> > > wrote: > >> >> http://wiki.apache.org/solr/DataImportHandlerFaq#Blob_values_in_my_table_are_added_to_the_Solr_document_as_object_strings_like_B.401f23c5 >> >> Try to add convertType attribute to dataSource declaration, i.e. >> <dataSource type="JdbcDataSource" >> name="mssqlDatasource" >> driver="net.sourceforge.jtds.jdbc.Driver" >> url="jdbc:jtds:sqlserver://{db.host}:1433/{db};instance=SQLEXPRESS" >> user="{username}" >> password="{password}" >> >> convertType="true" >> /> >> >> HTH, >> Alex >> >> On Mon, Sep 6, 2010 at 5:49 PM, savvas.andreas >> <[hidden email] <http://user/SendEmail.jtp?type=node&node=1426936&i=0>> >> wrote: >> >> > >> > Hello, >> > >> > I am trying to index some data stored in an SQL Server database through >> DIH. >> > My setup in data-config.xml is the following: >> > >> > <dataConfig> >> > <dataSource type="JdbcDataSource" >> > name="mssqlDatasource" >> > driver="net.sourceforge.jtds.jdbc.Driver" >> > >> > url="jdbc:jtds:sqlserver://{db.host}:1433/{db};instance=SQLEXPRESS" >> > user="{username}" >> > password="{password}"/> >> > <document> >> > <entity name="id" >> > dataSource="mssqlDatasource" >> > query="select id, >> > title >> > from WORK"> >> > <field column="id" name="id" /> >> > <field column="title" name="title" /> >> > </entity> >> > </document> >> > </dataConfig> >> > >> > However, when I run the indexer (invoking >> > http://127.0.0.1:8983/solr/admin/dataimport.jsp?handler=/dataimport) I >> get >> > all the rows in my index but with incorrect data indexed. >> > >> > More specifically, by examining the top 10 terms for the title field I >> get: >> > >> > term frequency >> > impl 1241371 >> > jdbc 1241371 >> > net 1241371 >> > sourceforg 1241371 >> > jtds 1241371 >> > clob 1241371 >> > netsourceforgejtdsjdbcclobimpl 1186981 >> > c 185070 >> > a 179901 >> > e 160759 >> > >> > which is clearly wrong..Does anybody know why Solr is indexing the jdbc >> > properties instead of the actual data? >> > >> > Any pointers would be much appreciated. >> > >> > Thank you very much. >> > -- Savvas >> > -- >> > View this message in context: >> http://lucene.472066.n3.nabble.com/Solr-is-indexing-jdbc-properties-tp1426473p1426473.html<http://lucene.472066.n3.nabble.com/Solr-is-indexing-jdbc-properties-tp1426473p1426473.html?by-user=t> >> > Sent from the Solr - User mailing list archive at Nabble.com. >> > >> >> >> ------------------------------ >> View message @ >> http://lucene.472066.n3.nabble.com/Solr-is-indexing-jdbc-properties-tp1426473p1426936.html >> To unsubscribe from Solr is indexing jdbc properties, click >> here<http://lucene.472066.n3.nabble.com/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=1426473&code=c2F2dmFzLmFuZHJlYXMubW95c2lkaXNAZ29vZ2xlbWFpbC5jb218MTQyNjQ3M3wxMTY1Njc5ODAy>. >> >> >> > -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-is-indexing-jdbc-properties-tp1426473p1427091.html Sent from the Solr - User mailing list archive at Nabble.com.
