transaction « oracle « Java Database Q&A

1. Propagation of Oracle Transactions Between C++ and Java stackoverflow.com

We have an existing C++ application that we are going to gradually replace with a new Java-based system. Until we have completely reimplemented everything in Java we expect the C++ ...

2. Unit testing DDL statements that need to be in a transaction stackoverflow.com

I am working on an application that uses Oracle's built in authentication mechanisms to manage user accounts and passwords. The application also uses row level security. Basically every user that registers ...

3. JDBC transaction dead-lock: solution required? stackoverflow.com

My friend has described a scenario and challenged me to find solution. He is using Oracle database and JDBC connection with read committed as transaction isolation level. In one of the ...

4. How to archive a distributed (database) transaction between a java and c++ application? stackoverflow.com

I need to archive a distributed database transaction between a java and a c++ application in a way that both applications share the same transaction (can see uncommited data of this ...

5. What is the relationship between blocking, locking, and isolation levels? stackoverflow.com

I understand a little about Oracle blocking - how updates block other updates till the transaction completes, how writers don't block readers etc. I understand the concept of ...

6. Database deletes failed during inserts stackoverflow.com

I have two java apps: one of them inserts records to Table1. Second application reads first N items and removes them. When 1st application inserts data intensive, 2nd failed when I ...

7. How to handle parent key constraints in jdbc transactions? stackoverflow.com

I have 2 tables named T1 and T2. Where T1 is parent and T2 is child. The scenario is, I started a jdbc transaction and then insert a row in T1 and ...

8. How can I close Oracle DbLinks in JDBC with XA datasources and transactions to avoid ORA-02020 errors? stackoverflow.com

I have a JDBC-based application which uses XA datasources and transactions which span multiple connections, connected to an Oracle database. The app sometimes needs to make some queries using join ...

9. Oracle JDBC transaction management and committing sessions stackoverflow.com

Lets say i have the following bit of code

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
   ...

10. Error on Oracle while using DBLINK stackoverflow.com

I am Using jboss5.1.x, EJB3.0 ,JPA3. I am trying to do 'select' query from view which is connected via dblink to another database. source database is Oracle 9, destination dabatase is Oracle 8. I ...

11. Where does the responsibility lie to ensure the ACID properties of a transaction? stackoverflow.com

I was going through ACID properties regarding Transaction and encountered the statement below across the different sites ACID is the acronym for the four properties guaranteed by transactions: atomicity, consistency, isolation, ...

12. Lock, process and release lock in jdbc stackoverflow.com

Thats my requirement - to lock a database record, process it and release it Environment - weblogic 10.3 Database - Oracle 11g Datasources - multiple XA recources involved Tx mgr - JTA Here are the results ...

13. Behaviour of serializable transactions in oracle? stackoverflow.com

I have below sequence of transaction with isolation level as serializable

 trnsaction1                  ...

14. Java Oracle Transaction stackoverflow.com

I want to insert data into a database into different tables. Because of constraints I have to do this in a specific order. That means, first insert into table a, then ...

15. Some queries regarding serializable transactions? stackoverflow.com

I have read committed isolation can provide considerably more concurrency than serializable isolation level. My Question here is How Read committed isolation provides more concurrency than serializable?. A brief scenario would ...

16. how to resolve plenty of concurrent write operation in Oracle? stackoverflow.com

I am maintaining a lottery website with more than millions of users. Some active user(Perhaps more than 30,000) will buy more than 1000 lotteries within 1 second. Now the current logics ...

17. How to synch data in Ldap and Oracle in a single transaction? coderanch.com

18. Transaction with Oracle error coderanch.com

Hi, I get the error when I open the transaction in the Oracle. This code below works in the sybase and SQL Server, but dont works to Oracle. try{ ... dbwrapper.beginTrx(con,name); ... dbwrapper.commitTrx(con,name); } catch(Exception e){ dbwrapper.rollBackTrx(con,name); } I recieve this error: [net.upaid.database.DBWrapper.beginTrx()] Erro: java.sql.SQLException: ORA-00900: instruo SQL invlida at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132) ...

19. Oracle 9i concurrent transaction / isolation levels coderanch.com

Hi, I'm trying to complete an assignment regarding Oracle, and am finding my lecture notes too vague! I'm a student, so of course I have only 12 hours left to complete this or... Given that in each case the transactions are still in progress - can someone tell me: (a) At 1:03PM transaction A updates row R1 of table T. At ...