Ok, to be fair, I just did some research on the error message and didn't realize that you're working with binaries only.
I tried to set it up on my machine to be able to reproduce your error. Unfortunately, I wasn't able to establish the connection between Flink and Postgres using your docker-compose.yml. I'm going to cc Timo. Maybe, he has a guess what's causing this error. Best, Matthias On Fri, Jan 22, 2021 at 4:35 PM Sebastián Magrí <sebasma...@gmail.com> wrote: > Hi Matthias! > > I went through that thread but as I'm just using the `apache/flink` docker > image for testing I honestly couldn't figure out how I would do that since > I don't have a pom file to edit. If it's possible to do it through the > configuration I'd be glad if you could point me out in the right direction. > > Pretty evident I don't have a lot of experience with mvn or "modern" Java > in general. > > :-) > > Thanks! > > On Fri, 22 Jan 2021 at 15:19, Matthias Pohl <matth...@ververica.com> > wrote: > >> Hi Sebastián, >> have you tried changing the dependency scope to provided >> for flink-table-planner-blink as it is suggested in [1]? >> >> Best, >> Matthias >> >> [1] >> http://apache-flink-mailing-list-archive.1008284.n3.nabble.com/Flink-1-10-exception-Unable-to-instantiate-java-compiler-td38221.html >> >> On Fri, Jan 22, 2021 at 4:04 PM Sebastián Magrí <sebasma...@gmail.com> >> wrote: >> >>> Hi! >>> >>> I'm trying out Flink SQL with the attached docker-compose file. >>> >>> It starts up and then I create a table with the following statement: >>> >>> CREATE TABLE mytable_simple ( >>> `customer_id` INT >>> ) WITH ( >>> 'connector' = 'jdbc', >>> 'url' = 'jdbc:postgresql://pgusr:pgpwd@postgres/pdgb', >>> 'table-name' = 'mytable' >>> ); >>> >>> However when I try to run this: >>> >>> select * from mytable_simple; >>> >>> I get the following error in the client: >>> >>> [ERROR] Could not execute SQL statement. Reason: >>> java.lang.ClassCastException: org.codehaus.janino.CompilerFactory cannot >>> be cast to org.codehaus.commons.compiler.ICompilerFactory >>> >>> At first I thought it could be an incompatibility issue with the >>> libraries I was putting in, like the postgres-cdc library version, but even >>> after leaving only the JDBC libraries in I still get the same error. >>> >>> It'd be great if you could give me some pointers here. >>> >>> Thanks! >>> >>> -- >>> Sebastián Ramírez Magrí >>> >> > > -- > Sebastián Ramírez Magrí > Managing Directors: Yip Park Tung Jason, Jinwei (Kevin) Zhang, Karl Anton Wehner
