Hello! I setup my stuff with IBATIS to get the stuff from SQL Server using the Stored Proc. Here is my SqlMap.xml:
<?xml version="1.0" encoding="utf-8" ?> <sqlMap namespace="Person" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="SqlMap.xsd"> <!-- XML "behind" document for the People service class. --> <alias> <typeAlias alias="Publishers" type="IbatisBuraq.WebFace-SQL.Publishers" /> </alias> <resultMaps> <resultMap id="SelectSPResult" class="Publishers"> <result property="Name" column="Name" /> <result property="CompanyName" column="CompanyName" /> <result property="Address" column="Address" /> <result property="City" column="City" /> <result property="State" column="State" /> </resultMap> </resultMaps> <procedure id="la_GetPublisher" parameterMap = "get-publisher-param"></procedure> <parameterMap id="get-publisher-param" class=paramClass> <parameter property="paramCity" column="City"/> </parameterMap> </sqlMap> Over here i have a query , where should I tell the name of Stored Proc name that is in my DB? And is that SQL Map file is okay? Take Care, Mudassir -- Mudassir San Jose,CA -------------------------------------------------------------------------------------------------------------------------- Hope is a good thing, maybe the best of things, and no good thing ever dies. - The Shawshank Redemption (Movie)
