Ok, tried a JDBC connection in SQuirreLSQL and this is the stack trace I'm getting when trying to connect:
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: could not create connection
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:232)
at java.util.concurrent.FutureTask.get(FutureTask.java:91)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:680)
Caused by: java.lang.RuntimeException: java.sql.SQLException: could not create connection
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 6 more
Caused by: java.sql.SQLException: could not create connection
at cascading.lingual.jdbc.JaninoFactory.createConnection(JaninoFactory.java:60)
at cascading.lingual.jdbc.Driver.connect(Driver.java:157)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 8 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at cascading.lingual.jdbc.JaninoFactory.create(JaninoFactory.java:154)
at cascading.lingual.jdbc.JaninoFactory.createConnection(JaninoFactory.java:44)
... 11 more
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/configuration/Configuration
at org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.<init>(DefaultMetricsSystem.java:37)
at org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.<clinit>(DefaultMetricsSystem.java:34)
at org.apache.hadoop.security.UgiInstrumentation.create(UgiInstrumentation.java:51)
at org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:216)
at org.apache.hadoop.security.UserGroupInformation.ensureInitialized(UserGroupInformation.java:184)
at org.apache.hadoop.security.UserGroupInformation.isSecurityEnabled(UserGroupInformation.java:236)
at org.apache.hadoop.security.KerberosName.<clinit>(KerberosName.java:79)
at org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:209)
at org.apache.hadoop.security.UserGroupInformation.ensureInitialized(UserGroupInformation.java:184)
at org.apache.hadoop.security.UserGroupInformation.isSecurityEnabled(UserGroupInformation.java:236)
at org.apache.hadoop.security.UserGroupInformation.getLoginUser(UserGroupInformation.java:466)
at org.apache.hadoop.security.UserGroupInformation.getCurrentUser(UserGroupInformation.java:452)
at org.apache.hadoop.fs.FileSystem$Cache$Key.<init>(FileSystem.java:1494)
at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:1395)
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:254)
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:123)
at cascading.lingual.platform.hadoop.HadoopPlatformBroker.getDefaultFileSystem(HadoopPlatformBroker.java:437)
at cascading.lingual.platform.hadoop.HadoopPlatformBroker.getDefaultFileSystemURIScheme(HadoopPlatformBroker.java:430)
at cascading.lingual.platform.hadoop.HadoopPlatformBroker.makeURIScheme(HadoopPlatformBroker.java:416)
at cascading.lingual.platform.hadoop.HadoopPlatformBroker.getFileSystem(HadoopPlatformBroker.java:381)
at cascading.lingual.platform.hadoop.HadoopPlatformBroker.getFullPath(HadoopPlatformBroker.java:312)
at cascading.lingual.platform.PlatformBroker.makeFullCatalogFilePath(PlatformBroker.java:278)
at cascading.lingual.platform.PlatformBroker.getFullCatalogPath(PlatformBroker.java:217)
at cascading.lingual.catalog.FileCatalogManager.readCatalog(FileCatalogManager.java:76)
at cascading.lingual.platform.PlatformBroker.loadCatalog(PlatformBroker.java:227)
at cascading.lingual.platform.PlatformBroker.getCatalog(PlatformBroker.java:188)
at cascading.lingual.platform.PlatformBroker.startConnection(PlatformBroker.java:118)
at cascading.lingual.platform.hadoop.HadoopPlatformBroker.startConnection(HadoopPlatformBroker.java:93)
at cascading.lingual.jdbc.LingualConnection.initialize(LingualConnection.java:103)
at cascading.lingual.jdbc.LingualConnection.<init>(LingualConnection.java:79)
at SC.<init>(Unknown Source)
... 17 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.configuration.Configuration
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 48 more
Another thing I noticed is that I need to register both the local and the hadoop JDBC jar files. If I don't, i get a class not found error while trying to register in either R/SquirrelSQL for the org/slf4j/* classes.
dans-MacBook-Pro:platform dyoung1$ jar -tvf local/lingual-local-1.0.0-wip-172-jdbc.jar | grep slf4j | wc -l
dans-MacBook-Pro:platform dyoung1$ jar -tvf hadoop/lingual-hadoop-1.0.0-wip-172-jdbc.jar | grep slf4j | wc -l
Still digging.