> I basically wanted to use database (MS SQL) for all repositories.
Personally, I would not use it for things like the spam or error
repositories. I use dbfile for the other mail repositories.
> What I noticed was that when I edited config file to have the spool
> repository pointing to my database, an exception occurred on James
> startup, which just said there was an error catching mail in spool.
> This problem disappears when I put spool repository to a file system.
This *MAY* be related to a recent change to support Oracle and DB2. It
looks as if Oracle & DB2 on one side and MSSQL & PostgreSQL on the other,
are not compatible. MySQL has the best implementation of a JDBC driver, as
witnessed by the fact that it just plain works regardless.
Right now, Vincenzo is preparing a patch we've discussed that will allow our
code to be even more flexible with regard to working around database
nuances. He hopes to commit that change on Wednesday (tomorrow), and we'll
be looking for some people to test it almost immediately.
> Also, I had put the local users repository pointing to my database, but
when
> I sent an email, it said that the users' address was wrong(it wasn't).
When
> I pointed the local users repository to the file system, it worked fine.
> After the above tests, I inserted 1000 users into james users table in MS
> SQL. (Not through remote manager). James doesn't seem to recognise that
> these users exist. Do they need to be inserted through Remote Manager
> rather than through a SQL insert statement ?
Those two reports suggest that James isn't pointing to the table you think
it is using. If you go into Remote Manager and do a listusers, do you see
the user(s)? No, James doesn't require you to add users via the Remote
Manager.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
