aspose file tools
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: 16537

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: 17260

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