Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

IBatis, XML file

Posted on 2006-11-20
5
Medium Priority
?
1,623 Views
Last Modified: 2012-06-27
Hi experts,
I am using Ibatis for Database management and VS:2005(ASP.Net 2.0) tool for an app.
when I run my project, there is error from sqlMap.config file:

error:
- The error occurred while Validate SqlMap config.
- The error occurred in <sqlMap embedded="SqlMaps.ProductGroup.xml, DTWR.MarketingCampaign.Data"

Here are files from my project

1. project User Interface: 2 textboxes, 1 button--save items into product group
SqlMap.config file

<?xml version="1.0" encoding="utf-8"?>
<sqlMapConfig
  xmlns="http://ibatis.apache.org/dataMapper"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <settings>
    <setting validateSqlMap="true"/>
  </settings>

  <providers embedded="DTWR.MarketingCampaign.Data.providers.config, DTWR.MarketingCampaign.Data"/>

  <!-- Database connection information -->
  <database>
    <provider name="sqlServer2.0"/>
    <dataSource name="test" connectionString="Data Source=(local);Initial Catalog=test;User ID=sa;Password=01"/>
  </database>

  <sqlMaps>
    <sqlMap embedded="SqlMaps.ProductGroup.xml, DTWR.MarketingCampaign.Data" />
   </sqlMaps>

</sqlMapConfig>

2. project.Domain: productGroup.cs

namespace DTWR.MarketingCampaign.Domain
{
    public class ProductGroup
    {
        public string groupID;
        public string productID;

        public string GroupID
        {
            get { return groupID; }
            set { groupID = value; }
        }

        public string ProductID
        {
            get { return productID; }
            set { productID = value; }
        }
    }
}


3. Project Data: include one .xml file and one .cs file
productGroup.xml
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap>
<alias>
    <typeAlias alias="ProductGroup" type="DTWR.MarketingCampaign.Domain.ProductGroup, DTWR.MarketingCampaign.Domain" />
 </alias>
 
  <parameterMap id="ProductSelection" class="ProductGroup">
    <parameter column="Selection_ID" property="groupID"/>
    <parameter column="Product_ID" property="productID"/>
  </parameterMap>

  <statement id="insertProduct" parameterMap="ProductSelection">
    insert into Product_Selection (Selection_ID, Product_ID) values (#groupID#,#productID#);
  </statement>

</sqlMap>

//////////////
productSelection.cs
using System;
using System.Collections.Generic;
using System.Text;
using DTWR.MarketingCampaign.Domain;
using DTWR.MarketingCampaign.Data;
using IBatisNet.DataMapper;

namespace DTWR.MarketingCampaign.Data.ProductManagementService
{
    public class ProductSelection
    {
        public static ProductGroup insertProduct(DTWR.MarketingCampaign.Domain.ProductGroup pg)
        {
            return Mapper.Instance().Insert("insertProduct", pg) as ProductGroup;
        }
    }
}


4. Project Logic:using System;
using System.Collections.Generic;
using System.Text;
using DTWR.MarketingCampaign.Domain;
using DTWR.MarketingCampaign.Data;
using DTWR.MarketingCampaign.Data.ProductManagementService;

namespace DTWR.MarketingCampaign.BusinessLogic
{
    public class SaveProduct
    {
        public SaveProduct(string gID, string pID)
        {
            DTWR.MarketingCampaign.Domain.ProductGroup newobj = new ProductGroup();
            newobj.groupID = gID;
            newobj.productID = pID;
            DTWR.MarketingCampaign.Data.ProductManagementService.ProductSelection.insertProduct(newobj);
        }
    }
}




0
Comment
Question by:dtwoway
  • 2
5 Comments
 
LVL 1

Expert Comment

by:vihieu
ID: 17992477
Please try
<sqlMaps>
    <sqlMap embedded="Maps.productGroup.xml, DTWR.MarketingCampaign.Data" />
</sqlMaps>

instead of your
<sqlMaps>
    <sqlMap embedded="SqlMaps.ProductGroup.xml, DTWR.MarketingCampaign.Data" />
</sqlMaps>

in SqlMap.config file
0
 

Author Comment

by:dtwoway
ID: 17997160
Hi vihieu,

I tried your comment, it didn't work.
0
 

Author Comment

by:dtwoway
ID: 17997752
Ok,  I already fix the problem. The problem came from .XML file insert into statement. I use  
<generate table="Product_Selection" /> instead of  insert into Product_Selection (Selection_ID, Product_ID) values (#groupID#,#productID#). It works.  But I don't know when i should use insert into statement except "generate table" statement.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 18189456
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question