----- Original Message -----
From: "Darrell DeBoer" <[EMAIL PROTECTED]>
> Unfortunately, I think there are problems with getting user Inboxes to
work
> with the new JdbcMailRepository. The problem is that, to find an Inbox for
a
> user, James adds the username to the end of the DestinationUrl. eg it asks
> for something like:
> db://../conf/inbox.propertiesusername
> which obviously won't work, since there's no file called that.
Good point. This clearly must be the issue Charles was running into.
> A few changes I'd like to see in the configuration/setup of the
> JdbcMailRepository, if others agree.
> - Get rid of the separate database .properties files.
> - Move "real" config out of the properties file and into the main
config.xml
> - Move SQL statements (which really should be considered part of the code
> base) for all databases into a common SqlResources file (that's the
> motivation behind SqlResources.java).
> - Add automatic table generation, so that all that's needed for
installation
> is a valid database and dbURL.
+1 to all points. I really wasn't happy with the way I did the
configuration. Looking over the way you did this (at least from a
configuration standpoint... I didn't get a chance to get into the actual
code yet), it looks fantastic. The way you can override specific statements
for a given database is perfect, as I think there's only one SQL statement
that changes (the one that calculates message size) and dreaded having
multiple sets of SQL statements for each provider.
With this approach, we can go back to a db://<resource>/<repository_name>
approach, and I'll leave it to you to figure out how the <resource> uses the
approach resource, table name, etc... Again, I didn't look at the User JDBC
code, but it seems like you should be able to do something like this.
+1 as well if you want to do this yourself and merge into the main branch...
if you have any questions on specifics of the JDBC mail repository, feel
free to ask as I should be pretty responsive via email for the next week or
so. I'll focus then on checking for performance hotspots, some
mailets/matchers, and maybe even some documentation (gasp).
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----------------------------------------------------
This message was brought to you by MailHive.net
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
