File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 3697
    
    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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: display instance of oracle database vs. schema
 
Similar Threads
RE: stmt.ExecuteQuery question
JTable help
jtable
ResultSetMetaData problem, not returning data
Add Row with AbstractTableModel