[CALCITE-1122] Sqlline.bat is not working in Windows

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.7.0

Environment

Windows

• Assignee: Julian Hyde
• Reporter: Lan Wang
• Created: 04/Mar/16 02:47
• Updated: 22/Mar/16 01:18
• Resolved: 04/Mar/16 23:18

Description

Sqlline.bat in csv example is not working because classpath is missing. The error messages are like below:

Caused by: java.lang.ClassNotFoundException: org.apache.calcite:adapter.csv.CsvSchemaFactory
               at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
               at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
               at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
               at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
               at java.lang.Class.forName0(Native Method)
               at java.lang.Class.forName(Class.java:264)
               at org.apache.calcite.model.ModelHandler.visit(ModelHandler.java:210)
                ... 18 more

In the file sqlline.bat, the parameter of -cp is ".\target\dependencies*" while the required calcite-example-csv-VERSION.jar is not included in this path which causes the exception.
Maybe we can fix the -cp parameter to "target\test-classes;target\classes;target\dependencies*".