...
b) Open the design file which you want to deploy and then click on publish button
| |
|
|
c) Following The following screen will open .Enter the credentials and select the location on server to deploy the file.
...
c) Increase the active connections value in:
Panel |
---|
C:\Program Files\Pentaho\biserver-ce\tomcat\webapps\pentaho\META-INF\context.xml |
...
Increase the max active connection value.
Code Block |
---|
INSERT INTO DATASOURCE VALUES('SampleData',500,'org.hsqldb.jdbcDriver',5,'pentaho_user','cGFzc3dvcmQ=','jdbc:hsqldb:hsql://localhost:9001/sampledata','select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES',1000); |
e) If nothing works then the final solution is to add all your subreport queries in the main report connection only, and inherit them in your sub-reports correspondingly.
...
Code Block |
---|
mifos_kmbi/type=javax.sql.DataSource mifos_kmbi/driver=com.mysql.jdbc.Driver mifos_kmbi/user=root mifos_kmbi/password=mysql mifos_kmbi/url=jdbc:mysql://localhost:3309/kmbi_mifos_testing_2?holdResultsOpenOverStatementClose=true |
So mifos_kmbi in as shown above, will be the name of your JNDI connection which you will simply mention in your design file.
...