Re: having trouble storing large text blob fields - returns binary address in search results

2013-05-18 Thread geeky2
hello your comment made me think - so i decided to double check myself. i opened up the schema in squirrel and made sure that the two columns in question were actually of type TEXT in the schema - check i went in to the db-config.xml and removed all references to ClobTransformer, removed the cas

Re: having trouble storing large text blob fields - returns binary address in search results

2013-05-17 Thread Gora Mohanty
On 18 May 2013 02:24, geeky2 wrote: > Hello Gora, > > > thank you for the reply - > > i did finally get this to work. i had to cast the column in the DIH to a > clob - like this. > > cast(att.attr_val AS clob) as attr_val, > cast(rsr.rsr_val AS clob) as rsr_val, > > once this was done, th

Re: having trouble storing large text blob fields - returns binary address in search results

2013-05-17 Thread geeky2
Hello Gora, thank you for the reply - i did finally get this to work. i had to cast the column in the DIH to a clob - like this. cast(att.attr_val AS clob) as attr_val, cast(rsr.rsr_val AS clob) as rsr_val, once this was done, the ClobTransformer worked. to my knowledge - this parti

Re: having trouble storing large text blob fields - returns binary address in search results

2013-05-17 Thread Gora Mohanty
On 17 May 2013 00:02, geeky2 wrote: [...] > i have tried setting them up as clob fields - but this is not working (see > details below) > > i have also tried treating them as plain string fields (removing the > references to clob in the DIH) - but this does not work either. > > > DIH configuration