Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 89221 invoked from network); 9 Feb 2006 21:24:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Feb 2006 21:24:19 -0000 Received: (qmail 67725 invoked by uid 500); 9 Feb 2006 21:24:09 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 67280 invoked by uid 500); 9 Feb 2006 21:24:08 -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 67269 invoked by uid 99); 9 Feb 2006 21:24:07 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Feb 2006 13:24:07 -0800 X-ASF-Spam-Status: No, hits=1.4 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: 66.210.59.101 is neither permitted nor denied by domain of bryan@blackboard.com) Received: from [66.210.59.101] (HELO rock.az.Blackboard.com) (66.210.59.101) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Feb 2006 13:24:06 -0800 Received: from pima.az.Blackboard.com ([10.20.2.183]) by rock.az.Blackboard.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 9 Feb 2006 14:23:43 -0700 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C62DBF.1AD54E5D" Subject: iBatis Conversion of java Type String to Numeric database field Date: Thu, 9 Feb 2006 14:23:43 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: iBatis Conversion of java Type String to Numeric database field thread-index: AcYtvxpNaPmuMSJSQK6OHDECJyV4Yw== From: "Brent Ryan" To: X-OriginalArrivalTime: 09 Feb 2006 21:23:43.0999 (UTC) FILETIME=[1AE708F0:01C62DBF] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C62DBF.1AD54E5D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable If I have a java bean that contains only String data types, is there a way to have iBatis insert/update rows in the database that have a data type of 'Numeric'? =20 For Example... I read in a string of data from a text file, create my bean, then call my iBatis service to insert the row of data into the database. However, the database has a numeric data type for some of the fields. Can iBatis handle this? I don't want my bean to have int, Date or other data types because then I have to figure that out during the read of this text file. I just want to treat everything as a String. =20 I know that if you do this in Hibernate that it knows how to insert the String into a numeric data field. However, Hibernates performance is bad when I'm trying to insert 1 million rows of data into a single table so I can't use it. I need to use straight JDBC or iBatis possibly.... =20 Thanks, Brent BbWorld '06 New Client-Centered Program, Peers Aplenty, Party on Deck San Diego, CA February 28-March 2, 2006 Register today! Visit: http://www.blackboard.com/company/events/bbworld/ = to learn more. This e-mail is intended only for the personal and confidential use of = the recipient(s) named above.=20 It may include Blackboard confidential and proprietary information, and = is not for redistribution. ------_=_NextPart_001_01C62DBF.1AD54E5D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
If I = have a java=20 bean that contains only String data types, is there a way to have iBatis = insert/update rows in the database that have a data type of=20 'Numeric'?
 
For = Example... I=20 read in a string of data from a text file, create my bean, then call my = iBatis=20 service to insert the row of data into the database.  However, the = database=20 has a numeric data type for some of the fields.  Can iBatis handle=20 this?  I don't want my bean to have int, Date or other data types = because=20 then I have to figure that out during the read of this text file.  = I just=20 want to treat everything as a String.
 
I know = that if you=20 do this in Hibernate that it knows how to insert the String into a = numeric data=20 field.  However, Hibernates performance is bad when I'm trying to = insert 1=20 million rows of data into a single table so I can't use it.  I need = to use=20 straight JDBC or iBatis possibly....
 
Thanks,
Brent

BbWorld '06

New Client-Centered Program, Peers Aplenty, Party on = Deck

San = Diego, = CA February 28-March 2, = 2006

Register today! Visit: = http://www.bla= ckboard.com/company/events/bbworld/ to learn = more.

This e-mail is intended only for the personal and = confidential use of the recipient(s) named above.
It may include = Blackboard confidential and proprietary information, and is not for = redistribution.

------_=_NextPart_001_01C62DBF.1AD54E5D--