[ 
https://issues.apache.org/jira/browse/CALCITE-5028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17500144#comment-17500144
 ] 

XiaoboGu commented on CALCITE-5028:
-----------------------------------

Here is content of our pom.xml:

 

<project
    xmlns="http://maven.apache.org/POM/4.0.0" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
        https://maven.apache.org/xsd/maven-4.0.0.xsd";>
    
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.2.1.RELEASE</version>
        <relativePath/>
    </parent>
    
    <groupId>com.xsmartware</groupId>
    <artifactId>pbcm-svr</artifactId>
    <version>0.0.2</version>
    <name>pbcm-svr</name>
    <description>Server app for ssml. </description>
    
    <properties>
          <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
          <maven.compiler.encoding>UTF-8</maven.compiler.encoding>
          <java.version>9</java.version>
          <maven.compiler.source>9</maven.compiler.source>
          <maven.compiler.target>9</maven.compiler.target>
        <log4j2.version>2.17.1</log4j2.version>
        <drools.version>7.64.0.Final</drools.version>
      </properties>

    <dependencies>
        <dependency>
            <groupId>com.xsmartware</groupId>
            <artifactId>net-common</artifactId>
            <version>0.0.2</version>
        </dependency>
        <dependency>
            <groupId>com.xsmartware</groupId>
            <artifactId>pbcm-sdk</artifactId>
            <version>0.0.2</version>
        </dependency>

        <dependency>
            <groupId>org.apache.calcite</groupId>
            <artifactId>json-adapter</artifactId>
            <version>0.0.1</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <exclusions>
                  <exclusion>
                    <groupId>org.springframework.boot</groupId>
                  <artifactId>spring-boot-starter-logging</artifactId>
                </exclusion>
              </exclusions>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        
        <dependency>
            <groupId>org.apache.shiro</groupId>
            <artifactId>shiro-spring-boot-web-starter</artifactId>
            <version>1.4.0</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.1</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.5</version>
        </dependency>
        
        <dependency>
            <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
            </dependency>
        
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-slf4j-impl</artifactId>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
        </dependency>
        <dependency>
            <groupId>org.dom4j</groupId>
            <artifactId>dom4j</artifactId>
            <version>2.1.3</version>
        </dependency>
        <dependency>
            <groupId>jaxen</groupId>
            <artifactId>jaxen</artifactId>
        </dependency>
        <dependency>
            <groupId>org.drools</groupId>
            <artifactId>drools-core</artifactId>
            <version>${drools.version}</version>
        </dependency>
        <dependency>
            <groupId>org.drools</groupId>
            <artifactId>drools-compiler</artifactId>
            <version>${drools.version}</version>
        </dependency>
        <dependency>
            <groupId>org.drools</groupId>
            <artifactId>drools-decisiontables</artifactId>
            <version>${drools.version}</version>
        </dependency>
        <dependency>
        <groupId>org.apache.calcite</groupId>
            <artifactId>calcite-core</artifactId>
            <version>1.29.0</version> 
        </dependency>
        <dependency>
            <groupId>org.apache.calcite.avatica</groupId>
            <artifactId>avatica-core</artifactId>
            <version>1.20.0</version>
        </dependency>
        <!--
        <dependency>
            <groupId>org.codehaus.janino</groupId>
            <artifactId>janino</artifactId>
            <version>3.1.4</version>
        </dependency>
        
        <dependency>
            <groupId>org.codehaus.janino</groupId>
            <artifactId>commons-compiler</artifactId>
            <version>3.1.4</version>
        </dependency>
    -->
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

