On 5 June 2012 08:26, Rafael Taboada <kaliman.fore...@gmail.com> wrote:
> Hi Gora.
>
> My apologizes for this subject. It wasn't my intention to be rude or
> something like that.
No need to apologize. I was hoping to make it easier
for people to help you.
> As I said about mapping database columns with solr fields, it works in
> mysql. Maybe I'm wrong with some config file because I'm new with Solr. By
> the way, it is a great product.
>
> But I've just tried about sub-entities using mysql. And all work perfect.
> It shows me that I am doing something wrong with Oracle database at work.
>
> I attach with this mail files I used with mysql. Mapping columns is OK,
> sub-entities is OK.
[...]
Your configuration files look fine. It would seem that something
is going wrong with the SELECT in Oracle, or with the JDBC
driver used to access Oracle. Could you try:
* Manually doing the SELECT for the entity, and sub-entity
to ensure that things are working.
* Check the JDBC settings.
Sorry, I do not have access to Oracle so that I cannot try this
out myself.
Also, have you checked the Solr logs for any error messages?
Finally, I just noticed that you have extra quotes in:
...where usuario_idusuario = '${usuario.idusuario}'"
I doubt that is the cause of your problem, but you could try
removing them.
Regards,
Gora
