You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Tobias Trelle <to...@codecentric.de> on 2011/01/07 14:36:26 UTC

Quality assurance on SQL statements?

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.

Re: Quality assurance on SQL statements?

Posted by Pinaki Poddar <pp...@apache.org>.
Hi,
>  Is there an equivalent tool for (Open)JPA and the DB2 SQL dialect? 

Something similar to static analysis of queries and @NamedQueries -- not
strictly with OpenJPA but on one of its derivatives (may look appropriate
for your DB2 environment) 

[1]
http://www.ibm.com/developerworks/websphere/techjournal/0812_wang/0812_wang.html


Regards --

-----
Pinaki 
-- 
View this message in context: http://openjpa.208410.n2.nabble.com/Quality-assurance-on-SQL-statements-tp5899181p5980291.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Quality assurance on SQL statements?

Posted by Michael Dick <mi...@gmail.com>.
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
<to...@codecentric.de>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.
>