[
https://issues.apache.org/jira/browse/JAMES-1228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13025125#comment-13025125
]
Eric Charles commented on JAMES-1228:
-------------------------------------
What about going to JPA, rather than reusing the jdbcutil, sqlResources,...
stuff ?
The 13 SQL statements to reimplement are not too difficult:
<sql name="selectMessageCounts">SELECT HAMCOUNT, SPAMCOUNT FROM
bayesiananalysis_messagecounts</sql>
<sql name="initializeMessageCounts">INSERT INTO
bayesiananalysis_messagecounts (HAMCOUNT, SPAMCOUNT) VALUES (0,0)</sql>
<sql name="updateHamMessageCounts">UPDATE bayesiananalysis_messagecounts
SET HAMCOUNT=(HAMCOUNT + ?)</sql>
<sql name="updateSpamMessageCounts">UPDATE bayesiananalysis_messagecounts
SET SPAMCOUNT=(SPAMCOUNT + ?)</sql>
<sql name="selectHamTokens">SELECT TOKEN, OCCURRENCES FROM
bayesiananalysis_ham</sql>
<sql name="selectSpamTokens">SELECT TOKEN, OCCURRENCES FROM
bayesiananalysis_spam</sql>
<sql name="insertHamToken">INSERT INTO bayesiananalysis_ham (TOKEN,
OCCURRENCES) VALUES (?,?)</sql>
<sql name="insertSpamToken">INSERT INTO bayesiananalysis_spam (TOKEN,
OCCURRENCES) VALUES (?,?)</sql>
<sql name="updateHamToken">UPDATE bayesiananalysis_ham SET
OCCURRENCES=(OCCURRENCES + ?) WHERE (TOKEN=?)</sql>
<sql name="updateSpamToken">UPDATE bayesiananalysis_spam SET
OCCURRENCES=(OCCURRENCES + ?) WHERE (TOKEN=?)</sql>
<sql name="deleteHamTokens">DELETE FROM bayesiananalysis_ham</sql>
<sql name="deleteSpamTokens">DELETE FROM bayesiananalysis_spam</sql>
<sql name="deleteMessageCounts">DELETE FROM
bayesiananalysis_messagecounts</sql>
As side effect, this will oblige to migrate mailets AI to JDK 1.6 to benefit
from latest OpenJPA.
> Factor Machine Learning mailets into independent project
> ---------------------------------------------------------
>
> Key: JAMES-1228
> URL: https://issues.apache.org/jira/browse/JAMES-1228
> Project: JAMES Server
> Issue Type: Sub-task
> Components: Matchers/Mailets (bundled)
> Reporter: Robert Burrell Donkin
> Assignee: Robert Burrell Donkin
>
> Create an independent component for the machine learning mailets currently in
> the core server.
> Hopefully this will:
> * isolate new development;
> * reduce barriers for new developers
> * allow independent release cycles
> Provisional approach:
> * create new project in mailet (James AI...?);
> * copy mailets and dependencies
> * repackage (into org.apache.james.mailets.ai.ml.classic ...?)
> Spikes:
> * do tests exist?
> * coupling?
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
