• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: EMPLOYEE

 
Vinod Vijay
Ranch Hand
Posts: 158
Java Tomcat Server Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I'm trying to connect my java program with HSQLDB. I'm getting following error:-



I can easily access my HSQL db with HSQL DB manager and can insert data directly into that. Even I have inserted one record using HSQL db manager directly but not through java program.
Any suggestion
 
Sumit Patil
Ranch Hand
Posts: 296
Eclipse IDE Firefox Browser Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the sql you are running in your java program?
Have you tried running the same query directly in HSQL db manager?
Please try that.

Thanks.
 
Vinod Vijay
Ranch Hand
Posts: 158
Java Tomcat Server Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sumit Patil wrote:What is the sql you are running in your java program?
Have you tried running the same query directly in HSQL db manager?
Please try that.

Thanks.


Here is my code:-



Yes! I tried the same sql in HSQL DB manager directly and it worked.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
and you connected as the same user? as in the hibernate config files
 
Vinod Vijay
Ranch Hand
Posts: 158
Java Tomcat Server Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons wrote:and you connected as the same user? as in the hibernate config files


I'm not using hibernate here. I'm trying to access with username 'SA'.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vinod Vijay wrote:
Wendy Gibbons wrote:and you connected as the same user? as in the hibernate config files


I'm not using hibernate here. I'm trying to access with username 'SA'.


sorry you mentioned HSQL i thought that was hibernate
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic