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 mix both SQLJ- and JDBC-based code in the same transaction/database connection?

April 26, 2017code connection database mix SQLJ transaction

0

Posted

Can I mix both SQLJ- and JDBC-based code in the same transaction/database connection?

1 Answer

0

Posted

Yes! You can easily convert a JDBC connection to an SQLJ connection context, and back, and mix the both APIs as desired. A good example is to apply SQLJ clauses with static SQL statements and supplement them with JDBC-based dynamic SQL statements.