{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5514","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5514/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5514/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5514/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5514","id":123782451,"number":5514,"title":"OrientDB JDBC driver with Apache Drill","user":{"login":"objectsberg","id":11581349,"avatar_url":"https://avatars.githubusercontent.com/u/11581349?v=3","gravatar_id":"","url":"https://api.github.com/users/objectsberg","html_url":"https://github.com/objectsberg","followers_url":"https://api.github.com/users/objectsberg/followers","following_url":"https://api.github.com/users/objectsberg/following{/other_user}","gists_url":"https://api.github.com/users/objectsberg/gists{/gist_id}","starred_url":"https://api.github.com/users/objectsberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/objectsberg/subscriptions","organizations_url":"https://api.github.com/users/objectsberg/orgs","repos_url":"https://api.github.com/users/objectsberg/repos","events_url":"https://api.github.com/users/objectsberg/events{/privacy}","received_events_url":"https://api.github.com/users/objectsberg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"robfrank","id":413587,"avatar_url":"https://avatars.githubusercontent.com/u/413587?v=3","gravatar_id":"","url":"https://api.github.com/users/robfrank","html_url":"https://github.com/robfrank","followers_url":"https://api.github.com/users/robfrank/followers","following_url":"https://api.github.com/users/robfrank/following{/other_user}","gists_url":"https://api.github.com/users/robfrank/gists{/gist_id}","starred_url":"https://api.github.com/users/robfrank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robfrank/subscriptions","organizations_url":"https://api.github.com/users/robfrank/orgs","repos_url":"https://api.github.com/users/robfrank/repos","events_url":"https://api.github.com/users/robfrank/events{/privacy}","received_events_url":"https://api.github.com/users/robfrank/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2015-12-24T09:45:17Z","updated_at":"2015-12-28T21:24:05Z","closed_at":null,"body":"I'm trying to write a query that joins orientdb class with sql server table using Apache Drill.\r\nWithin the drill UI I've created a new JDBC storage mapped to OrientDb using the following config.:\r\n{\r\n  \"type\": \"jdbc\",\r\n  \"driver\": \"com.orientechnologies.orient.jdbc.OrientJdbcDriver\",\r\n  \"url\": \"jdbc:orient:remote:127.0.0.1/GratefulDeadConcerts\",\r\n  \"username\": \"root\",\r\n  \"password\": \"admin\",\r\n  \"enabled\": true\r\n}\r\n\r\nit succeeded to create a connection but I couldn't select any class! it always says not found. \r\nwhile trying to solve it I've reached the MapR Drill ODBC Driver which has a utility called Drill Explorer browsing the orientDB connection return no database classes?\r\n\r\ndoes anyone have faced this before, any suggestions?\r\nThanks"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/167660948","html_url":"https://github.com/orientechnologies/orientdb/issues/5514#issuecomment-167660948","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5514","id":167660948,"user":{"login":"robfrank","id":413587,"avatar_url":"https://avatars.githubusercontent.com/u/413587?v=3","gravatar_id":"","url":"https://api.github.com/users/robfrank","html_url":"https://github.com/robfrank","followers_url":"https://api.github.com/users/robfrank/followers","following_url":"https://api.github.com/users/robfrank/following{/other_user}","gists_url":"https://api.github.com/users/robfrank/gists{/gist_id}","starred_url":"https://api.github.com/users/robfrank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robfrank/subscriptions","organizations_url":"https://api.github.com/users/robfrank/orgs","repos_url":"https://api.github.com/users/robfrank/repos","events_url":"https://api.github.com/users/robfrank/events{/privacy}","received_events_url":"https://api.github.com/users/robfrank/received_events","type":"User","site_admin":false},"created_at":"2015-12-28T21:24:05Z","updated_at":"2015-12-28T21:24:05Z","body":"@objectsberg  you define the connection to orient with root/admin, my suggestion is to use admin/admin. \nMoreover: is the orientDb server up and running? \n\nCan you connect via console or studio? \nIs the orientdb-jdbc jar in the the Drill classpath? \nCan you connect to the db via jdbc (you can tests with a bounch of java code lines)? \n\nBut, please, modify your credentials to admin/admin instead of root/admin.\n\nLast but not least: which version of orient server and jdbc driver are you using? "}}