Subject | Re: tomcat+fbsql-1.0.0 (yet). Cannot getAutocommit on one machine, doesnt on anoth |
---|---|
Author | fedd_kraft |
Post date | 2005-07-18T12:44:29Z |
--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:
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?..
<rrokytskyy@a...> wrote:
> > When I issue that query from isql, it works.PASSWORD 'masterkey';
>
> 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'
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?..