Multiple Sources

Help
Dave Barr
2008-04-02
2013-06-03
  • Dave  Barr

    Dave Barr - 2008-04-02

    Hi everyone, I would like to pull data from 2 mysql databases, has anyone done this?
    This is what my sources look like in my xml file:

    <source>
    <database driverClassName="com.mysql.jdbc.Driver" connInfo="jdbc:mysql://localhost/test" name="test" username="root"></database>
    <database driverClassName="com.mysql.jdbc.Driver" connInfo="jdbc:mysql://localhost/test2" name="test2" username="root"></database>

    <query>
    <join from="test.test.person_id" relation="=" to="test2.test.test2_id"/>
    </query>
    </source>

    everytime i try to run the report from command like i get this output error:

    DataVision v1.1.0
    The column test2.test.test2_id does not exist in the data
    source.(No other missing columns will be reported.)

    Has anyone been able to do this?

    Any help would be greatly appreciated.

    dave

     
    • Jim Menard

      Jim Menard - 2008-04-02

      Dave, you'll probably get more answers if you post your question to the mailing list.

       

Log in to post a comment.