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 [Description: YellowfinLogo]<http://www.yellowfinbi.com/> David Abiuso / Customer Support p. 1300 651 071 (AU) / skype. yellowfinbisupport / [email protected]<mailto:[email protected]> Yellowfin Level 46 / 360 Elizabeth Street Melbourne 3000 Australia www.yellowfinbi.com<http://www.yellowfinbi.com> [Description: Twitter]<https://twitter.com/YellowfinBI> [Description: Youtube] <https://www.youtube.com/user/YellowfinTeam> [Description: Linkedin] <http://www.linkedin.com/company/yellowfin> [Description: YellowfinWiki] <http://wiki.yellowfin.com.au/display/USER70/Home> [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]<mailto:[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. [Description: YellowfinLogo]<http://www.yellowfinbi.com/> David Abiuso / Customer Support p. 1300 651 071 (AU) / skype. yellowfinbisupport / [email protected]<mailto:[email protected]> Yellowfin Level 46 / 360 Elizabeth Street Melbourne 3000 Australia www.yellowfinbi.com<http://www.yellowfinbi.com> [Description: Twitter]<https://twitter.com/YellowfinBI> [Description: Youtube] <https://www.youtube.com/user/YellowfinTeam> [Description: Linkedin] <http://www.linkedin.com/company/yellowfin> [Description: YellowfinWiki] <http://wiki.yellowfin.com.au/display/USER70/Home> [Description: YellowfinForum] <http://www.yellowfinbi.com/YFForum.i4> From: david abiuso Sent: Wednesday, 9 December 2015 5:21 PM To: '[email protected]<mailto:[email protected]>' <[email protected]<mailto:[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! [Description: YellowfinLogo]<http://www.yellowfinbi.com/> David Abiuso / Customer Support p. 1300 651 071 (AU) / skype. yellowfinbisupport / [email protected]<mailto:[email protected]> Yellowfin Level 46 / 360 Elizabeth Street Melbourne 3000 Australia www.yellowfinbi.com<http://www.yellowfinbi.com> [Description: Twitter]<https://twitter.com/YellowfinBI> [Description: Youtube] <https://www.youtube.com/user/YellowfinTeam> [Description: Linkedin] <http://www.linkedin.com/company/yellowfin> [Description: YellowfinWiki] <http://wiki.yellowfin.com.au/display/USER70/Home> [Description: YellowfinForum] <http://www.yellowfinbi.com/YFForum.i4>
