wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "display instance of oracle database vs. schema" Watch "display instance of oracle database vs. schema" New topic

display instance of oracle database vs. schema

Jeff Foflygen

Joined: Mar 12, 2009
Posts: 12

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

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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: display instance of oracle database vs. schema
Similar Threads
Add Row with AbstractTableModel
JTable help
RE: stmt.ExecuteQuery question
ResultSetMetaData problem, not returning data