|
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 14:04 |
Ganesh Lawande Messages: 5 Registered: February 2012 |
Junior Member |
|
|
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 08:09] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.01822 seconds