Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 93834 invoked from network); 27 Sep 2007 14:23:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 27 Sep 2007 14:23:42 -0000 Received: (qmail 39261 invoked by uid 500); 27 Sep 2007 14:23:32 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 38961 invoked by uid 500); 27 Sep 2007 14:23:31 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 38950 invoked by uid 99); 27 Sep 2007 14:23:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Sep 2007 07:23:31 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Sep 2007 14:25:52 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IauGk-0002v0-DX for derby-user@db.apache.org; Thu, 27 Sep 2007 07:23:10 -0700 Message-ID: <12922366.post@talk.nabble.com> Date: Thu, 27 Sep 2007 07:23:10 -0700 (PDT) From: "Patrick Sp." To: derby-user@db.apache.org Subject: Generic data types MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: patspringer2007@gmail.com X-Virus-Checked: Checked by ClamAV on apache.org Hello, I am developing a java application that can store and retrieve data define= d by the following schema CREATE TABLE Tag as ( =09TagGroup varchar(100), =09TagValue varchar(64), //which data type??? ); However, in practice, the 'TagValue' may be of different data types (float, varchar, int, etc). The right data type is known only at runtime. My question is, how to declare 'TagValue' so it can be cast -in the java application- to one of the data types supported by Derby? and then inserted in the database in the right format? Thanks for your answer. --=20 =D0=BF=D0=BE =D0=BA=D1=80=D0=B0=D1=8F=D0=BC --=20 View this message in context: http://www.nabble.com/Generic-data-types-tf45= 28719.html#a12922366 Sent from the Apache Derby Users mailing list archive at Nabble.com.