David, AFAIK, port should be same as lens server api port. The default port is 9999.
Thanks On Thu, Dec 10, 2015 at 11:35 AM, david abiuso <[email protected]> wrote: > Hi Amareshwari, Amruth, Pranav, > > > > It’s most likely that the issue is because of something wrong I did – not > something wrong with Lens! So, as I do not wish to waste your time, if you > could just please tell me which port I should be using for the JDBC > connection, that would be great! > > > > Regards, > > David > > > > [image: Description: YellowfinLogo] <http://www.yellowfinbi.com/> > > *David Abiuso* / Customer Support > p. 1300 651 071 (AU) / skype. yellowfinbisupport / > [email protected] > > *Yellowfin* > Level 46 / 360 Elizabeth Street Melbourne 3000 Australia > www.yellowfinbi.com > > [image: Description: Twitter] <https://twitter.com/YellowfinBI> [image: > Description: Youtube] <https://www.youtube.com/user/YellowfinTeam> [image: > Description: Linkedin] <http://www.linkedin.com/company/yellowfin> [image: > Description: YellowfinWiki] > <http://wiki.yellowfin.com.au/display/USER70/Home> [image: Description: > YellowfinForum] <http://www.yellowfinbi.com/YFForum.i4> > > > > > > > > *From:* amareshwarisr . [mailto:[email protected]] > *Sent:* Thursday, 10 December 2015 3:41 PM > *To:* [email protected]; [email protected]; Pranav Agarwal < > [email protected]> > *Subject:* Re: jdbc connection string port > > > > Thanks David. > > > > Amruth/Pranav, last time i heard from you that you were able to > successfully connect through JDBC client and run queries. Can you help > David? > > > > Thanks > > Amareshwari > > > > On Thu, Dec 10, 2015 at 5:25 AM, david abiuso <[email protected]> > wrote: > > Hi Team, > > > > By the way, please forgive my lack of manners….I also meant to say > Congratulations and Well Done from everyone here at Yellowfin Business > Intelligence for all of your work on Lens! It is a great project that has > fulfilled a much needed requirement in the Big Data world. > > > > > > [image: Description: YellowfinLogo] <http://www.yellowfinbi.com/> > > *David Abiuso* / Customer Support > p. 1300 651 071 (AU) / skype. yellowfinbisupport / > [email protected] > > *Yellowfin* > Level 46 / 360 Elizabeth Street Melbourne 3000 Australia > www.yellowfinbi.com > > [image: Description: Twitter] <https://twitter.com/YellowfinBI> [image: > Description: Youtube] <https://www.youtube.com/user/YellowfinTeam> [image: > Description: Linkedin] <http://www.linkedin.com/company/yellowfin> [image: > Description: YellowfinWiki] > <http://wiki.yellowfin.com.au/display/USER70/Home> [image: Description: > YellowfinForum] <http://www.yellowfinbi.com/YFForum.i4> > > > > > > > > *From:* david abiuso > *Sent:* Wednesday, 9 December 2015 5:21 PM > *To:* '[email protected]' <[email protected]> > *Subject:* jdbc connection string port > > > > Hi Team, > > > > I’ve followed the installation guide > <https://lens.apache.org/lenshome/install-and-run.html> and have LENS up > and running, and can query the demo data using the lens-shell, and also > using the LENS QUERY UI > > > > However, I am trying to connect via JDBC from SQuirreL but keep getting a > java.sql.SQLException: “Unable to create connection. Check your URL.” > > > > I am using org.apache.lens.client.jdbc.LensJdbcDriver from > lens-client-2.4.0-beta.jar and my connection string is of the form: > > > > jdbc:lens://hostname:port/dbname; > > > > and I have tried every port that is listed via netstat –ant on my > Apache-Lens VM. > > > > Could you please confirm what the default port for the JDBC connection > string is? And if you can think of any other tips that would be very much > appreciated! > > > > > > [image: Description: YellowfinLogo] <http://www.yellowfinbi.com/> > > *David Abiuso* / Customer Support > p. 1300 651 071 (AU) / skype. yellowfinbisupport / > [email protected] > > *Yellowfin* > Level 46 / 360 Elizabeth Street Melbourne 3000 Australia > www.yellowfinbi.com > > [image: Description: Twitter] <https://twitter.com/YellowfinBI> [image: > Description: Youtube] <https://www.youtube.com/user/YellowfinTeam> [image: > Description: Linkedin] <http://www.linkedin.com/company/yellowfin> [image: > Description: YellowfinWiki] > <http://wiki.yellowfin.com.au/display/USER70/Home> [image: Description: > YellowfinForum] <http://www.yellowfinbi.com/YFForum.i4> > > > > >
