I'm not aware of such a tool which will work directly with OpenJPA. It looks like DB/IQ QA can take a set of SQL statements as input though.
You could capture the SQL executed by OpenJPA by enabling the SQL logging channel<http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_logging_channels>. That trace could be directed to a file and massaged into a format that would work with DB/IQ. It might take a little awk / perl hacking but you should be able to get there in the end. Others on the list might know more though, hope this helps. -mike On Fri, Jan 7, 2011 at 7:36 AM, Tobias Trelle <[email protected]>wrote: > > Hi, > > is there a quality assurance tool for OpenJPA that does a static analysis > (assuming you are not using the criteria API und no string based dynamic > creation of native queries) on the resulting SQL statements and applies a > set of configurable rules on these statements? > > My company is using DB/IQ on the mainframe: > http://www.insoft-software.de/public_documents/iq_qa_fs_e.pdf > > Is there an equivalent tool for (Open)JPA and the DB2 SQL dialect? > > TIA, > Tobias > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/Quality-assurance-on-SQL-statements-tp5899181p5899181.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. >
