tag:blogger.com,1999:blog-5700399228771658115.post1395405495159267965..comments2017-09-26T23:35:02.699+03:00Comments on Knowledge For All: Configure Squirrel SQL to connect to IBM DB2Ashraf Fouadhttps://plus.google.com/112465373784813635820noreply@blogger.comBlogger59125tag:blogger.com,1999:blog-5700399228771658115.post-70737667079104651622017-09-26T23:35:02.699+03:002017-09-26T23:35:02.699+03:00hi I have this problem:
someone can help me?
jav...hi I have this problem:<br /><br />someone can help me?<br /><br />java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver<br /> at java.net.URLClassLoader$1.run(URLClassLoader.java:366)<br /> at java.net.URLClassLoader$1.run(URLClassLoader.java:355)<br /> at java.security.AccessController.doPrivileged(Native Method)<br /> at java.net.URLClassLoader.findClass(ANDREShttps://www.blogger.com/profile/04548693142409442071noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-65848740878046804682017-05-26T08:06:30.143+03:002017-05-26T08:06:30.143+03:00I tried it out...
I am getting the below exception...I tried it out...<br />I am getting the below exception -<br /><br />java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.59.81] The application server rejected establishment of the connection.<br />An attempt was made to access a database, z1u11, which was either not found or does not support Abhishek Bhathttps://www.blogger.com/profile/08434377226668268886noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-63175412159997812972017-05-26T05:28:14.678+03:002017-05-26T05:28:14.678+03:00Should be:
jdbc:db2://z1u11udb.corp.cat.com:3708/z...Should be:<br />jdbc:db2://z1u11udb.corp.cat.com:3708/z1u11Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-17752753097542669172017-05-25T08:04:12.382+03:002017-05-25T08:04:12.382+03:00Hey Ashraf,
I have hostname = z1u11udb.corp.cat.co...Hey Ashraf,<br />I have hostname = z1u11udb.corp.cat.com<br />port = 3708 and instance = z1u11<br />What would my url = jdbc:db2://:/<br />look like ?<br /><br />Thanks<br />ABAbhishek Bhathttps://www.blogger.com/profile/08434377226668268886noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-10598185664858837702017-04-28T12:45:42.468+03:002017-04-28T12:45:42.468+03:00Welcome :)Welcome :)Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-37103682810699090872017-04-27T16:46:16.255+03:002017-04-27T16:46:16.255+03:00Thanks man, quick and easy to follow guide. Helped...Thanks man, quick and easy to follow guide. Helped a ton!Danilo Souza Moraeshttps://www.blogger.com/profile/14930562583208097269noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-76436798950179678242017-04-19T12:11:16.879+03:002017-04-19T12:11:16.879+03:00WelcomeWelcomeAshraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-7506289901894399042017-04-19T11:55:29.390+03:002017-04-19T11:55:29.390+03:00ThanksThanksChangas Enatorhttps://www.blogger.com/profile/03633469313705780982noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-56367032928801071002016-12-01T20:30:46.153+03:002016-12-01T20:30:46.153+03:00:):)Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-45424556085988102712016-12-01T13:48:40.248+03:002016-12-01T13:48:40.248+03:00ThanksThanksДенис Шипиловhttps://www.blogger.com/profile/03687185917436720874noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-31278813262407012692016-11-14T15:22:49.906+03:002016-11-14T15:22:49.906+03:00Thank you, very helpfulThank you, very helpfulPetr Hornhttps://www.blogger.com/profile/16582047308361308578noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-19874751439128101222016-09-13T21:10:04.990+03:002016-09-13T21:10:04.990+03:00:):)Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-24236092011854639712016-09-13T20:36:12.145+03:002016-09-13T20:36:12.145+03:00Thank you! This worked like a charm! I was able to...Thank you! This worked like a charm! I was able to do this while sitting in a meeting -- that&#39;s when you know a guide was written very well!Unknownhttps://www.blogger.com/profile/05873625613385315712noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-76827986737433829942016-07-21T07:57:38.680+03:002016-07-21T07:57:38.680+03:00ThanksThanksAshraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-62180180465374400812016-07-21T07:57:19.050+03:002016-07-21T07:57:19.050+03:00ThanksThanksAshraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-83329300475175836332016-07-20T15:09:41.609+03:002016-07-20T15:09:41.609+03:00Nice to see your post, this is a great platform to...Nice to see your post, this is a great platform to get some useful information and facts!<br /><br /><a href="https://www.cloudendure.com/" rel="nofollow">rto</a><br />Aeldra Robinsonhttps://www.blogger.com/profile/12656113840161990349noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-43431138178027701652016-06-02T01:53:22.878+03:002016-06-02T01:53:22.878+03:00Thanks man, this is still really useful, even in 2...Thanks man, this is still really useful, even in 2016.Unknownhttps://www.blogger.com/profile/12918356719608300768noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-68505986296064278172016-03-04T18:09:31.682+03:002016-03-04T18:09:31.682+03:00Thanks for your helpThanks for your helpIrfan Zaidihttps://www.blogger.com/profile/00623720976981723028noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-38066114821195544992016-03-04T09:31:46.220+03:002016-03-04T09:31:46.220+03:00Happy that u started working.
This is more DB2 re...Happy that u started working.<br /><br />This is more DB2 related question, I didn&#39;t use DB2 since long back, you can either search the internet to find the error, or if you have question, I think this forum was of great help to me answering questions before and might help u:<br /><br />http://www.dbforums.com/forumdisplay.php?8-DB2&amp;s=110e6b5274a85b3772c05af40fc8ea3a<br /><br />I advice Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-25596413640285101552016-03-03T21:16:06.096+03:002016-03-03T21:16:06.096+03:00Thanks Ashraf,
I am finally able to connect to DB2...Thanks Ashraf,<br />I am finally able to connect to DB2. I had to use &quot;db2jcc_license_cu.jar and db2jcc4.jar&quot; combination for JAR files. I can run query but cannot see schemas/tables. I had same issue in SQL Developer as well and I got following error in there. It looks like permission issue as my user does not have permission on &quot;SYSCAT.SCHEMATA&quot; table. I know you are not Irfan Zaidihttps://www.blogger.com/profile/00623720976981723028noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-3609187492788595072016-03-02T20:43:34.028+03:002016-03-02T20:43:34.028+03:00The error is very clear that it can&#39;t find the...The error is very clear that it can&#39;t find the class so it is not being able to reach the jars. What is your complete path of the jar files? Does it contain spaces?<br /><br />Please paste the location or screen shot of your setup.Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-31439166129507315182016-03-02T18:09:44.975+03:002016-03-02T18:09:44.975+03:00Dear Ashraf, Salamun Alekum
Sorry for being late i...Dear Ashraf, Salamun Alekum<br />Sorry for being late in reply. I am using only two JAR files at a time *license* and one of other, NOT all three. I am not getting checked by using any combination. Just to let you know that I am able to connect to DB2 via &quot;Oracle SQL Developer&quot; using same JAR files. Thanks for your helpIrfan Zaidihttps://www.blogger.com/profile/00623720976981723028noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-90194348783154441612016-02-27T12:04:18.625+03:002016-02-27T12:04:18.625+03:00Dear Irfan,
Wa Alekom Al Salam Wa Rahmato Allah Wa...Dear Irfan,<br />Wa Alekom Al Salam Wa Rahmato Allah Wa Barkato, after a small invistigation I found this link showing the difference between db2jcc4.jar vs db2jcc.jar<br />http://www-01.ibm.com/support/docview.wss?uid=swg21665324<br /><br />So it seems that both have the same classes within the jar, and I thnk if you are trying to include all 3 jars<br />db2jcc.jar<br />db2jcc_license_cu.jar<br Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-74552489795074436022016-02-22T20:00:11.305+03:002016-02-22T20:00:11.305+03:00AOA:
I am having issues in connecting DB2 database...AOA:<br />I am having issues in connecting DB2 database. I can connect via SQL Developer and Toad Data Point, so I have correct credentials and connection strings. I tried to use these drivers but not success... <br />db2jcc.jar<br />db2jcc_license_cu.jar<br />db2jcc4.jar<br /><br />I have Win 7 32bit<br />Java 1.7<br />SQuirrel Build_2231<br /><br />I am seeing this error:<br />Could not find Irfan Zaidihttps://www.blogger.com/profile/00623720976981723028noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-20936512719828336042016-02-01T18:52:17.024+03:002016-02-01T18:52:17.024+03:00:) welcome:) welcomeAshraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.com