Replace Direct SQL with OpenJPA
-------------------------------
Key: JAMESMAILAI-1
URL: https://issues.apache.org/jira/browse/JAMESMAILAI-1
Project: James AI Mailets
Issue Type: New Feature
Components: bayes
Reporter: Robert Burrell Donkin
Assignee: Robert Burrell Donkin
Eric Charles (https://issues.apache.org/jira/browse/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."
+1 :-)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
