Add domain fails for oracle table name with underscore

[puneet.garg]

Hi,

I have installed jasperreports-server-5.1. I have added a oracle datasource which username is abc_xyz when I try to create domain I am only able to explore table columns which has single word i.e. abc_xyz_project

It's failing for abc_xyz_project_detail

Is there any issue either with username contains underscore or with table name which contains underscore?

Can someone help me to resolve this issue?

-Puneet

[baumgarogmail.com]

in webapps/jasperserver/WEB-INF/flows/reportDataSourceBeans.xml

edit this line:

    <entry key="dbName">                    <value><![CDATA[^[p{L}p{M}p{N}s.,-}{]+$]]></value>    </entry>[/code]

to:

 <entry key="dbName"><value><![CDATA[^[p{L}p{M}p{N}p{Pc}s.,-}{]+$]]></value>  </entry>[/code]

 

 

you can do this with the other entries in the same area in this file as well:

* dbHost

* sName

* ..

After editing this - I could enter in the database name, though there is another bug with autocompleting the database url. For this you probably should edit some java code.

Workaround: configure a JNDI Datasource:

http://community.jaspersoft.com/wiki/data-source-troubleshooting

[puneet.garg]

Above solution did not work for me. I am not able to expand tables in domain designer.