Using external config files to load jdbc info

DreamCoder

Hello,

I'm looking to create an xml config file kind of like this:

<config>
<instances>
<instance instance_id="0" jdbc_url="jdbc:mysql://192.168.200.226:3306/crm_dev" username="root" password="pw"/>
<instance instance_id="1" jdbc_url="jdbc:mysql://192.168.200.226:3306/crm_main" username="root" password="mainpw"/>
</instances>
</config>

I would like to be able to dynamically configure my Data Source using this config file. So that I could pass a parameter with the instance_id into the report, the report would look at this file, and create the datasource using the jdbc string associated with that instance_id.

Any idea how I could get this to work?

Much appreciated!
Amanda

egau

Hi DreamCoder,<br />
<br />
To see how to write an xml file understable by BIRT, you can try to double click on a data source you've already created, then you go in connection Profile,<br />
then you, and here you enter the location of a file. ( uncheck encrypt if you want to be able to read ) and then you can see how a xml file looks like.<br />
<br />
Or you can just look at this xml : <br />
<br />
<?xml version="1.0" encoding="UTF-8" standalone="no"?><br />
<DataTools.ServerProfiles version="1.0"><br />
<profile autoconnect="No" desc="" id="815e0530-6a64-11de-a0b0-8d3a72e4e1f9" name="New BIRT JDBC Data Source" providerID="org.eclipse.birt.report.data.oda.jdbc"><br />
<br />
<baseproperties><br />
<property name="odaJndiName" value=""/><br />
<property name="odaDriverClass" value="org.eclipse.birt.report.data.oda.sampledb.Driver"/><br />
<property name="odaURL" value="jdbc:classicmodels:sampledb"/> // or 192.168 . . .etc <property name="odaPassword" value=""/><br />
<property name="odaUser" value="root"/><br />
</baseproperties><br />
</profile><br />
</DataTools.ServerProfiles><br />
<br />
<br />
<br />
I don't really know how the "id" variable works, but if you have 2 server, you just have to have 2 different id , i typed "sdfsdf" and it works . . . maybe some people can explain that better than me!<br />
<br />
<br />
After you made your xml file, you just have to create a new data source, but now , you chose "create from a connection profile in profile store" and you take you xml fuile in the browse area. <br />
<br />
You can also use relative path. <br />
<br />
I hope I was clear and I didn't say wrong things!<br />
<br />
egau<br />
<br />
PS : Are you for a IRC BIRT channel during the day, so people can help each other at the speed of light ? If yes , post a message here, I try to motivate as much people as possible to be more efficient during the day ! <br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/forum/designing-birt-reports/15780-irc-birt-channel.html'>http://www.birt-exchange.org/forum/designing-birt-reports/15780-irc-birt-channel.html</a&gt;