Return-Path: Delivered-To: apmail-james-server-user-archive@www.apache.org Received: (qmail 62516 invoked from network); 11 Jan 2011 16:09:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Jan 2011 16:09:42 -0000 Received: (qmail 65771 invoked by uid 500); 11 Jan 2011 16:09:42 -0000 Delivered-To: apmail-james-server-user-archive@james.apache.org Received: (qmail 65128 invoked by uid 500); 11 Jan 2011 16:09:39 -0000 Mailing-List: contact server-user-help@james.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "James Users List" Reply-To: "James Users List" Delivered-To: mailing list server-user@james.apache.org Received: (qmail 42392 invoked by uid 99); 11 Jan 2011 14:53:52 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of alaos@interia.pl designates 213.25.80.2 as permitted sender) Date: Tue, 11 Jan 2011 15:53:23 +0100 From: Marcin =?UTF-8?b?S2llxIc=?= Subject: James 3.0-M3. Does not support OracleDB. ORA-00910: specified length too long for its datatype To: server-user@james.apache.org X-Mailer: interia.pl/pf09 X-Originating-IP: 80.52.191.226 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-EMID: b1da9b8c X-Virus-Checked: Checked by ClamAV on apache.org After setting db properties to oracle I get ORA-exception: 1. ORA-00910: specified length too long for its datatype while executing statement: CREATE TABLE Header (id NUMBER NOT NULL, field VARCHAR2(1024), lineNumber NUMBER, value VARCHAR2(10240), MESSAGE_ID NUMBER, PRIMARY KEY (id)) Reason: max length of VARCHAR2 in Oracle is 4000 (length in definition of column value is set to 10240). Only BLOB/CLOB can hold data that exceeds 4000B size. 2. After createing table Header by my self in database I get another error while starting James server: ORA-00904: invalid identifier while executing statement: CREATE TABLE Membership (mailboxId NUMBER NOT NULL, uid NUMBER NOT NULL, answered NUMBER, deleted NUMBER, draft NUMBER, flagged NUMBER, internalDate TIMESTAMP, recent NUMBER, seen NUMBER, MESSAGE_ID NUMBER, PRIMARY KEY (mailboxId, uid)) Reason: uid is reserved identifier in oracle and cannot be used as a column name. Is there any way to run James with persistance in Oracle DB? Best regards Marcin ---------------------------------------------------------------- Auta nowe i używane, duże i małe - największa baza! Sprawdź >> http://linkint.pl/f28df --------------------------------------------------------------------- To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org For additional commands, e-mail: server-user-help@james.apache.org