<settings>
<setting useStatementNamespaces="false"/>
<setting cacheModelsEnabled="true"/>
<setting validateSqlMap="false"/>
</settings>
<providers resource="providers.config"/>
<!-- Database connection information -->
<database>
<!--<provider name="oracleClient1.0"/>
<dataSource name="iBatisNet" connectionString="Data
Source=ora8;User Id=tqjxh;Password=tqjxh"/>-->
<provider name="sqlServer2.0"/>
<dataSource name="test" connectionString="data
source=192.168.0.197;database=test;user id=sa;password=;connection
reset=true;connection lifetime=0; min pool size=1; max pool size=5000"
/>
</database>
<sqlMaps>
<sqlMap resource="test.xml" />
</sqlMaps>
</sqlMapConfig>
prividers.config 文件是从网站上下的
程序文件:
namespace ConsoleApplication1
{
class Program
{
protected static ISqlMapper sqlMap = null;
static void Main(string[] args)
{
DomSqlMapBuilder builder = new DomSqlMapBuilder();
string fileName = "SqlMap.config";
try
{
sqlMap = builder.Configure(fileName);
Console.WriteLine("Database is Connected!");
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace.ToString());
Console.ReadLine();
}
}
}
}
数据库 test
数据表 test(cola int,colb int)
我下载了最新的IBatisNet.DataAccess 1.8.1和IBatisNet.DataMapper
1.5.1,在连接sql2000数据库的时候总是提示SqlMap.config文件配置有错误, 不知道怎么解决,希望高手看看。最好是有连接oracle8.1.7或者oracle92的配置例子
我的SqlMap.config 文件:
<?xml version="1.0" encoding="utf-8"?>
<sqlMapConfig
xmlns="http://ibatis.apache.org/dataMapper "
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<!--<properties resource="DataBase.config"/>-->
<settings>
<setting useStatementNamespaces="false"/>
<setting cacheModelsEnabled="true"/>
<setting validateSqlMap="false"/>
</settings>
<providers resource=" providers.config"/>
<!-- Database connection information -->
<database>
<!--<provider name="oracleClient1.0"/>
<dataSource name="iBatisNet" connectionString="Data
Source=ora8;User Id=tqjxh;Password=tqjxh"/>-->
<provider name="sqlServer2.0"/>
<dataSource name="test" connectionString="data
source= 192.168.0.197;database=test;user id=sa;password=;connection
reset=true;connection lifetime=0; min pool size=1; max pool size=5000"
/>
</database>
<sqlMaps>
<sqlMap resource=" test.xml" />
</sqlMaps>
</sqlMapConfig>
prividers.config 文件是从网站上下的
程序文件:
namespace ConsoleApplication1
{
class Program
{
protected static ISqlMapper sqlMap = null;
static void Main(string[] args)
{
DomSqlMapBuilder builder = new DomSqlMapBuilder();
string fileName = "SqlMap.config";
try
{
sqlMap = builder.Configure(fileName);
Console.WriteLine("Database is Connected!");
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace.ToString());
Console.ReadLine();
}
}
}
}
数据库 test
数据表 test(cola int,colb int)
--
科宇软件工作室:本工作室致力于企业级应用软件的开发和
致力于各种有商业价值的DotNet软件中文化,及使得其方便开发编程及使用.
Url: http://www.keyusoft.cn