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 JDO and JDBC code on the same transaction/connection? For example, I would like to make a JDO query to fetch objects but update database records using Open SQL/JDBC?

April 26, 2017code connection fetch JDBC JDO mix query transaction

0

10 Posted

Can I mix both JDO and JDBC code on the same transaction/connection? For example, I would like to make a JDO query to fetch objects but update database records using Open SQL/JDBC?

1 Answer

0

10 Posted

The good news is that our integration of JDO into the server is such that JDBC and JDO work on the same JDBC connection whenever they access the same data source in one transaction. This is different from the traditional XA approach where JDBC and JDO would have their own JDBC connections that are combined into one transaction via XA. The pre-deployed JDO connector addresses the “system” data source via the data source alias SAP/BC_JDO. When you want to use JDBC and JDO together in one transaction, simply use the data source SAP/BJ_JDO for getting your JDBC connections.