From torque-dev-return-3486-apmail-db-torque-dev-archive=db.apache.org@db.apache.org Wed Sep 17 13:11:03 2003 Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 83975 invoked from network); 17 Sep 2003 13:11:03 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 17 Sep 2003 13:11:03 -0000 Received: (qmail 32245 invoked by uid 500); 17 Sep 2003 13:10:58 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 32226 invoked by uid 500); 17 Sep 2003 13:10:58 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 32212 invoked from network); 17 Sep 2003 13:10:58 -0000 Received: from unknown (HELO vp-file.vp) (80.89.236.25) by daedalus.apache.org with SMTP; 17 Sep 2003 13:10:58 -0000 Received: from Mario (vp212.vp [172.16.1.243]) by vp-file.vp (8.12.8/8.12.8) with SMTP id h8HDB259025321 for ; Wed, 17 Sep 2003 15:11:02 +0200 From: "Mario Peters" To: Subject: Enum datatype for mysql database Date: Wed, 17 Sep 2003 15:10:23 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-MailScanner: Found to be clean X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I'm working on a very large project and I'm storing my data in a MySQL database. I'm using Torque 3.1 for easily storing the data. The database has some fields, which have datatype ENUM. On a site on the internet I read that torque isn't able to use this datatype. On another site I found some sourcecode of the following class: org.apache.torque.engine.database.transform; .... // special case for MySQL ENUM's which are stupid anyway 441 // and not properly handled by Torque. 442 if (columnType.toUpperCase().equals("ENUM")) 443 { .... What does this mean? Does it mean that Torque is able to handle the datatype ENUM for a mysql database? If Torque isn't able to handle the datatype ENUM, is it possible that I add this feature to Torque by my self?? I guess this will be possible, but can someone help me out in which classes I have to add things for using the ENUM datatype. The functionality I would like to add to the ENUM datatype is, that the java sourcecode validates (relying on the values of the column with the enum datatype) the values that a user wants to store in the database. Thanks in advance. Mario Peters mailto:mario.peters@vermogensplanet.nl --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org