Hi Marcin,
That's really good news :)
If the database schema is created, James should run fine.
To further test, you will need to define a domain and a user via a jmx
client (jconsole,...).
Tks for your feedback,
- Eric
On 17/02/2011 20:55, Marcin Kieć wrote:
Eric
I have downloaded current installation package of server and
successfully run it with Oracle DB. Server has started up without
problems and without any customization. I have checked database
structure in Oracle DB - everything seems to be ok.
Unfortunately I have no time to check if it works fine - I will check
it next week and I will report results to forum.
Best regards
Marcin Kieć
W dniu 2011-01-25 15:42, Eric Charles pisze:
Hi Marcin,
You can build james server from source
(http://james.apache.org/server/3/dev-build.html) - your svn checkout
will be anonymous, more on
http://www.apache.org/dev/version-control.html)
You can simply download a binary build from
http://people.apache.org/builds/james/nightly/ that will redirect you
to
https://repository.apache.org/content/groups/snapshots/org/apache/james/james-server-container-spring/3.0-M3-SNAPSHOT/
yes, curious to know if it's working with oracle...
tks,
-eric
On 25/01/2011 15:24, Marcin Kieć wrote:
Eric
I've tried to test new DB model on Oracle but I can't get source
codes from SVN. I tried do download source code from:
http://svn.apache.org/repos/james/mailbox - is this correct url? I
there any authentication required for checkout? PS: I don't have a
developer account. Is there any release that contains this patch?
Tks,
Marcin
On 2011-01-14 13:41, Eric Charles wrote:
Same here, but it's sometimes handy to overwrite annotations.
I just committed http://svn.apache.org/viewvc?rev=1058984&view=rev
: you can use the jpa-mappings.xml to redefine the HEADER_VALUE
column from 4000 (defined by annotation) to 8000.
I think we meet the database vendors requirements, having a base
working for all, being updated if needed by James Administrator.
Tks,
Eric
On 11/01/2011 19:40, Norman Maurer wrote:
I'm still no fan of xml files for JPA.. but maybe thats just me
Bye,
Norman
2011/1/11 Eric Charles<[email protected]>:
Yes, we can do that, with default being "do not trim".
We can also add some xml mapping files with overrides that column
with
default value 4000, so administrator can change easily change it for
database which support it (see also
https://issues.apache.org/jira/browse/IMAP-233).
Tks,
Eric
On 11/01/2011 18:56, Norman Maurer wrote:
what about making it configurable ?
Bye,
Norman
2011/1/11 Eric Charles<[email protected]>:
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]
---------------------------------------------------------------------
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]
----------------------------------------------------------------
Walenty rozdaje prezenty! Co minute inny prezent!
SprawdĹş >> http://linkint.pl/f28f8
---------------------------------------------------------------------
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]
