Hi Ian,

Check to be sure that the database has granted the user the necessary
access to the tables.

If the database was moved to the Linux box as well as Tomcat, the grants
may not have been set up.

Is the database on the same machine (Linux) as Tomcat?

It could also be that Jaybird is logging, and that the log config file
in the app is telling it to write the file in an area you don't have
access to. This doesn't seem likely if it's running as root.

See the following link for the Jaybird Wiki on logging.

http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:logging


Hope this helps,

Rick


Ian A. Newby wrote:

> Hi Folks,
> I'm trying to move a web app from windows to linux. It works fine in
> windows, but is failing in the linux environment when I try to create
> a wrappingdatasource. The relevent part of the stack trace is as follows:
>
> Caused by: java.lang.ExceptionInInitializerError
> at
> org.firebirdsql.pool.FBWrappingDataSource.getPool(FBWrappingDataSource.java:172)
> at
> org.firebirdsql.pool.FBWrappingDataSource.setUserName(FBWrappingDataSource.java:406)
> ... 34 more
> Caused by: java.security.AccessControlException: access denied
> (java.util.PropertyPermission FBLog4j read)
> at
> java.security.AccessControlContext.checkPermission(AccessControlContext.java:264)
> at
> java.security.AccessController.checkPermission(AccessController.java:427)
> at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
> at
> java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1285)
> at java.lang.System.getProperty(System.java:628)
> at org.firebirdsql.logging.LoggerFactory.getLogger(LoggerFactory.java:36)
> at org.firebirdsql.logging.LoggerFactory.getLogger(LoggerFactory.java:72)
> at
> org.firebirdsql.pool.FBConnectionPoolDataSource.<clinit>(FBConnectionPoolDataSource.java:191)
> ... 36 more
>
> Its seems to be something to do with file permissions and logging...
> But I'm running Tomcat 5.5 as root (for now). Where does it try to
> create the log file?
>
> Any ideas?
> Ian Newby
>
> __.

[Non-text portions of this message have been removed]