You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Shawn Smiley <ss...@yahoo.com> on 2006/03/01 15:16:33 UTC
NullReferenceException during initialization
I've just started a new project that has some very simple data access requirements. I started off by copying my iBatis configuration files from another project that was working into the new project.
Unforutnately I'm getting the following error and just can't put my finger on what is causing it.
UnitTests.DataTests.Find : System.TypeInitializationException : The type initializer for "Data.Dal.PaymentLog" threw an exception.
----> IBatisNet.Common.Exceptions.ConfigurationException :
- The error occurred while loading SqlMap.
- The error occurred in <sqlMap resource="${root}DataMaps/PaymentLog.xml" xmlns="http://ibatis.apache.org/dataMapper" />.
----> System.NullReferenceException : Object reference not set to an instance of an object.
Here is the stack trace:
at Data.Dal.PaymentLog.Find()
at UnitTests.DataTests.Find() in C:\VSProjects\ADDSIntegration\trunk\ADDSintegrationSolution\UnitTests\DataTests.cs:line 36
--TypeInitializationException
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean isCallFromDao)
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(String resource, ConfigureHandler configureDelegate)
at IBatisNet.DataMapper.Mapper.InitMapper()
at IBatisNet.DataMapper.Mapper.Instance()
at Data.Dal.PaymentLog..cctor() in c:\vsprojects\addsintegration\trunk\addsintegrationsolution\data\dal\paymentlog.cs:line 23
--ConfigurationException
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureSqlMap()
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Initialize()
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean isCallFromDao)
The database being connected to is MySQL 5 using the .net Connector 1.0.7 (I've updated the properties.config with the new connector version number).
I've also stripped down my DataMap file to just including the property/field mappings and a single simple select with no parameters.
Any thoughts on what else I should check? My full config files are listed below.
properties.config
============
<?xml version="1.0" encoding="utf-8" ?>
<settings>
<add key="provider" value="MySql" />
<add key="connectionString" value="Persist Security Info=False;Host=localhost;Protocol=tcp;Initial Catalog=AddsAudit;User Id=AddsAudit;password=password;" />
<add key="root" value="" />
</settings>
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="properties.config"/>
<settings>
<setting useStatementNamespaces="false"/>
<setting cacheModelsEnabled="true"/>
</settings>
<database>
<provider name="${provider}"/>
<dataSource name="ADDSLocalDb" connectionString="${connectionString}"/>
</database>
<alias>
<typeAlias alias="PaymentLog" type="Data.Dal.PaymentLog, Data" />
</alias>
<sqlMaps>
<sqlMap resource="${root}DataMaps/PaymentLog.xml" />
</sqlMaps>
</sqlMapConfig>
PaymentLog.xml
=============
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="DAL">
<resultMaps>
<resultMap id="PaymentLogMap" class="PaymentLog">
<result property="AddsConfirmationNumber" column="AddsConfirmationNumber" />
<result property="Amount" column="Amount" />
<result property="EntryDateTime" column="EntryDateTime" />
<result property="FullAccountNumber" column="FullAccountNumber" />
<result property="Id" column="Id" />
<result property="PaymentServiceConfirmationNumber" column="PaymentServiceConfirmationNumber" />
<result property="ShortAccountNumber" column="ShortAccountNumber" />
</resultMap>
</resultMaps>
<statements>
<select id="SelectPaymentLog" resultMap="PaymentLogMap">
SELECT *
FROM PaymentLogs
</select>
</statements>
</sqlMap>
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
Re: NullReferenceException during initialization
Posted by Shawn Smiley <ss...@yahoo.com>.
I was able to track down the cause of this problem. It turned out I missed the xmlns attributes in my sqlMap XML file.
Thanks,
Shawn.
Shawn Smiley <ss...@yahoo.com> wrote: I've just started a new project that has some very simple data access requirements. I started off by copying my iBatis configuration files from another project that was working into the new project.
Unforutnately I'm getting the following error and just can't put my finger on what is causing it.
UnitTests.DataTests.Find : System.TypeInitializationException : The type initializer for "Data.Dal.PaymentLog" threw an exception.
----> IBatisNet.Common.Exceptions.ConfigurationException :
- The error occurred while loading SqlMap.
- The error occurred in <sqlMap resource="${root}DataMaps/PaymentLog.xml" xmlns="http://ibatis.apache.org/dataMapper" />.
----> System.NullReferenceException : Object reference not set to an instance of an object.
Here is the stack trace:
at Data.Dal.PaymentLog.Find()
at UnitTests.DataTests.Find() in C:\VSProjects\ADDSIntegration\trunk\ADDSintegrationSolution\UnitTests\DataTests.cs:line 36
--TypeInitializationException
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean isCallFromDao)
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(String resource, ConfigureHandler configureDelegate)
at IBatisNet.DataMapper.Mapper.InitMapper()
at IBatisNet.DataMapper.Mapper.Instance()
at Data.Dal.PaymentLog..cctor() in c:\vsprojects\addsintegration\trunk\addsintegrationsolution\data\dal\paymentlog.cs:line 23
--ConfigurationException
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureSqlMap()
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Initialize()
at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocumen t document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean isCallFromDao)
The database being connected to is MySQL 5 using the .net Connector 1.0.7 (I've updated the properties.config with the new connector version number).
I've also stripped down my DataMap file to just including the property/field mappings and a single simple select with no parameters.
Any thoughts on what else I should check? My full config files are listed below.
properties.config
============
<?xml version="1.0" encoding="utf-8" ?>
<settings>
<add key="provider" value="MySql" />
<add key="connectionString" value="Persist Security Info=False;Host=localhost;Protocol=tcp;Initial Catalog=AddsAudit;User Id=AddsAudit;password=password;" />
<add key="root" value="" />
</settings>
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="properties.config"/>
<settings>
<setting useStatementNamespaces="false"/>
<setting cacheModelsEnabled="true"/>
</settings>
<database>
<provider name="${provider}"/>
<dataSource name="ADDSLocalDb" connectionString="${connectionString}"/>
</database>
<alias>
<typeAlias alias="PaymentLog" type="Data.Dal.PaymentLog, Data" />
</alias>
<sqlMaps>
<sqlMap resource="${root}DataMaps/PaymentLog.xml" />
</sqlMaps>
</sqlMapConfig>
PaymentLog.xml
=============
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="DAL">
<resultMaps>
<resultMap id="PaymentLogMap" class="PaymentLog">
<result property="AddsConfirmationNumber" column="AddsConfirmationNumber" />
<result property="Amount" column="Amount" />
<result property="EntryDateTime" column="EntryDateTime" />
<result property="FullAccountNumber" column="FullAccountNumber" />
<result property="Id" column="Id" />
<result property="PaymentServiceConfirmationNumber" column="PaymentServiceConfirmationNumber" />
<result property="ShortAccountNumber" column="ShortAccountNumber" />
</resultMap>
</resultMaps>
<statements>
<select id="SelectPaymentLog" resultMap="PaymentLogMap">
SELECT *
FROM PaymentLogs
</select>
</statements>
</sqlMap>
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.