If nothing is present, could you create a Jira with some points about what would need to be done to manage the JPA? Maybe I could provide a pull request. thanks
On Thu, 28 Feb 2019 at 09:24, Garry Hurley <garry.hurley...@gmail.com> wrote: > 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 > >
