• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Reg HSQL DB Priveleges

 
Ranch Hand
Posts: 186
Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 50
5
Oracle Postgres Database Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
We don't have time for this. We've gotta save the moon! Or check this out:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic