Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 93077 invoked from network); 3 May 2004 16:06:09 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 3 May 2004 16:06:09 -0000 Received: (qmail 37739 invoked by uid 500); 3 May 2004 16:05:59 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 37619 invoked by uid 500); 3 May 2004 16:05:59 -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 40896 invoked from network); 3 May 2004 15:26:20 -0000 Message-Id: <200405031526.i43FQLj6026852@thor.exolution.de> To: torque-user@db.apache.org Subject: DB2 and big VARCHARS From: Martin Monsorno Date: Mon, 03 May 2004 17:24:50 +0200 User-Agent: Gnus/5.110002 (No Gnus v0.2) XEmacs/21.4 (Portable Code, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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 Hi *, after trying to run my app with DB2, the following error occured in target insert-sql: ... [torque-sql-exec] Failed to execute: CREATE TABLE Item ( Id INTEGER NOT NULL, SequentialNumber INTEGER NOT NULL, Heading VARCHAR (255), Duration INTEGER, MeetingId INTEGER NOT NULL, ProcessId INTEGER NOT NULL, Entry VARCHAR (8000) ) [torque-sql-exec] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL0286N A default table space could not be found with a page size of at least "16384" that authorization ID "MONSORNO" is authorized to use. SQLSTATE=42727 ... The problem is the VARCHAR(8000) column, one must administrate seperate TABLESPACES in DB2 to use VARCHARS of this size. Does Torque support anything according to this stuff? Or must I maintain sql scripts for DB2 and all other databases? -- Martin --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org