Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use both Oracle-specific and non-Oracle specific SQL checkers for the same program?

April 26, 2017Checkers non-Oracle Oracle-specific program sql

0

Posted

Can I use both Oracle-specific and non-Oracle specific SQL checkers for the same program?

1 Answer

0

Posted

Yes. For offline checking, you can specify SQL checkers for each connection context type. For online checking, you specify lists of SQL checkers. These checkers are queried, in order, with a live connection as to whether they will analyze that connection. Make sure that the JDBC generic checker sqlj.semantics.JdbcChecker is listed after the Oracle-specific one.