[MAILET-83] Replace Direct SQL with OpenJPA

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Robert Burrell Donkin
• Reporter: Robert Burrell Donkin
• Created: 28/Apr/11 18:48
• Updated: 15/Dec/12 11:47

Description

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

Issue Links

• is related to: JAMES-1228 Factor Machine Learning mailets into independent project