You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Lixo Aqui <li...@netcabo.pt> on 2013/11/05 20:01:35 UTC
Oracle 'raw' column data type is supported?
I'm using Solr 1.4.1 and I have a table where the join colum is Oracle RAW.Consider the next example and that id is of ORACLE RAW type. Does Solr support this?
<dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/dbname" user="user-name" password="password"/> <document> <entity name="outer" query="select id,name,desc from mytable"> <field column="id" name="solr_id"/> <field column="name" name="solr_name"/> <field column="desc" name="solr_desc"/> <entity name="inner" query="select details from another_table where id ='${outer.id}'"> <field column="details" name="solr_details"/> </entity> </entity> </document></dataConfig>
I tried it and the inner query doesn't work because the value passed is something like '[B@d738a2'. Tipical problem of loading the data with a Byte Array and then doing a .toString() on it.My doubt is if this is a bug on Solr, if it's just not supported or do I need to configure something else.
Thanks in advance