• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

entityManager and systems tables

 
Pat Peg
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to query some of the system tables of an oracle database from my application but when I try to execute a nativequery I keep getting a null pointer exception.

I even tried the simplest of queries such as

select count(*) from dba_users;

I am guessing this might have something to do with the rights that the entitymanager has but I don't know.

How could I query on system tables using entityManager?

Thanks
 
James Sutherland
Ranch Hand
Posts: 553
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please include the stack trace.
 
Pat Peg
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found the problem, the user that the entityManager was logged in as lacked permissions to even see the table. Of course, now there is a new issue but I will post a separate topic.

Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic