Solved

IBatis, XML file

Posted on 2006-11-20
5
1,459 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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Suggested Solutions

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

830 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