We have, as far as I understand, set this up as standard using the datasource IDMRPTCfgDataSource (a local PostgreSQL).
from jboss-web.xml:
--------------------
<jboss-web>
<class-loading java2ClassLoadingCompliance='true'/>
<resource-ref>
<res-ref-name>jdbc/IDMRPTDataSource</res-ref-name>
<jndi-name>java:/IDMRPTDataSource</jndi-name>
</resource-ref>
<resource-ref>
<res-ref-name>jdbc/IDMRPTCfgDataSource</res-ref-name>
<jndi-name>java:/IDMRPTDataSource</jndi-name>
</resource-ref>
</jboss-web>
from server.xml:
--------------------
<Resource auth="Container"
driverClassName="org.postgresql.Driver"
factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory"
initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10"
name="shared/IDMRPTDataSource"
password="obfuscated"
testOnBorrow="true"
type="javax.sql.DataSource"
url="jdbc:postgresql://<server>:<port>/SIEM"
username="idmrptuser"
validationInterval="120000"
validationQuery="SELECT 1" />
where <server> is the localhost fqdn.
Logged in as user idmrptuser in SIEM db, the scchema query yields:
SIEM=> select schema_name from information_schema.schemata;
schema_name
--------------------
pg_catalog
information_schema
idm_rpt_cfg
idm_rpt_data
public
(5 rows)
E.g. I've run the test 'Role Assignments by User'.
I also created a really simple report which I cannot preview in iReport since com.novell.sentinel.content.reports.TemplateReportScriptlet cannot be loaded in the outdated tool.
The preview data in the report query window can execute the query correctly as user idmrptuser.
When importing the query and trying to run it in Identity Reporting, it fails with the exception as mentioned before.
Is there now way to produce a more elaborate error message?
BTW can we use Jaspersoft Studio instead of iReport, since it's quite outdated?
