elessargng
01-07-2009, 05:20 AM
I had problems using pentaho with oracle:
Once the report is done, when I execute it, I see the rows of the report, but the columns has no data.
In the console I can read that the system could not find the query parameters:
f.e.
select id as asdf from <table_name>
I can see a message like(this is not the exact):
Could not find asdf in the DataSource.
the reason is that ORACLE Driver returns the DataSource with the name "ASDF" instead of "asdf", so I had to remake it.
I think this can be avoideable using a case unsensitive friend names in the query resoults :)
Once the report is done, when I execute it, I see the rows of the report, but the columns has no data.
In the console I can read that the system could not find the query parameters:
f.e.
select id as asdf from <table_name>
I can see a message like(this is not the exact):
Could not find asdf in the DataSource.
the reason is that ORACLE Driver returns the DataSource with the name "ASDF" instead of "asdf", so I had to remake it.
I think this can be avoideable using a case unsensitive friend names in the query resoults :)