James Server
  1. James Server
  2. JAMES-849

Support PostgreSQL for BayesianAnalysis

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.1
    • Fix Version/s: 2.3.2, 3.0.0
    • Component/s: Mailet Contributions
    • Labels:
      None
    • Environment:
      PostgreSQL Database

      Description

      Add following XML to the conf/sqlResources.xml for PostgreSQL support.

      <sql name="createHamTable" db="postgresql">
      CREATE TABLE bayesiananalysis_ham (
      token character varying(128) NOT NULL default '',
      occurrences bigint NOT NULL default '0',
      PRIMARY KEY (token)
      )
      </sql>
      <sql name="createSpamTable" db="postgresql">
      CREATE TABLE bayesiananalysis_spam (
      token character varying(128) NOT NULL default '',
      occurrences bigint NOT NULL default '0',
      PRIMARY KEY (token)
      )
      </sql>
      <sql name="createMessageCountsTable" db="postgresql">
      CREATE TABLE bayesiananalysis_messagecounts (
      hamcount bigint NOT NULL default '0',
      spamcount bigint NOT NULL default '0'
      )
      </sql>

        Activity

        Johannes Geppert created issue -
        Hide
        Stefano Bagnara added a comment -

        We already had this queries in trunk (I didn't know / remember this).
        So I will simply backport what we have in trunk to v2.3 (so it will be included in 2.3.2).

        Thank you anyway Johannes!

        Show
        Stefano Bagnara added a comment - We already had this queries in trunk (I didn't know / remember this). So I will simply backport what we have in trunk to v2.3 (so it will be included in 2.3.2). Thank you anyway Johannes!
        Stefano Bagnara made changes -
        Field Original Value New Value
        Assignee Stefano Bagnara [ bago ]
        Fix Version/s 3.0 [ 10427 ]
        Affects Version/s 2.3.1 [ 12312465 ]
        Fix Version/s 2.3.2 [ 12312493 ]
        Hide
        Stefano Bagnara added a comment -

        Backported from trunk (support both derby and postgresql previously unsupported)

        Show
        Stefano Bagnara added a comment - Backported from trunk (support both derby and postgresql previously unsupported)
        Stefano Bagnara made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Mark Thomas made changes -
        Workflow jira [ 12436207 ] Default workflow, editable Closed status [ 12566358 ]
        Mark Thomas made changes -
        Workflow Default workflow, editable Closed status [ 12566358 ] jira [ 12581723 ]

          People

          • Assignee:
            Stefano Bagnara
            Reporter:
            Johannes Geppert
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 2h
              2h
              Remaining:
              Remaining Estimate - 2h
              2h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development