Return-Path: Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 31745 invoked by uid 500); 30 Jul 2003 14:11:25 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 31635 invoked from network); 30 Jul 2003 14:11:24 -0000 Received: from unknown (HELO ntserver2.informer.co.uk) (194.205.116.254) by daedalus.apache.org with SMTP; 30 Jul 2003 14:11:24 -0000 Message-ID: From: Gerard Airey To: 'Apache Torque Users List' Subject: RE: DB independence with CLOB/BLOB/Binary Date: Wed, 30 Jul 2003 15:06:01 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N I kept things simple by selecting my lowest common character field size (255 char - MS Access) and used a number of these short char fields (f1, f2 ... fn). Create get and set methods in the base subclass that represents the long string. It can concatenate or split the string across the fields as appropriate. Gerard. -----Original Message----- From: Ashley Hayes [mailto:ashley.hayes@macalla.com] Sent: 30 July 2003 12:37 To: Torque-User (E-mail) Subject: DB independence with CLOB/BLOB/Binary I need to store some character data of variable size (max a few KB) in a DB column. The awkward bit is I need it to be as independent as possible from the DB vendor( in that torque will generate the same OM and types regardless of the DB vendor) and have reasonable performance. I've read this mail from Bill Schneider "http://www.mail-archive.com/turbine-torque-user@jakarta.apache.org/msg01497 .html" which gives a few pointers about these types and their storage structure in the DBMS. We are currently developing/testing with Oracle 8.1.7,mysql and mssql. I'd be interested in hearing from people that have done something similar, could you include the torque type used, the DB vender(+ version) and the driver version. much appreciated, Ashley --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org