Paul, yeah, usually some system tables need to be ignored to get useful results. Check the Oracle.isIgnoredTable method for an example. No such vendor class exists for DB2 yet, so it will just use the default SQL92 class. So you could create a Vendor class for DB2 based on SQL92 and only override isIgnoredTable, and wire it into ConnectedDb.ensureVendorInitialized().
Hope that helps, Richard > On 20 Dec 2013, at 16:25, "Aitkenhead, Paul C." <paitkenh...@draper.com> > wrote: > > OK, after I composed that question in my last post, I found the place where > the magic of learning the database schema occurs. It is in the > DatabaseSchemaInspector.java code, by using the > java.sql.DatabaseMetaData.getMetaData() method. > > I was wrong when I said generate-mapping produces no result with a DB2 > target. It actually does. > > What I see, however, is the need to somehow filter the result of > getMetaData() so that the generate map suits the individual developer's' > project. > > For example, any time I've used D2R with Oracle the system-level database > tables are not represented in the mapping, but due to the combination of DB2 > and the way its native JDBC driver works, generate-mapping tries to map all > the system-level tables along with the user tables, which is not helpful and > furthermore fooled me into thinking generate-mapping was failing. > > -----Original Message----- > From: Aitkenhead, Paul C. > Sent: Friday, December 20, 2013 10:18 AM > To: <d2rq-map-devel@lists.sourceforge.net> > Subject: Want to get generate-mapping working with DB2 > > I tried pointing generate-mapping at an IBM DB2 for Linux, Windows Unix > Version 10.5 database using DB2's native JDBC drivers. Generate-mapping did > connect, and the error messages clearly indicated that the database was being > probed. There was no useful result. Can you tell me where to look in the D2RQ > source to see where d2rq has its specialized knowledge of vendor-specific > database tables, so that I can try to understand how this works and maybe put > together something for DB2. > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > d2rq-map-devel mailing list > d2rq-map-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ d2rq-map-devel mailing list d2rq-map-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
