The General SQL Parser library Java version works with the Java 1.8 or higher version, for both open source OpenJDK or Oracle Java.
However, if you like to use the data lineage analysis feature in the General SQL Parser:
DataFlowAnalyzer sqlLineageAnalyser = new DataFlowAnalyzer(query, databaseVendor, simpleOutput);
sqlLineageAnalyser.generateDataFlow();
There is something you need to know when you use Java 9 version or higher.
After JDK9, the jaxb package is removed from the core JDK, which the GSP uses when analyzing the data lineage from SQL script.
So please include the following code in your pom file:
<dependency>
<groupId>com.sun.xml.bind</groupId>
<artifactId>jaxb-core</artifactId>
<version>2.3.0</version>
</dependency>
<dependency>
<groupId>com.sun.xml.bind</groupId>
<artifactId>jaxb-impl</artifactId>
<version>2.3.0</version>
</dependency>
<dependency>
<groupId>javax.xml.bind</groupId>
<artifactId>jaxb-api</artifactId>
<version>2.4.0-b180725.0427</version>
</dependency>
Or, put all the following jaxb jar files in the classpath.
- javax.activation-api-1.2.0.jar
- jaxb-api-2.4.0-b180725.0427.jar
- jaxb-core-2.3.0.jar
- jaxb-impl-2.3.0.jar
- jaxb-runtime-2.3.2.jar