• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reg HSQL DB Priveleges

 
Vijay Chandran
Ranch Hand
Posts: 186
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Friends,

I have configured HSQL DB (v 2.2.9) and using it for Junit testing purpose. I have configured the following in the application context:




Whenever I'm executing a SQL select I'm getting the below exception:


I'm able to execute the same query in SQL developer without any errors and I confirmed it multiple times. I've created the HSQL schema for all the tables like this:


I've also executed the scripts for inserting the constants data. But I'm stuck up with this issue for a long time. Can you please help me out on this issue?
Really appreciate your help.

Thanks,
Vijay
 
Lukas Eder
Ranch Hand
Posts: 49
5
Java Oracle Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you post your full DDL for whatever table1, table2, table3 really are? I suspect that you're confusing schemas and tables in either your DDL and / or SELECT statement. For instance, it doesn't make sense to create a schema called "table1" and then to select a column called "table1.column1"
 
Vijay Chandran
Ranch Hand
Posts: 186
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Lukas,

Thanks for your reply. As you pointed out i was using different schema which is unnecessary for all the tables. Creating single schema for all the tables resolved the issue.

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