Subject Re: tomcat+fbsql-1.0.0 (yet). Cannot getAutocommit on one machine, doesnt on anoth
Author fedd_kraft
--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:
> > When I issue that query from isql, it works.
>
> How do you connect to the database? Please ensure that host name is
> specified, e.g.
>
> CONNECT 'localhost:/path/to/my/db.fdb' USER 'SYSDBA'
PASSWORD 'masterkey';

yaaa! :(

SQL> select count("id") from "permread" where "id"=1 and "userid"=12;

COUNT
============
Statement failed, SQLCODE = -902

I/O error for file ""
-Error while trying to open file
-Permission denied

seems like firebird's rights set up incorrectly? e.g., no write
permission for a db file?

i guess i shall ask fb developers?..