Re: [Hsqldb-user] java.sql.SQLException: user lacks privilege or object not found ...

[ibytecoder <ish...@gm...>]

I developed an application using hsqldb. It is working fine when compiled in
netbeans. I converted the executable jar to exe using excelsior jet. I
placed database files where they should be (in the relative path) but now I
am getting this message that user lacks priviledge or object not found.
Any help will be highly appreciated.



Albretch Mueller-3 wrote:
> 
>> From: Fred Toussi <fredt <at> users.sourceforge.net>
>> Subject: Re: java.sql.SQLException: user lacks privilege or object not
>> found ...
>> Newsgroups: gmane.comp.java.hsqldb.user
>> Date: 2011-01-05 13:41:49 GMT (28 minutes ago)
> 
>> The obvious issue is the use of double quotes.
> 
>> Instead of SELECT "paths.pathix", you should use SELECT "paths"."pathix"
>> and do the same for all other qualified column names.
> 
>> The double quoting should be done per database object. Therefore the
>> table name and column name is each double quoted separately.
> ~
>  Yeap! It was the quotes. As you suggested, the HSQLDB engine ate the
> query after rearranging quotes like this:
> ~
>  SELECT "paths"."pathix", "paths"."path", "fls"."pathix",
> "fls"."size", "fls"."lmodtxt", "fls"."flnm" FROM "fsdata" "fls" INNER
> JOIN "dirsix" "paths" ON "fls"."pathix" = "paths"."pathix" WHERE
> ("fls"."size" < 25000000) ORDER BY "fls"."size" DESC;
> ~
>  Thanks
>  lbrtchx
> ~
> 
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment,
> and, 
> should the need arise, upgrade to a full multi-node Oracle RAC database 
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> 
> 

-- 
View this message in context: http://old.nabble.com/java.sql.SQLException%3A-user-lacks-privilege-or-object-not-found-...-tp30596375p32128984.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.