wood burning stoves 2.0*
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
Author

Concurrent Manager and Java

Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15957
    
  19

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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

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.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Concurrent Manager and Java
 
Similar Threads
Oracle database designing issues
MS. SQL DBA
how to start iSQL * Plus
Passing java arrays to PL/SQL and vice versa
Can't connect to SQL server 2005