Return-Path: Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org Received: (qmail 36975 invoked from network); 29 Sep 2006 10:14:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Sep 2006 10:14:31 -0000 Received: (qmail 39370 invoked by uid 500); 29 Sep 2006 10:14:31 -0000 Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org Received: (qmail 39354 invoked by uid 500); 29 Sep 2006 10:14:30 -0000 Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-cs@ibatis.apache.org Delivered-To: mailing list user-cs@ibatis.apache.org Received: (qmail 39333 invoked by uid 99); 29 Sep 2006 10:14:30 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Sep 2006 03:14:30 -0700 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=HTML_MESSAGE,MSGID_FROM_MTA_HEADER Received: from [202.162.198.50] ([202.162.198.50:51076] helo=mail.dayamega.com) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id 7D/70-11690-DF1FC154 for ; Fri, 29 Sep 2006 03:14:29 -0700 Message-ID: <7D.70.11690.DF1FC154@idunn.apache.osuosl.org> Received: (qmail 7731 invoked from network); 29 Sep 2006 17:14:16 +0700 Received: from minhui.dayamega.com (HELO MinHui) (192.168.3.30) by 0 with SMTP; 29 Sep 2006 17:14:16 +0700 From: "Min Hui" To: Subject: RE: PostgreSQL 8.1 Date: Fri, 29 Sep 2006 17:14:13 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C6E3EA.AFC47CA0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: Thread-Index: AcbjqyPIkjohpEo5QICEGuN7gZFlsQABF+kg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C6E3EA.AFC47CA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello all, Regarding the PostgreSQL, I have tried with simple query but got this error: An unhandled exception of type 'IBatisNet.Common.Exceptions.ConfigurationException' occurred in ibatisnet.datamapper.dll Additional information: - The error occurred while loading Providers. - initialize provider - Check the Npgsql. Here are the config files: Providers.config: Sqlmap.config: Please let me know if I missed anything or do we need to add the Npgsql.dll to project's references? Thanks in advance for any help. Regards, Min Hui _____ From: Min Hui [mailto:minhui@dayamega.com] Sent: Friday, September 29, 2006 4:39 PM To: 'user-cs@ibatis.apache.org' Subject: PostgreSQL 8.1 Hello everybody, Is the latest Ibatis.NET supported PostgreSQL version 8.1? Thanks, Min Hui ------=_NextPart_000_0003_01C6E3EA.AFC47CA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

Hello = all,

 

Regarding the PostgreSQL, I have = tried with simple query but got this error:

 

= An unhandled exception of type 'IBatisNet.Common.Exceptions.ConfigurationException' occurred in ibatisnet.datamapper.dll

=  

= Additional information:

= - The error occurred while loading Providers.

= - initialize provider 

= - Check the Npgsql.

 

 

Here are the config = files:

 

Providers.config:<= /font>

<?xml version=3D"1.0" encoding=3D"utf-8" ?>

<providers><= /font>

      =       = <clear/>

      =       <provider

      =             &= nbsp;     = name=3D"Npgsql"

      =             &= nbsp;     = enabled=3D"true"

      =             &= nbsp;     assemblyName=3D"Npgsql, Version=3D0.6.0.0, Culture=3Dneutral, = PublicKeyToken=3D5d8b90d52f46fda7"

      =             &= nbsp;     = connectionClass=3D"Npgsql.NpgsqlConnection"

      =             &= nbsp;     = commandClass=3D"Npgsql.NpgsqlCommand"<= /p>

      =             &= nbsp;     = parameterClass=3D"Npgsql.NpgsqlParameter"

      =             &= nbsp;     = parameterDbTypeClass=3D"System.Data.DbType"

      =             &= nbsp;     = parameterDbTypeProperty=3D"DbType"

=

      =             &= nbsp;     = dataAdapterClass=3D"Npgsql.NpgsqlDataAdapter"=

      =             &= nbsp;     = commandBuilderClass=3D"Npgsql.NpgsqlCommandBuilder"<= /span>

      =             &= nbsp;     usePositionalParameters =3D = "false"         &n= bsp;

      =             &= nbsp;     useParameterPrefixInSql =3D "true"

      =             &= nbsp;     useParameterPrefixInParameter =3D = "true"         &nb= sp;           &nbs= p;            = ;   

      =             &= nbsp;     = parameterPrefix=3D":"

      =       />

</providers>=

 

 

Sqlmap.config:

 

<?xml version=3D"1.0" encoding=3D"utf-8"?>

<sqlMapConfig xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =

      =       = xsi:noNamespaceSchemaLocation=3D"SqlMapConfig.xsd">

      =      

      =       = <settings>

      =             &= nbsp;     <setting useStatementNamespaces=3D"false"/><= /p>

      =             &= nbsp;     <setting cacheModelsEnabled=3D"true"/>

      =       = </settings>

      =             &= nbsp;           &n= bsp;    

      =       <!-- =3D=3D=3D=3D SqlClient configuration = =3D=3D=3D=3D=3D=3D=3D=3D=3D      = -->

      =       <!-- Optional ( default ) -->

      =       <!-- Rem : If used with a Dao it will be ignored = -->

      =       = <database>

      =             &= nbsp;     <provider name=3D"Npgsql"/>

      =             &= nbsp;     <dataSource name=3D"iBatisTest1" = connectionString=3D"Server=3Dlocalhost;Port=3D5432;User Id=3Dsa;Password=3D123;Database=3Dmydb"/>

      =       = </database>

 

      =       = <sqlMaps>

      =             &= nbsp;     <sqlMap resource=3D"Maps/Person.xml"/>

      =       = </sqlMaps>

      =      

</sqlMapConfig>

 

 

Please let me know if I missed = anything or do we need to add the Npgsql.dll to project’s = references?

 

Thanks in advance for any = help.

 

 

Regards,

Min = Hui

 

From: Min = Hui [mailto:minhui@dayamega.com]
Sent: Friday, September = 29, 2006 4:39 PM
To: 'user-cs@ibatis.apache.org'
Subject: PostgreSQL = 8.1

 

Hello everybody,

 

Is the latest Ibatis.NET supported PostgreSQL version = 8.1?

 

 

Thanks,

Min Hui

------=_NextPart_000_0003_01C6E3EA.AFC47CA0--