I am trying to learn OpenSQL/JBDBC. I have followed the example given in help.sap.com under Getting Started Relational Persistance.
1. I created a table in Dictionary perspective and deployed it.
2. Then i created an EJB in which i have created an interface named DAO wherein i have a select and an update method.i have also implemented this interface.
In the constructor of the implementing class i lookup the datasource(using an alias) and get a connection. I set the autocommit to false.
3. Then i tested the ejb by calling it from a standalone application. and it works fine.
4. However when i call the ejb from another ejb i am getting an exception which is
<b><i>"Cannot initiate transaction from a connection of "SAP<SID>DB" DataSource. Local or distributed transaction has already started."</i></b>
This ejb is being called called by another program which i suppose has already started the transaction and in the constructor when i try to start the new transaction it gives me this exception.
Please do let me know how to overcome this.