Hi,

 

Am hoping to show management here the way that XPages can connect to a MySQL database to do searching, etc. I've setup the MySQL JDBC driver and installed it, created the .jdbc file in the WebContent/WEB-INF/jdbc folder. Next I created a new XPage with a view panel. Problem is, for the query I'm getting the same row repeated over and over, where I know if i run the query elsewhere it returns 1 result. Below is the source for the view panel.

 

<xp:viewPanel rows="30" id="viewPanel1" viewStyle="width:90%">
        <xp:this.facets>
            <xp:pager partialRefresh="true" layout="Previous Group Next"
                xp:key="headerPager" id="pager1">
            </xp:pager>
        </xp:this.facets>
        <xp:this.data>
            <xe:jdbcQuery var="view1" calculateCount="false"
                connectionName="NatCowDB" defaultOrderBy="Animals_NationalID">
                <xe:this.sqlQuery><![CDATA[SELECT Animals_NationalID, Animals_InternatID, Cows_Shortname, Cows_Longname, Animals_Herdbook, Animals_BreedS, Animals_Birth, Animals_sireID,Animals_damID,Animals_MGSID 
FROM animals,cows, herds 
WHERE cows_id = animals_id AND animals_hideflag = 0 AND cows_hideflag = 0
AND Animals_NationalID="Y100R0023" and Cows_Longname="GALLRAE PLANET BONNIE 773"]]></xe:this.sqlQuery>
            </xe:jdbcQuery>
        </xp:this.data>

 

(PS i know I the query should use parameters instead of plugging the and conditions directly into the string, but this is a test only and will do so when I have this working). Below is a partial screen shot of the results

 

And it goes on and on. I can't spot anything obvious, not sure what could be the cause  Thanks for any suggestions.

 

Regards,

 

Cameron