Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 57379 invoked from network); 8 Jul 2005 18:19:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 8 Jul 2005 18:19:11 -0000 Received: (qmail 85760 invoked by uid 500); 8 Jul 2005 18:19:08 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 85728 invoked by uid 500); 8 Jul 2005 18:19:08 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 85714 invoked by uid 99); 8 Jul 2005 18:19:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Jul 2005 11:19:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of dremesh@gmail.com designates 64.233.184.203 as permitted sender) Received: from [64.233.184.203] (HELO wproxy.gmail.com) (64.233.184.203) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Jul 2005 11:19:07 -0700 Received: by wproxy.gmail.com with SMTP id i1so518658wra for ; Fri, 08 Jul 2005 11:19:06 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=S+dMmss0UlzoJAVSWaCSANIbapLqK8FYgh8jd1ISzoAQ5LvurYQaY2ColSpxwUQ2GP3oPyKxDBMnDrlydf7oaHMUa19YIT+tSNvZBE9CWW9nv4Q9uemhMPxNVZ+g+Xmurk5/vE0ld5B/PMmsVhWo1Rs/alnwn0ECYbcDGnbPTdQ= Received: by 10.54.47.44 with SMTP id u44mr1786974wru; Fri, 08 Jul 2005 11:18:40 -0700 (PDT) Received: by 10.54.11.9 with HTTP; Fri, 8 Jul 2005 11:18:40 -0700 (PDT) Message-ID: <58ed70f505070811182b7669d6@mail.gmail.com> Date: Fri, 8 Jul 2005 11:18:40 -0700 From: Deepa Remesh Reply-To: Deepa Remesh To: derby-dev@db.apache.org Subject: Import/Export and getObject() for DECIMAL type in J2ME/Foundation Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I have some questions on this subject. 1. Derby Embedded JSR 169 Functional Spec mentions "Embedded (derby.jar), sysinfo, dblook, and ij (derbytools.jar) will be modified to work under JSR169 on J2ME/CDC/Foundation (Foundation)." Does this mean that import/export is not currently supported? 2. I think the import/export has problems in Foundation only when there is a column with DECIMAL type. I tried running the testcase importExport.java and it fails with following exception: ERROR 38000: The exception 'SQL Exception: An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'.' was thrown while evaluating an expression. ERROR 22005: An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. This is expected since the system procedure for export calls getObject() on a DECIMAL type and this is not supported. Derby Embedded JSR 169 Functional Spec asks to use alternate JDBC getXXX and setXXX methods (like getString and setString) for DECIMAL type. Can Derby import/export utility be modified to call getString and setString for DECIMAL type when using Foundation? 3. To run testcases for DECIMAL types in Foundation, can getString and setString be used instead of getObject and setObject? Thanks, Deepa