Not everything in the stable 3.2.0 release works. Let me rephrase that. As I 
found when I tried to use it, some of the JPA classes create tables only in the 
derby database and users of true SQL databases - SQL Server, MySQL, etc. - are 
left in the cold, but not intentionally. There just is not enough manpower to 
test the code in all possible configurations. I will see if ‘createHamTable’ 
appears in the 3.3 chain and if so, forward it to you. If it is in the java 
source, I will let you know where. 

Sent from my iPhone

> On Feb 27, 2019, at 9:11 PM, Simon Levesque <suriv...@gmail.com> wrote:
> 
> Hi all,
> 
> I am using:
> 
>   - jpa
>   - MariaDB
>   - Apache James 3.2.0
> 
> 
> When I add the mailet BayesianAnalysis , I am getting:
> 
> INFO   | jvm 1    | 2019/02/26 22:00:34 | 22:00:34.036
> [WrapperSimpleAppMain] ERROR
> org.apache.james.mailetcontainer.lib.AbstractStateMailetProcessor - Unable
> to init mailet BayesianAnalysis
> INFO   | jvm 1    | 2019/02/26 22:00:34 | javax.mail.MessagingException:
> Exception initializing queries
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.transport.mailets.BayesianAnalysis.initDb(BayesianAnalysis.java:271)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.transport.mailets.BayesianAnalysis.init(BayesianAnalysis.java:258)
> [...]
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> java.lang.Thread.run(Thread.java:748)
> INFO   | jvm 1    | 2019/02/26 22:00:34 | Caused by:
> java.lang.RuntimeException: Required SQL resource: 'createHamTable' was not
> found.
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.util.sql.SqlResources.getSqlString(SqlResources.java:372)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.util.bayesian.JDBCBayesianAnalyzer.createTable(JDBCBayesianAnalyzer.java:362)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.util.bayesian.JDBCBayesianAnalyzer.checkTables(JDBCBayesianAnalyzer.java:335)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.util.bayesian.JDBCBayesianAnalyzer.initSqlQueries(JDBCBayesianAnalyzer.java:322)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.transport.mailets.BayesianAnalysis.initDb(BayesianAnalysis.java:269)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       ... 38 common frames omitted
> INFO   | jvm 1    | 2019/02/26 22:00:34 | 22:00:34.036
> [WrapperSimpleAppMain] ERROR
> org.apache.james.mailetcontainer.lib.AbstractStateMailetProcessor - Caused
> by nested exception:
> INFO   | jvm 1    | 2019/02/26 22:00:34 | java.lang.RuntimeException:
> Required SQL resource: 'createHamTable' was not found.
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.util.sql.SqlResources.getSqlString(SqlResources.java:372)
> INFO   | jvm 1    | 2019/02/26 22:00:34 |       at
> org.apache.james.util.bayesian.JDBCBayesianAnalyzer.createTable(JDBCBayesianAnalyzer.java:362)
> [...]
> 
> 
> First, I thought maybe it was due to the "dbMatchers" in sqlResources.xml
> that did not include "mariadb", but I checked the value returned
> by conn.getMetaData().getDatabaseProductName() when using the MariaDB
> connector and it should be returning "MySQL" (just like the MySQL
> connector).
> 
> My second guess is maybe because I am using JPA and that mailet is using
> JDBC. For instance, we have to configure:
> 
> <repositoryPath>db://maildb</repositoryPath>
> 
> but I do not see any other occurences of "db://maildb". This is the name in
> the example for that mailet, but does it need any special config?
> 
> I zipped my full config here:
> https://www.foilen.com/wp-content/uploads/conf.zip
> 
> thanks

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org

Reply via email to