This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Concurrent Manager and Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Concurrent Manager and Java" Watch "Concurrent Manager and Java" New topic

Concurrent Manager and Java

Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17026

I know you can write SQL queries to find out what's going on inside Oracle' Concurrent manager - it's pretty easy to find such scripts on Google.
The implication is that part or all of the Concurrent Manager subsystem is maintained in Oracle tables.
Question: Is is also possible to submit jobs via Java and/or SQL requests? That is, can a Java app perform the same operations as the CONCSUB utility?

Customer surveys are for companies who didn't pay proper attention to begin with.
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17271

Tim, I think it all depends on how you have JDBC log into your Oracle system. If you log in with just a user, then the user will only have access to the same tables that they would get if they were using SQLPLUS. including user_tables. They are all available based on your grants, etc.

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: Concurrent Manager and Java
It's not a secret anymore!