Subject | Re: [Firebird-Java] Re: tomcat+fbsql-1.0.0 (yet). Cannot getAutocommit on one machine, doesnt on anoth |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-07-18T12:51:43Z |
> seems like firebird's rights set up incorrectly? e.g., no writeOk, at least this is not a "feature" of JayBird. Now you have to answer the
> permission for a db file?
question why other statements work ok :))
> i guess i shall ask fb developers?..Before asking developers check the owner user and group for the database
file and the access permissions to it. And compare with the user under which
Firebird runs. Note, when you create database with
CREATE DATABASE '/path/to/my/db.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
it is created without talking to your server, but the file is accessed
directly and you're the owner of the file. Same applies to backup/restore
process.
So, if your Firebird runs under firebird user, do simply
chown firebird:firebird /path/to/my/db.fdb
Roman