Thanks for sharing. We should probably add a note on this to the jdbc storage plugin doc.
On Fri, Jul 21, 2017 at 1:00 PM, Dan Holmes <[email protected]> wrote: > Turns out after you put the jar in the directory you have to restart drill. > > Works now. > > Dan Holmes | Revenue Analytics, Inc. > Direct: 770.859.1255 > www.revenueanalytics.com > > -----Original Message----- > From: Dan Holmes [mailto:[email protected]] > Sent: Friday, July 21, 2017 3:51 PM > To: [email protected] > Subject: Add oracle as a storage fails: Please retry: error (unable to > create/ update storage) > > I have followed the instructions here: https://drill.apache.org/docs/ > rdbms-storage-plugin/#Example-Oracle-Configuration > > I get the error in the subject. I don't see anything in the logs about it. > > { > type: "jdbc", > enabled: true, > driver: "oracle.jdbc.OracleDriver", > url:"jdbc:oracle:thin:user/pwd@yoda:1523/ORCL" > } > > I have the thin driver installed. > dan@ubuntu:~/apache-drill-1.10.0/jars/3rdparty$ ll o* -rwxrwxr-x 1 dan > dan 3698857 Jul 21 15:25 ojdbc7.jar* > > I can telnet to the server. > dan@ubuntu:~/apache-drill-1.10.0/jars/3rdparty$ telnet yoda 1523 Trying > 10.10.10.10... > Connected to yoda.RADOM.local. > Escape character is '^]'. > ^] > telnet> quit > Connection closed. > > I don't know how to troubleshoot this further. > > Thank you any help. > > Dan Holmes | Architect | Revenue Analytics, Inc. > 300 Galleria Parkway, Suite 1900 | Atlanta, Georgia 30339 > Direct: 770.859.1255 Cell: 404.617.3444 > www.revenueanalytics.com<https://webmail.revenueanalytics. > com/owa/redir.aspx?SURL=RqmyOJRm3r383jV2nPQLyg9BvjWZqM > X4-tL3BHj81WfaslMWau_SCGgAdAB0AHAAOgAvAC8AdwB3AHcAL > gByAGUAdgBlAG4AdQBlAGEAbgBhAGwAeQB0AGkAYwBzAC4AYwBvAG0A&URL= > http%3a%2f%2fwww.revenueanalytics.com> > LinkedIn<https://webmail.revenueanalytics.com/owa/redir.aspx?SURL= > SrcaeiXxVTCDhl49ibCO7CHhTsNynunc_8gSjHDaikXaslMWau_ > SCGgAdAB0AHAAcwA6AC8ALwB3AHcAdwAuAGwAaQBuAGsAZQBkAGkAbgAuAGM > AbwBtAC8AYwBvAG0AcABhAG4AeQAvAHIAZQB2AGUAbgB1AGUALQBhAG4AYQB > sAHkAdABpAGMAcwAtAGkAbgBjAC0A&URL=https%3a%2f%2fwww. > linkedin.com%2fcompany%2frevenue-analytics-inc-> | Twitter< > https://webmail.revenueanalytics.com/owa/redir.aspx?SURL= > cdePsMV8TCGx8O_Rugbj-maE9C9DVT373vSJwbUc23faslMWau_ > SCGgAdAB0AHAAcwA6AC8ALwB0AHcAaQB0AHQAZQByAC4AYwBvAG0ALwBSAGU > AdgBfAEEAbgBhAGwAeQB0AGkAYwBzAA..&URL=https%3a%2f%2ftwitter. > com%2fRev_Analytics> > >
