DATASET import table with wrong names

Hello,

I am importing with sucess a datatable to birt. The problem is that the name of the table show in BIRT are not the names on my Oracle DB, but the field names inside the table are OK and the data also OK. Any ideas?

Example: Datatable name in my database: DEVOLUCOES
Name in dataSet : BIN$Ai2GBCGSDX==$0

In attachment you can see an example. Thank you for ideas

Find more posts tagged with

Comments

bhanley

What character set is your database built on?

alberto

Hi Nuno,

I have the same problem that you.

I need to testing something more, but it is very strange, because I'm working with ACTUATE BIRT and using ACTUATE ORACLE jdbc the connection and the name are fines, but using ORACLE jdbc the visualization is not good.

But, If you write manually the query and put the right name of the table (don´t appear in the visualization), the result of the query is good.

I'm testing it, and I'll comment you something more, but I think that the problem is on the integration between ORACLE driver (ojdbc14.jar).

Alberto.

nuno

hello ALBERTO,

speak portuguesE??
yes...the sql works perfect with the names of the database....i don't get it....but i must say that i had one table that displayed the name good on birt and after some does it just changed to strange characters :S....i could not belive it!

nuno

<blockquote class='ipsBlockquote' data-author="bhanley"><p>What character set is your database built on?</p></blockquote>
<br />
hello bahnley....UTF-8 is the character set