Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 48164 invoked from network); 6 Sep 2006 14:30:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Sep 2006 14:30:01 -0000 Received: (qmail 39112 invoked by uid 500); 6 Sep 2006 14:29:59 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 39099 invoked by uid 500); 6 Sep 2006 14:29:59 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 39088 invoked by uid 99); 6 Sep 2006 14:29:59 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Sep 2006 07:29:59 -0700 X-ASF-Spam-Status: No, hits=1.1 required=10.0 tests=DNS_FROM_RFC_ABUSE,HTML_00_10,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of sanjiv.jivan@gmail.com designates 64.233.184.234 as permitted sender) Received: from [64.233.184.234] (HELO wr-out-0506.google.com) (64.233.184.234) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Sep 2006 07:29:58 -0700 Received: by wr-out-0506.google.com with SMTP id i2so615497wra for ; Wed, 06 Sep 2006 07:29:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=s1XnEDLLsrptzNCIsqnRF7HN7O7cGM5dp6tgToyG6ROcXsEKyDgcY30byah+o4yYm5HL6tVai9XwXvip+re7yXPIVLOxUdFoSR1uFluB3kTK/wcTZdyKajhOn0J6eS0gHYhZFNwcbiktXVvIxPouZjC8X+jomh7CRvyo3m2H6VM= Received: by 10.90.83.14 with SMTP id g14mr2173908agb; Wed, 06 Sep 2006 07:29:37 -0700 (PDT) Received: by 10.90.100.20 with HTTP; Wed, 6 Sep 2006 07:29:37 -0700 (PDT) Message-ID: Date: Wed, 6 Sep 2006 10:29:37 -0400 From: "Sanjiv Jivan" To: user-java@ibatis.apache.org Subject: setting type for nullable columns MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67001_32058107.1157552977384" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_67001_32058107.1157552977384 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline >From the Ibatis doc : "Most drivers only need the type specified for nullable columns. Therefore, for such drivers you only need to specify the type for the columns that are nullable. Note! When using an Oracle driver, you will get an "Invalid column type" error if you attempt to set a null value to a column without specifying its type." Just wondering if Ibatis could infer the type based on the javabean property member type when setting null values instead of requiring the user to specify NUMERIC etc for nullable columns.. Kinda like the shorthand version of select mappings where introspection is used instead of explicit resultMap's Thanks, Sanjiv ------=_Part_67001_32058107.1157552977384 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline >From the Ibatis doc :
"Most drivers only need the type specified for nullable columns. Therefore, for such drivers you only need to specify the type for the columns that are nullable.
Note! When using an Oracle driver, you will get an "Invalid column type" error if you attempt to set a null value to a column without specifying its type."

Just wondering if Ibatis could infer the type based on the javabean property member type when setting null values instead of requiring the user to specify NUMERIC etc for nullable columns.. Kinda like the shorthand version of select mappings where introspection is used instead of explicit resultMap's

Thanks,
Sanjiv
------=_Part_67001_32058107.1157552977384--