Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 72438 invoked from network); 5 Aug 2004 09:34:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 5 Aug 2004 09:34:13 -0000 Received: (qmail 48640 invoked by uid 500); 5 Aug 2004 09:34:12 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 48408 invoked by uid 500); 5 Aug 2004 09:34:11 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 48395 invoked by uid 99); 5 Aug 2004 09:34:11 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from [194.95.168.2] (HELO prosun.first.fraunhofer.de) (194.95.168.2) by apache.org (qpsmtpd/0.27.1) with ESMTP; Thu, 05 Aug 2004 02:34:08 -0700 Received: from [194.95.170.251] (barney [194.95.170.251]) by prosun.first.fraunhofer.de (8.12.10/8.12.10) with ESMTP id i759Y54q003666 for ; Thu, 5 Aug 2004 11:34:06 +0200 (MEST) Message-ID: <4111FEDA.7070807@first.fhg.de> Date: Thu, 05 Aug 2004 11:33:14 +0200 From: Thomas Dudziak User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Developers List Subject: Re: Please test the new commons-sql dbhandling References: <410963CE.9030001@first.fhg.de> <4111EECB.4000106@apache.org> <4111FAE0.90407@apache.org> In-Reply-To: <4111FAE0.90407@apache.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Armin Waibel wrote: > Here a comparision between the valid torque commands and dbhandling: > > Torque: > ------------------------------------- > drop table NESTED_FIELDS_ENTRY cascade ; > > CREATE TABLE NESTED_FIELDS_ENTRY > ( > OBJ_ID INTEGER NOT NULL, > FK_ID DECIMAL (15,0) NOT NULL, > NAME VARCHAR (150) > ); > > ALTER TABLE NESTED_FIELDS_ENTRY > ADD PRIMARY KEY (OBJ_ID) ; > ------------------------------------- > > dbhandling: > ------------------------------------- > CREATE TABLE NESTED_FIELDS_ENTRY > ( > OBJ_ID INTEGER NOT NULL, > FK_ID DECIMAL (15,0) NOT NULL, > NAME VARCHAR (150) UNICODE, > PRIMARY KEY (OBJ_ID) > ) failed 222): Reserved identifier not allowed:INTEGER>com.sap.dbtech.jdbc > DatabaseException: [-7006] (at 222): Reserved identifier not > allowed:INTEGER > at > com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:71) > > .... > > Think the problem is the 'UNICODE' setting in all VARCHAR columns. > If I do > > CREATE TABLE NESTED_FIELDS_ENTRY > ( > OBJ_ID INTEGER NOT NULL, > FK_ID DECIMAL (15,0) NOT NULL, > NAME VARCHAR (150), > PRIMARY KEY (OBJ_ID) > ) > > the table will be created. Interesting. The MaxDB spec says that this way of specifying a VARCHAR column is valid: http://dev.mysql.com/doc/maxdb/en/d0/763898d21c11d2a97400a0c9449261/content.htm And why it is complaining about the INTEGER column then, is beyond me :-) Tom --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org