> Janino throws NoSuchMethodError in a multi-threaded application
> ---------------------------------------------------------------
>
>                 Key: CALCITE-5028
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5028
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.29.0
>            Reporter: XiaoboGu
>            Priority: Blocker
>
> we have the Java.lang.NoSuchMethodError problem when using the default 3.1.6 
> version of Janino in a multi-threaded application, which works well with 
> janino 3.1.4.
> com.xsmartware.pbcm.sdk.PBCMException: Calcite 
> ERROR:java.lang.NoSuchMethodError: 
> org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)Lorg/codehaus/commons/compiler/ICompilerFactory;
>     at 
> com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:61)
>  ~[classes/:?]
>     at 
> com.xsmartware.pbcm.thread.VarGenThread.doCompute(VarGenThread.java:24) 
> ~[classes/:?]
>     at com.xsmartware.pbcm.thread.VarGenThread.doCompute(VarGenThread.java:1) 
> ~[classes/:?]
>     at com.xsmartware.pbcm.thread.PBCMBaseThread.run(PBCMBaseThread.java:38) 
> [classes/:?]
>     at 
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
>     at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
>     at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
>  [?:?]
>     at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
>  [?:?]
>     at java.lang.Thread.run(Thread.java:834) [?:?]
> Caused by: com.google.common.util.concurrent.ExecutionError: 
> java.lang.NoSuchMethodError: 
> org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)Lorg/codehaus/commons/compiler/ICompilerFactory;
>     at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2053) 
> ~[guava-31.0.1-jre.jar:?]
>     at com.google.common.cache.LocalCache.get(LocalCache.java:3966) 
> ~[guava-31.0.1-jre.jar:?]
>     at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3989) 
> ~[guava-31.0.1-jre.jar:?]
>     at 
> com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4950)
>  ~[guava-31.0.1-jre.jar:?]
>     at 
> org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.revise(JaninoRelMetadataProvider.java:187)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.RelMetadataQueryBase.revise(RelMetadataQueryBase.java:118)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.RelMetadataQuery.collations(RelMetadataQuery.java:604)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.RelMdCollation.project(RelMdCollation.java:291)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.logical.LogicalProject.lambda$create$0(LogicalProject.java:125)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.plan.RelTraitSet.replaceIfs(RelTraitSet.java:244) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:124) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:114) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.core.RelFactories$ProjectFactoryImpl.createProject(RelFactories.java:178)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.tools.RelBuilder.project_(RelBuilder.java:2025) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.tools.RelBuilder.project(RelBuilder.java:1797) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.tools.RelBuilder.projectNamed(RelBuilder.java:2088) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.createAggImpl(SqlToRelConverter.java:3248)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertAgg(SqlToRelConverter.java:3151)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:702)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:664)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3548)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:589)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:259) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> com.xsmartware.common.calcite.CalciteDatabase.parseSql(CalciteDatabase.java:120)
>  ~[classes/:?]
>     at 
> com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:104)
>  ~[classes/:?]
>     at 
> com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:139)
>  ~[classes/:?]
>     at 
> com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:39)
>  ~[classes/:?]
>     ... 8 more
> Caused by: java.lang.NoSuchMethodError: 
> org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)Lorg/codehaus/commons/compiler/ICompilerFactory;
>     at 
> org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.compile(JaninoRelMetadataProvider.java:152)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.generateCompileAndInstantiate(JaninoRelMetadataProvider.java:136)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.lambda$static$0(JaninoRelMetadataProvider.java:70)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169)
>  ~[guava-31.0.1-jre.jar:?]
>     at 
> com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3533)
>  ~[guava-31.0.1-jre.jar:?]
>     at 
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2282) 
> ~[guava-31.0.1-jre.jar:?]
>     at 
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2159)
>  ~[guava-31.0.1-jre.jar:?]
>     at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2049) 
> ~[guava-31.0.1-jre.jar:?]
>     at com.google.common.cache.LocalCache.get(LocalCache.java:3966) 
> ~[guava-31.0.1-jre.jar:?]
>     at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3989) 
> ~[guava-31.0.1-jre.jar:?]
>     at 
> com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4950)
>  ~[guava-31.0.1-jre.jar:?]
>     at 
> org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.revise(JaninoRelMetadataProvider.java:187)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.RelMetadataQueryBase.revise(RelMetadataQueryBase.java:118)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.RelMetadataQuery.collations(RelMetadataQuery.java:604)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.metadata.RelMdCollation.project(RelMdCollation.java:291)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.logical.LogicalProject.lambda$create$0(LogicalProject.java:125)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.plan.RelTraitSet.replaceIfs(RelTraitSet.java:244) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:124) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:114) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.rel.core.RelFactories$ProjectFactoryImpl.createProject(RelFactories.java:178)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.tools.RelBuilder.project_(RelBuilder.java:2025) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.tools.RelBuilder.project(RelBuilder.java:1797) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.tools.RelBuilder.projectNamed(RelBuilder.java:2088) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.createAggImpl(SqlToRelConverter.java:3248)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertAgg(SqlToRelConverter.java:3151)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:702)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:664)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3548)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:589)
>  ~[calcite-core-1.29.0.jar:1.29.0]
>     at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:259) 
> ~[calcite-core-1.29.0.jar:1.29.0]
>     at 
> com.xsmartware.common.calcite.CalciteDatabase.parseSql(CalciteDatabase.java:120)
>  ~[classes/:?]
>     at 
> com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:104)
>  ~[classes/:?]
>     at 
> com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:139)
>  ~[classes/:?]
>     at 
> com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:39)
>  ~[classes/:?]
>     ... 8 more
>  
>  
> we checked the janino release note page
> [http://janino-compiler.github.io/janino/changelog.html]
> Fixed issue #141: Unable to find org.codehaus.commons.compiler.properties in 
> java 11: ICompilerFactories were loaded through the current thread's "context 
> class loader", which is a bad choice in some environments. Thus, the methods 
> "getDefaultCompilerFactory()", "getAllCompilerFactories()" and 
> "getCompilerFactory(className)" were duplicated and augmented with a 
> "classLoader" parameter. 
> It seems the getDefaultCompilerFactory method with a classloader parameter 
> was removed intentionally, but calcite still needs it.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to