james-server-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Norman Maurer <nor...@apache.org>
Subject Re: James 3.0-M3. Does not support OracleDB. ORA-00910: specified length too long for its datatype
Date Tue, 11 Jan 2011 17:56:06 GMT
what about making it configurable ?

Bye,
Norman

2011/1/11 Eric Charles <eric@apache.org>:
> VARCHAR for searches must remain.
> But persist trimed values sounds strange to me: it's like having untrue
> information...
> It may be better than failing to persist in database, I don't know.
>
> Tks,
> Eric
>
>
> On 11/01/2011 18:24, Norman Maurer wrote:
>>
>> We need to use VARCHAR if we want to optimize search queries later and
>> filter on header names / values..
>>
>> Maybe using 4000 would be the best and just "trim" down the header
>> value if we need to..
>>
>> wdyt ?
>>
>> Norman
>>
>> 2011/1/11 Eric Charles<eric@apache.org>:
>>>
>>> Hi,
>>>
>>> We are working right-now to fix the DB column names (see
>>> https://issues.apache.org/jira/browse/MAILBOX-14).
>>>
>>> 1. Column of type VARCHAR was OK on MySQL and Derby for length 10240.
>>> Could
>>> you advice us another type, so we could fix it via JPA annotations. From
>>> the
>>> message, it seems we should go to BLOB/CLOB. Another option would be to
>>> lower 10240 to 4000: I remember we took a security margin for very large
>>> headers but 4000 could fit that margin...
>>>
>>> 2. It should be soon resolved cause with the proposed patch (not-yet in
>>> trunk), we prefix tables and columns with context. For example uid column
>>> will be MAIL_UID.
>>>
>>> Running James with Oracle DB is of course a top priority, so your
>>> feedbacks
>>> will be very helpful.
>>>
>>> Tks,
>>>
>>> Eric
>>>
>>>
>>> On 11/01/2011 15:53, Marcin Kieć wrote:
>>>>
>>>> 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
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> For additional commands, e-mail: server-user-help@james.apache.org
>>>
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


Mime
View raw message