File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

entityManager and systems tables

 
Pat Peg
Ranch Hand
Posts: 195
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please include the stack trace.
 
Pat Peg
Ranch Hand
Posts: 195
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic