• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

display instance of oracle database vs. schema

 
Jeff Foflygen
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 4008
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic