Eclipse Community Forums: Eclipse Process Manager (Stardust) » How to configure Data Source for Stardust pre-defined reports in Tomcat and MySQL environment

Home » Archived » Eclipse Process Manager (Stardust) » How to configure Data Source for Stardust pre-defined reports in Tomcat and MySQL environment

How to configure Data Source for Stardust pre-defined reports in Tomcat and MySQL environment [message #789016]

Thu, 02 February 2012 09:02

Eclipse User

I am trying to deploy Stardust to Tomcat and MySQL environment and would like to ask you how to DS for configure pre-defined reports in
Tomcat and MySQL environment.

The following is the excerpt of the file.
I think HOME property entry for ag.carnot.oda.processdatabase is fine, but I didn't know what the property value for ag.carnot.oda.processmodel should be. (it has a wrong value...)

<oda-data-source extensionID="ag.carnot.oda.processdatabase" name="CARNOT Process Database" id="6">
<property name="HOME">;;java:/AuditTrail.DataSource;com.mysql.jdbc.Driver;jdbc:mysql://localhost:3306/ipp;ipp;I/M0BgPtZeNWhGFUnu3G1w==;ipp;ag.carnot.reporting.common.calendarBasedWorktimeCalculator;ipp;</property>
</oda-data-source>
<oda-data-source extensionID="ag.carnot.oda.processmodel" name="CARNOT Process Model" id="271">
<property name="HOME">;java:/AuditTrail.DataSource|com.mysql.jdbc.Driver|jdbc:mysql://localhost:3306/ipp|ipp|I/M0BgPtZeNWhGFUnu3G1w==|ipp|ag.carnot.reporting.common.calendarBasedWorktimeCalculator|ipp</property>
</oda-data-source>

Re: How to configure Data Source for Stardust pre-defined reports in Tomcat and MySQL environment [message #789020 is a reply to message #789016]

Thu, 02 February 2012 09:04

Eclipse User

I could get this working with following changes. If need to connect to any other database than MySQL, then use driver name and URL values accordingly.

1. Add the following entry in your tomcat's server.xml.

<Resource type="javax.sql.DataSource" name="AuditTrail.DataSource2"
auth="Container" url="jdbc:mysql://localhost:3306/carnot60[/url]" username="root"
password="root" defaultAutoCommit="false" driverClassName="com.mysql.jdbc.Driver"
maxIdle="10" maxActive="50" maxWait="5000" />

2. Please replace your your CARNOT-ds-library.rptlibrary file with enclosed file. The change is given below; where carnot60 is my schema name, and carnot is db user name and NsT7mq/o6Dg= is hashed password which is "ag"

So if you have username and pwd as carnot/ag, then only change you will need is schema name. Let us know if this works for you.

<data-sources>
<oda-data-source extensionID="ag.carnot.oda.processdatabase" name="CARNOT Process Database" id="6">
<property name="HOME">;;java:comp/env/jdbc/AuditTrail.DataSource2;com.mysql.jdbc.Driver;jdbc:mysql://localhost:3306/carnot60;carnot;NsT7mq/o6Dg=;;;carnot60;</property>
</oda-data-source>
<oda-data-source extensionID="ag.carnot.oda.processmodel" name="CARNOT Process Model" id="271">
<property name="HOME">;java:comp/env/jdbc/AuditTrail.DataSource2|ag.carnot.reporting.worktime.CalendarBasedWorktimeCalculator</property>
</oda-data-source>
<oda-data-source extensionID="ag.carnot.oda.parameters.data.source" name="Parameters DataSource" id="272"/>
</data-sources>

[Updated on: Fri, 03 February 2012 03:09] by Moderator

Previous Topic:	Rollback after ActivityInstanceQuery
Next Topic:	EJB Timer Service is not available when deploying on WAS 7

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 01:06:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter