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
