|
From: René A V. <RVa...@ct...> - 2014-10-20 16:44:02
|
Hello Gerd, >> I just tried to reproduce your problem on a PostgreSQL and couldn't see your problem. Schema loading works alright there. I thought that I also had the problem with MS SQL Server, but am not seeing it now... The problem may have been that I was looking for tables under "DBO Owner", not "DBO". With regard to DB2 on the IBM i, the issue may relate to the fact that database and schema are often (or usually or always?) the same layer (related to the library name), and not separate as in SQL Server. >> Unfortunately I don't have access to a DB2/AS400. Do you or anybody else know of a way I could reproduce the problem? Are you doing your development in Linux? If the project can qualify, IBM's program described at http://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_com_sys_p ower-development-platform might be of use. René A Valencourt, CCP, MCTS Senior Programmer/Analyst IS Department (574)658-5208 (574)658-8002 (FAX) CTB, Inc. A Berkshire Hathaway Company -----Original Message----- From: Gerd Wagner [mailto:ger...@t-...] Sent: Sunday, October 19, 2014 2:19 PM To: RVa...@ct... Cc: 'Alex Malmyguine'; squ...@li...; jh...@im... Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 Alex, I just tried to reproduce your problem on a PostgreSQL and couldn't see your problem. Schema loading works alright there. Unfortunately I don't have access to a DB2/AS400. Do you or anybody else know of a way I could reproduce the problem? Sorry for the inconvenience Gerd Am 17.10.2014 um 16:35 schrieb René A Valencourt: > Hi Alex, > >>>Do you mean you do not see the tables even in the schema specified in > the alias? > > Precisely.I discovered that the reason is having specified "Load all > Schemas, cache none". > > ·If I specify "Load all Schemas, cache none", then neither Tables nor > Views can be seen, although Procedures do appear. > > ·If I specify "Load all and cache all Schemas", then I can see the > Tables, Views, and Procedures. > > ·If I "Specify Schema loading and caching", then I can get a variety > of results.If I specify "Load..." for Tables, Views, or Procedures, then > I will see the items specified to be loaded.However, if I specify some > to be loaded and others not to be loaded, I can get a variety of > results.If I specify "Don't load" for some, but "Load..." for others, I > may see still see all three, or maybe only a subset.Appearance of > objects not selected to be loaded appears to have to do with whether I > had earlier specified loading for them... > > So, the bottom line is that I can actually see tables and views for > everything if I specify individual Schema loading, or "Load all and > cache all Schemas". > > But, > > 1.There is a bug with Tables and Views not displaying with "Load all > Schemas, cache none". > > 2.There is also a bug with "Specify Schema loading and caching", in > that Tables, Views, and Properties may show even if they have been > specified not to load. It appears to relate to the information still > being in the cache, if they had been earlier specified to load. > > Is it sufficient to report this here, or do I need to report bugs elsewhere? > > René A Valencourt, CCP, MCTS > Senior Programmer/Analyst > > IS Department > > (574)658-5208 > (574)658-8002 (FAX) > CTB > > CTB, Inc. > A Berkshire Hathaway Company > > *From:*Alex Malmyguine [mailto:ale...@wo...] > *Sent:* Thursday, October 16, 2014 8:45 AM > *To:* RVa...@ct... > *Cc:* squ...@li... > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Do you mean you do not see the tables even in the schema specified in > the alias? > > I can see them in TESTDAT which is the schema in the alias, but not in > the other schemas. > > *From:*René A Valencourt [mailto:RVa...@ct...] > *Sent:* Wednesday, October 15, 2014 5:10 PM > *To:* Alex Malmyguine > *Cc:* squ...@li... > <mailto:squ...@li...> > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Hi Alex, > > Thanks for asking! ...but I had done nothing with schema. Here is the spec: > > René A Valencourt, CCP, MCTS > Senior Programmer/Analyst > > IS Department > CTB > > CTB, Inc. > A Berkshire Hathaway Company > > *From:*Alex Malmyguine [mailto:ale...@wo...] > *Sent:* Wednesday, October 15, 2014 4:58 PM > *To:* RVa...@ct... <mailto:RVa...@ct...> > *Cc:* squ...@li... > <mailto:squ...@li...> > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Rene, > > Did you by any chance use this tab in the alias editor to inhibit > loading of the schemas? > > *From:*René A Valencourt [mailto:RVa...@ct...] > *Sent:* Wednesday, October 15, 2014 4:43 PM > *To:* Alex Malmyguine > *Cc:* squ...@li... > <mailto:squ...@li...> > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Hello Alex, > >>>What was the problem back then? > > I expected to be able to view all objects associated with any given > schema. I am able to see at least the aliases, procedures, and > sequences associated with any given schema. But I am not able to see > the tables for ANY schema, even when I have specified a default schema > by the various means available - either doing it as you did, or by > specifying the "libraries" property, or by specifying the "database > name" property. > > I was also having the same problem with MS SQL Server, but if given a > default schema, Squirrel does show me the associated tables for that schema. > > Here are my driver (using the jtopen 7.1 jar file) and alias definitions: > > René A Valencourt, CCP, MCTS > Senior Programmer/Analyst > > IS Department > > (574)658-5208 > (574)658-8002 (FAX) > CTB > > CTB, Inc. > A Berkshire Hathaway Company > > *From:*Alex Malmyguine [mailto:ale...@wo...] > *Sent:* Wednesday, October 15, 2014 3:43 PM > *To:* RVa...@ct... <mailto:RVa...@ct...> > *Cc:* squ...@li... > <mailto:squ...@li...> > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Rene: > > What was the problem back then? > > This is how driver is set up on my machine. As you can see I am still > on > 3.5.0 and it still works fine against i7.1 > > *From:*René A Valencourt [mailto:RVa...@ct...] > *Sent:* Wednesday, October 15, 2014 3:29 PM > *To:* Alex Malmyguine > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Hello Alex, > > This has been quite a delay in answering your question... > >>>What versions of Squirrel and JT Open are you using? > > I was on whatever version of Squirrel were current in April (either > possibly 3.5.0 but maybe earlier) and JTOpen I thought was version > 8.2, but I just discovered that the folder was empty (whether it were > empty in April I don't know). So it had actually been using whatever > came with Client Access, which was from 2012. > > The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on > my 64-bit Windows 7 PC. > > So I: > > ·upgraded to Squirrel 3.6 > > ·upgraded to JTOpen 8.3 > > ·updated my driver definition in squirrel to point to the new default > jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar) > > and get the same result. > > Then I > > ·updated my driver definition in squirrel to point to the new > jt400.jar for Java 6 and higher (C:\Program Files > (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar) > > and still get the same result. > >>>I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that >>>works > fine with iSeries 7.1 and 5.3 DB with default settings. ...You might > want to use that as a workaround until you figured out Squirrel. > > I downloaded JTOpen 7.1, and put its jt400.jar at the head of the > list, but nothing changed. > > Has anyone had this problem and found a resolution? > > Thanks, > > René A Valencourt, CCP, MCTS > Senior Programmer/Analyst > > IS Department > > (574)658-5208 > (574)658-8002 (FAX) > CTB > > CTB, Inc. > A Berkshire Hathaway Company > > *From:*Alex Malmyguine [mailto:ale...@wo...] > *Sent:* Friday, April 25, 2014 4:37 PM > *To:* RVa...@ct... <mailto:RVa...@ct...> > *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Rene: > > What versions of Squirrel and JT Open are you using? > > I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that > works fine with iSeries 7.1 and 5.3 DB with default settings. > > Using the same JTOpen driver I can connect to iSeries from Oracle SQL > Developer too. You might want to use that as a workaround until you > figured out Squirrel. > > Thank you! > > Alex > > *From:*René A Valencourt [mailto:RVa...@ct...] > *Sent:* Friday, April 25, 2014 3:30 PM > *To:* 'Eric Gulatee'; 'Jim It' > *Cc:* squ...@li... > <mailto:squ...@li...> > *Subject:* Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1 > > Jim >> There are a whole host of jdbc properties which can effect the > way the IBM system handles jdbc requests. > > Jim >> > http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/c > om/ibm/as400/micro/doc-files/JDBCProperties.html?resultof=%22%53%79%73 > %74%65%6d%22%20%22%73%79%73%74%65%6d%22%20%22%70%72%6f%70%65%72%74%69% > 65%73%3a%22%20%22%70%72%6f%70%65%72%74%69%22%20 > > Jim >> The one that changed is metadata source. ...change to 1 - > Database metadata will be retrieved by calling system stored procedures in 7.1. > > Jim >> Go into Alias properties, Driver Properties tab and specify the > driver properties you want to use and the value you want to use, in > this case 1. > > Eric >> ...I can now view the DB2/AS400 tables again using my Squirrel again. > > Unfortunately, I changed the "metadata source" driver property to a > value of '1', and I still can't view the table list. I was using the > Client Access driver from March 2012, but I just downloaded and > registered with SQuirreL the March 2014 version 8.2 jt400.jar from the > web site http://sourceforge.net/projects/jt400/ (the web page said it > would be version 8.1), with the same result. > > Now I just checked a Microsoft SQL Server connection, and see that I > cannot expand any categories (such as "TABLE") underneath a schema > (such as "dbo") within a SQL Server database, either. > > So there must be some other setting that I have wrong? > > René A Valencourt, CCP, MCTS > Senior Programmer/Analyst > > IS Department > > CTB, Inc. > A Berkshire Hathaway Company -- ************************************************************ This message may contain privileged, confidential and/or trade secret information which is protected by law and is intended only for the addressee. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify us, and permanently delete all copies of the message. Due to the nature of the Internet, e-mail messages are not secure and may be delayed or undelivered. Also, in accordance with CTB company policy, e-mail messages may be reviewed or retained by CTB employees in addition to or other than the intended recipient. This footnote also confirms that this email message has been swept by Postini for the presence of computer viruses. ************************************************************ -- ************************************************************ This message may contain privileged, confidential and/or trade secret information which is protected by law and is intended only for the addressee. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify us, and permanently delete all copies of the message. Due to the nature of the Internet, e-mail messages are not secure and may be delayed or undelivered. Also, in accordance with CTB company policy, e-mail messages may be reviewed or retained by CTB employees in addition to or other than the intended recipient. This footnote also confirms that this email message has been swept by Postini for the presence of computer viruses. ************************************************************ |
