Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # dev >> RE: [OS: Windows] Could not find or load main class sqlline.SqlLine


Copy link to this message
-
RE: [OS: Windows] Could not find or load main class sqlline.SqlLine
Hi Marco,
Thank you very much for your time.  I abandoned the classpath approach and went back to "copy-dependency" approach.  Given below is the output of sqlline.bat.  Can you quickly confirm if the output is as expected?  I will send across the patch for Windows setup separately for code review.
D:\workspace\incubator-drill>sqlline.bat -u jdbc:drill:schema=parquet-local -n admin -p admin
D:\workspace\incubator-drill>if not exist contrib\sqlline\target\dependencies (call mvn -B -f contrib\sqlline\pom.xml package )
D:\workspace\incubator-drill>java -Xmx1G -Dlogback.configurationFile=.\sqlparser\src\test\resources\logback.xml     -cp ".\contrib\sqlline\target\dependencies\*" sqlline.SqlLine --verbose=true -u jdbc:drill:schema=parquet-local -n admin -p adminLoaded singnal handler: SunSignalHandlerissuing: !connect jdbc:drill:schema=parquet-local admin adminscan complete in 9ms22:51:57,241 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [.\sqlparser\src\test\resources\logback.xml] at [file:/D:/workspace/incubator-drill/./sqlparser/src/test/resources/logback.xml]22:51:57,361 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set22:51:57,374 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender]22:51:57,385 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [SOCKET]22:51:57,434 |-INFO in de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET] - Waiting 1s to establish connections.22:51:58,434 |-INFO in de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET] - Started de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET]22:51:58,434 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]22:51:58,439 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT]22:51:58,447 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property22:51:58,506 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@33:27 - no applicable action for [level], current ElementPath  is [[configuration][appender][level]]22:51:58,506 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.drill] to false22:51:58,506 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.drill level set to DEBUG22:51:58,507 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOCKET] to Logger[org.apache.drill]22:51:58,507 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT level set to DEBUG22:51:58,507 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOCKET] to Logger[ROOT]22:51:58,507 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.22:51:58,508 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@8c0e89 - Registering current configuration as safe fallback point
scan complete in 2207msConnecting to jdbc:drill:schema=parquet-localConnected to: Drill (version 1.0)Driver: Apache Drill JDBC Driver (version 1.0)Autocommit status: trueTransaction isolation: TRANSACTION_REPEATABLE_READsqlline version ??? by Marc Prud'hommeaux0: jdbc:drill:schema=parquet-local>
Regards,Ravi
> Date: Sun, 29 Dec 2013 12:29:29 -0800
> Subject: Re: [OS: Windows] Could not find or load main class sqlline.SqlLine
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> Ravi,
>
> sqlline.properties is included in sqlline-1.1.0.jar. You can get rid of
> this message by extracting the file and copying it into your user folder
> C:\Users\ravisankars\sqlline\. Anyway, this is not critical, you can work
> without that file.
>
> The real problem is the other error [No known driver to handle