that doesn't matter for solr .. it's just executing your query via jdbc .. so the complete error-message would be intersting. have a look at the error-log of your sql-server too (especially for the timeframe while the dataimport is running)
regards Stefan On Fri, Jul 1, 2011 at 2:52 PM, roySolr <royrutten1...@gmail.com> wrote: > Hello, > > I have made my own sql function(isSoccerClub). In my sql query browser this > works fine. My query looks like: > > select * > from soccer > where isSoccerClub(id,name) = 1; > > Now i try to use this with the DIH. It looks like this: > > <entity name="soccerclubs_entity" query="select * > from soccer > where > isSoccerClub(id,name) = 1"> > </entity> > > Now i get some error with the full-import: Indexing failed. Rolled back all > changes. > > without "where isSoccerClub(id,name) = 1;" it works fine. Does SOLR not > support sql functions(transact-sql)?? > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/SOLR-and-SQL-functions-tp3129175p3129175.html > Sent from the Solr - User mailing list archive at Nabble.com. >
