james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Benett <char...@benett1.demon.co.uk>
Subject Re: [PATCH] JDBC-backed UsersRepository implementation.
Date Sun, 10 Jun 2001 14:34:57 GMT
Charles Benett wrote:
> 
> Darrell DeBoer wrote:
> >
> > G'day,
> >
> > This is my first ever patch submission, so forgive me if don't get it quite
> > right.
> 
> Congratulations, Daz! Tarball is cool. Minor niggle, can you use cvs
> diff -u in future?

Oh! And 80 columns please! There's a coding standards doc somewhere...

> 
> >
> > I've managed to get a database-backed UsersRepository implementation up and
> > running, which is included here. A few things to note:
> >
> > 1) The code currently connects directly to a database, but it shouldn't be
> > too hard to get it to use the JdbcDataSource in
> > org.apache.avalon.excalibur.datasource. (I haven't quite worked out how to
> > set up components yet, so I haven't done this myself).  I have, however, made
> > the database configuration mirror that of the JdbcDataSource component, so
> > that we should be able to pass it straight through.
> >
> > 2) Basically, I've got vanilla SQL working with MySQL, M$SQL Server and
> > Oracle8i, although I'm getting some wierd problems with M$SQL using the
> > JDBC-ODBC bridge (Inet Sprinta driver (Type IV) works fine). Presently, the
> > SQL strings are hard-coded, but they could easily be set up during
> > configuration, if necessary.
> >
> > 3) One usability feature I've added is that the component checks for a table
> > named "JamesUsers" at start-up. If it's not present, the table is created.
> > This eliminates the need to run a database script as a separate part of
> > installation.
> 
> I've got your UsersJDBCRepository up and working with mysql. Cool!
> I've committed AbstractUsersRepository, UsersJDBCRepository and
> mysql.jar.
> 
> However ... aliasing and forwarding doesn't seem to work. :-(

Specifcially, the alias and forwarding dest appear in the db table, but
useAlias and useForwarding cols remain with 0.

Charles

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


Mime
View raw message