[
http://mifosforge.jira.com/browse/MIFOS-5563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=72260#comment-72260
]
johnwoodlock commented on MIFOS-5563:
-------------------------------------
If its any help, for Tomcat 7, for mifos individual lending work (mifos x /
mifos ng / whatever else it might be known as ) Keith W added the following
jndi items for a pentaho reports demo at <GlobalNamingResources> section in
file server.xml
<Resource type="javax.sql.DataSource"
name="jdbc/SourceDB"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifos_test"
username="root"
password="mysql"
initialSize="3"
maxActive="20"
maxIdle="15"
minIdle="3"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;ResetAbandonedTimer"
/>
<Resource type="javax.sql.DataSource"
name="jdbc/DestinationDB"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifos_test_dwh"
username="root"
password="mysql"
initialSize="3"
maxActive="20"
maxIdle="15"
minIdle="3"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;ResetAbandonedTimer"
/>
Also, in src/main/webapp/META-INF/context.xml looked like this (first line with
mifosng in it not relevant for mifos bi reporting):
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<ResourceLink name="jdbc/mifosng" global="jdbc/mifosng"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/SourceDB" global="jdbc/SourceDB"
type="javax.sql.DataSource" />
<ResourceLink name="jdbc/DestinationDB" global="jdbc/DestinationDB"
type="javax.sql.DataSource" />
</Context>
> Set up proper JNDI settings to run Mifos BI report in Mifos
> -----------------------------------------------------------
>
> Key: MIFOS-5563
> URL: http://mifosforge.jira.com/browse/MIFOS-5563
> Project: mifos
> Issue Type: Dev Task
> Components: Reports Module
> Reporter: Ed Cable
> Assignee: Paweł Gesek
> Labels: MifosX, pentaho, reporting
> Fix For: Vinolia I
>
> Original Estimate: 2 days
> Remaining Estimate: 2 days
>
> Pentaho uses JNDI to run. JNDI settings will need to be tweaked to run
> properly in the Jetty web container. Keith W has successfully run it with
> TomCat 7 for Mifos X.
> See: http://sync.in/TmntootfiZ
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://mifosforge.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
