James currently has support for several SQL database servers, using JDBC.
There are specific sections for MySQL, MSSQL, Oracle, PostgreSQL, SAP, and
HyperSonic. Each of these database servers has certain ... SQL subtleties.
Recently we made a change for the benefit of MySQL, which I would like to
reproduce for the other servers.
The change effects the definitions for JDBCMailRepository operations.
Specifically, the createTable operation for MySQL has a secondary index key.
This looks like:
<sql name="createTable" db="mysql">
CREATE TABLE ${table} (
message_name varchar (200) NOT NULL,
repository_name varchar (255) NOT NULL,
message_state varchar (30) NOT NULL ,
error_message varchar (200) NULL ,
sender varchar (255) NULL ,
recipients text NOT NULL ,
remote_host varchar (255) NOT NULL ,
remote_addr varchar (20) NOT NULL ,
message_body longblob NOT NULL ,
last_updated datetime NOT NULL,
PRIMARY KEY (message_name, repository_name),
added --> KEY repo (repository_name)
)
</sql>
There are similar statements for the other database servers, but without the
additional index. Rather than make a change myself for a server that I
don't have available to test, I am asking if those of you who are familar
with each of the others would please submit the appropriate change to me so
that I can incorporate it into a future release of James.
Thanks. :-)
--- Noel
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
