Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 59002 invoked from network); 19 Nov 2007 12:11:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Nov 2007 12:11:57 -0000 Received: (qmail 53876 invoked by uid 500); 19 Nov 2007 12:11:43 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 53552 invoked by uid 500); 19 Nov 2007 12:11:42 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 53541 invoked by uid 99); 19 Nov 2007 12:11:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Nov 2007 04:11:42 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of eljotpl@gmail.com designates 209.85.146.183 as permitted sender) Received: from [209.85.146.183] (HELO wa-out-1112.google.com) (209.85.146.183) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Nov 2007 12:11:29 +0000 Received: by wa-out-1112.google.com with SMTP id j4so2124612wah for ; Mon, 19 Nov 2007 04:11:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; bh=Vl17teMqujYyvJJmS7KAAsYKBaCGFLliItsLc6HXz9c=; b=j8YyPJuDlHN4K+pPOuJWNydaRK/YnNKuGKJTtP4UBcyK/AC0jG8JAm4XwYolfdwQJ00oEMKID/lAsk1ijOxsxY+0vYPQdJQx2iTa2o0nxVx5Q2phRnCfjg5PzfUOem/Zhd5yZ7zW0fZztsEtrXYGoLmT9NPeS5olbjg4gG0hHKU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=ewvlJ4vq6kGe8QFYdoKsbGspDYULObG83npmu2hMGCKS92fpVYPVSbxl+kZjcWW/dcxk7sv/tNa6BQ8WUmzHfYt/M9vgcjdsDBZds8ALYoMawEajEJws5M5/fGd4PrDHP8e7xR39u7Hk0RwcC15IPyfDmNtbZapUBP3kR5/Uy+8= Received: by 10.114.67.2 with SMTP id p2mr147231waa.1195474282977; Mon, 19 Nov 2007 04:11:22 -0800 (PST) Received: by 10.114.199.10 with HTTP; Mon, 19 Nov 2007 04:11:22 -0800 (PST) Message-ID: <1b5bfeb50711190411i26bf0609re6e1f5e9a5bb9b22@mail.gmail.com> Date: Mon, 19 Nov 2007 13:11:22 +0100 From: "Jacek Laskowski" Reply-To: jacek@laskowski.net.pl Sender: eljotpl@gmail.com To: user@geronimo.apache.org Subject: Re: Booleans in CMP EJB2.1 with Geronimo 2.0.2 and Sql Server In-Reply-To: <13830532.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <13830532.post@talk.nabble.com> X-Google-Sender-Auth: 9d838a89e5f23487 X-Virus-Checked: Checked by ClamAV on apache.org On Nov 19, 2007 10:41 AM, ivanrc wrote: > 10:23:16,453 ERROR [OpenEJB] The bean instances business method encountered > a system exception: Syntax error: Encountered "BIT" at line 1, column 56. > {stmnt 4757738 CREATE TABLE BOOLEAN_TABLE (ID BIGINT NOT NULL, ACTIVE BIT, > PRIMARY KEY (ID))} [code=30000, state=42X01] > > org.apache.openjpa.persistence.PersistenceException: Syntax error: > Encountered "BIT" at line 1, column 56. {stmnt 4757738 CREATE TABLE > BOOLEAN_TABLE (ID BIGINT NOT NULL, ACTIVE BIT, PRIMARY KEY (ID))} > [code=30000, state=42X01] > at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:549) I can't explain it, but I think you'd be better off sending it to openjpa's user mailing list to get additional information on the culprit. I'd bet it won't work with a standalone application with jpa in the outside-the-container mode (RESOURCE_LOCAL and such) either. Jacek -- Jacek Laskowski http://www.JacekLaskowski.pl