• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

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

 
Ranch Hand
Posts: 165
Tomcat Server Java 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
 
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: 165
Tomcat Server Java 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.
 
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: 165
Tomcat Server Java 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 L 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
 
The two armies met. But instead of battle, they decided to eat some pie and contemplate this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
    Bookmark Topic Watch Topic
  • New Topic