Skip to Content
0
Former Member
Apr 19, 2010 at 03:35 PM

The max number of concurrent reports

53 Views

Hi all,

the runtime environment is:

1) Oracle Database 11.0.6 Enterprise Edition,

2) jBoss Version 4.0.4,

3) OCI driver 11g,

4) crjava-runtime (Java Reporting Component - JRC) Version 11.8.4.1094,

5) Crystal Reports 2008 Versione 12.0.0.63,

6) jdk1.5.0_18

The data source is using in file .rpt is jdbc(JNDI) and the file .rpt not deployed

with the application but are stored in a separate folder /rpt/Area/reportName.rpt.

Below the oracle-ds.xml:

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

<local-tx-datasource>

<jndi-name>jdbc/pippodatasource</jndi-name>

<connection-url>jdbc:oracle:oci:@TEST</connection-url>

<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

<user-name>user</user-name>

<password>password</password>

<min-pool-size>1</min-pool-size>

<max-pool-size>10</max-pool-size>

<idle-timeout-minutes>5</idle-timeout-minutes>

<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

<metadata>

<type-mapping>Oracle9i</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>

I thought that the max number of concurrent reports was the max number of concurrent connection managed by jboss (in my

case the max number of concurrent connection are 10, defined into tag <max-pool-size> of oracle-ds.xml). Monitoring connections I discovered that the connections for Crystal Reports are always two while the application is used more.

My question:

Is it possible to set the number of concurrent reports?

Thanks a lot.