Npgsql tests were added to SVN recently. Anyway, there was an issue for Npgsql with the sqlParameter.dbType. The issue moved from the place identified in the email to a logging statement after some refactoring done in the last couple of months. It was fixed over the weekend.
Also note that in the code provided, the resultClass is a Hashtable. Npgsql returns the keys in lowercase (vs uppercase for Oracle!) in case you get an issue with the name/key not being found.
Roberto
hi all:
when i run to this,it throw
System.NullReferenceException;
detail is below:
in file
"IBatisNet.DataMapper\MappedStatements\MappedStatement.cs"
// With a ParameterMap, we could specify the
ParameterDbTypeProperty
if (_statement.ParameterMap != null)
{
if
(request.ParameterMap.GetProperty(i).DbType.Length >0)
{
string dbTypePropertyName =
session.DataSource.Provider.ParameterDbTypeProperty ;
ObjectProbe.SetPropertyValue(parameterCopy,
dbTypePropertyName, ObjectProbe.
GetPropertyValue(sqlParameter, dbTypePropertyName));
}
else
{
parameterCopy.DbType =
sqlParameter.DbType;
//throw
System.NullReferenceException
// if i comment
"parameterCopy.DbType = sqlParameter.DbType; ",It is
run right;
// now parameterCopy.DbType
is String
}
}
else
{
parameterCopy.DbType = sqlParameter.
DbType; //System.NullReferenceException
}
Test.xml
<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap namespace="TestPg"
xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="..\..\Nausicaa.Framework.Dal\Schemas\SqlMap.x
sd">
<statements>
<select id="SelectTestPg" resultClass="Hashtable"
parameterClass="Hashtable">
select * from pg_tables
where schemaname=#schema#
</select>
</statements>
</sqlMap>
in file providers.config
added:
<provider
name="PgSql"
description="PostgreSql provider"
enabled="true"
assemblyName="Npgsql, Version=0.7.0.0,
Culture=neutral,
PublicKeyToken="
connectionClass="Npgsql.NpgsqlConnection"
commandClass="Npgsql.NpgsqlCommand"
parameterClass="Npgsql.NpgsqlParameter"
parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType"
parameterDbTypeProperty="NpgsqlDbType"
dataAdapterClass="Npgsql.NpgsqlDataAdapter"
commandBuilderClass="Npgsql.NpgsqlCommandBuilder"
usePositionalParameters = "false"
useParameterPrefixInSql = "true"
useParameterPrefixInParameter =
"true"
parameterPrefix=":"
/>
in file SqlMap.config
<?xml version="1.0" encoding="utf-8"?>
<sqlMapConfig
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="SqlMapConfig.xsd">
<settings>
<setting useStatementNamespaces="false"/>
<setting cacheModelsEnabled="true"/>
</settings>
<database>
<provider name="PgSql"/>
<dataSource name="PgSql"
connectionString="Server=127.0.0.1;Port=5432;User
Id=postgres;Password=postgres;Database=resource"/>
</database>
<sqlMaps>
<sqlMap resource="Maps\Test.xml"/>
</sqlMaps>
</sqlMapConfig>
my software :
winxp + sp2,postgresql 8.01,Npgsql7.0 beta5
ibatis is "iBatisNet-src.458.zip" download from
sourceforge.net
thanks a lot!
