aspose file tools*
The moose likes JDBC and the fly likes display instance of oracle database vs. schema Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "display instance of oracle database vs. schema" Watch "display instance of oracle database vs. schema" New topic
Author

display instance of oracle database vs. schema

Jeff Foflygen
Greenhorn

Joined: Mar 12, 2009
Posts: 12
Hello,

I need some help or direction if any can; I have a spreadsheet-like view that I created, it is working, but the problem is that it is going to the schema level as opposed to the instance level of the database, and I'm not sure how to make it do that. any thoughts, suggestions, etc... would be more than welcomed. Here is my code that I am using:



then the bulk of the connect and display:
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Generally in JDBC you work on the schema level, enforcing your own security/filters on a programmatic level. For example, if you want to filter by user, create a user table and manage permissions that way. Although some databases support more sophisticated interactions, most are a pain to use and extremely non-portable.


My Blog: Down Home Country Coding with Scott Selikoff
 
wood burning stoves
 
subject: display instance of oracle database vs. schema