thread « oracle « Java Database Q&A

1. JDBC and Threading    stackoverflow.com

I have a program that needs to query a database in a given interval and with the records it gets call perform some action, then update the table again. I am using ...

2. JDBC fundamental concepts, Pooling and Threading    stackoverflow.com

I was always using JDBC in JavaSE on single-threaded environment. But now I need to use a connection pool and let many threads to have interaction with the database (MSSQL and ...

3. Java threads remaining locked forever when attempting to insert into Oracle DB    stackoverflow.com

We've a Java application which periodically insert rows into the Oracle DB. This is a multi-threaded application. All threads barring one gets stuck periodically. We're thinking of upgrading the Oracle JDBC ...

4. Why does my Java / Oracle 11g threaded application fail?    stackoverflow.com

I have a Windows desktop Java application that was created in Eclipse using Java 1.5 JRE as the compiler and Oracle OCI drivers to communicate with multiple databases simultaneously. My ...

5. SQL For Update Skip Locked Query and Java Multi Threading - How to fix this    stackoverflow.com

SELECT 
        id
        FROM table_name tkn1,
        (SELECT 
   ...

6. Multithreading with an database (mysql or oracle)    stackoverflow.com

Am writing a multithreading application that has several threads(approxiamately 25) with each thread performing a specific process and then updating the database in the which then gives the next thread the ...

7. Multithreading on a database using oracle and mysql    stackoverflow.com

Does anyone have a code sample of a multithreading case that has about 25 threads that monitor a specific table in the database for a change then execute a process based ...

8. Multithreading issue while retrieving the data from oracle database (The Database SID is automatically Getting Killed)    stackoverflow.com

I have a java program which has 12 threads with different priorities. 12 of them retrieves some information from oracle database.(The data base is very huge in size and each and ...

9. Responsivness of threads related to user    stackoverflow.com

Our Java application runs frequently heavy databases queries. As Java process and Oracle process run on the same computer, these heavy queries may consume so much of CPU or IO that ...

10. Is there a way to trigger a jvm thread dump on an Oracle exception?    stackoverflow.com

We've got a Java program that runs in Websphere, and uses an Oracle database using straight jdbc (no Hibernate or JPA). Our customer is doing load testing using HP Performance ...

11. Thread.getId() error and ambiguity in ORACLE docs ???    coderanch.com

It seems from the above code that a thread is considered to be "created" when it is in running state , right ??? What is the basis for assigning ID's to threads ? I got 9,10,11...but there are only 4 threads in my code ? So, 1,2,3, (a fourth for main) etc is what i expected. Could it give 4,5,6 or ...

12. Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.dr    forums.oracle.com

13. RMI and Remote Server Multithreading with Oracle EBS as the client(s)    forums.oracle.com

RMI does not appear to be working correctly with a RMI connection from the Oracle EBS applications to a remote Tax engine on a remote server. I have eight EBS concurrent workers appear to be waiting on the RMI call results from the remote server. I thought that RMI automatically allows for multithreads from individual clients. In the case of EBS ...

14. How to use Threading Concept in oracle    forums.oracle.com

private String getLeastLoadedPool() { if (lastNodePoolUsed == null) { lastNodePoolUsed = "1"; return "1"; } if (lastNodePoolUsed.equals("1")) { lastNodePoolUsed = "2"; return "2"; } else { lastNodePoolUsed = "1"; return "1"; } } // in connection factory get connection factory public synchronized static Connection getConnection() throws Exception { if (singletonFactory == null) singletonFactory = new ConnectionFactory(); String poolId = (String) nodePoolTracker.get(); ...

15. java multithreading support in Oracle JVM    forums.oracle.com

Dear all, I have some questions and observations regarding multithreading support in Oracle JVM. I have some java code that is stored in the database and is multithreaded (in separate threads I run a plsql procedure that does a lot of precessing). If I run the code with my standalone JVM it works like a charm, everything gets executed in separate ...