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<[email protected]>:
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
