Hi Ian,

It looks like you are opening your own DataSource from inside your app
rather than using one from Tomcat.

Did you change versions of Tomcat in the migration from Windows to Linux?

Tomcat 5.5.x uses different procedures from earlier versions of Tomcat
to create DataSources. It is preferable to use the Tomcat Admin tool to
create the DataSources and then set up a context to use them in your app.

Did you modify /CATALINA_HOME/conf/server.xml to put your context info
in? If so, that is not recommended for Tomcat 5.5.x.

Tomcat 5.5.x puts a context file in
/CATALINA_HOME/conf/Catalina/localhost with the name of your app, like:
myApp.xml. This file is auto-generated by Tomcat from the file named
context.xml in /CATALINA_HOME/webapps/yourApp/META-INF.

You create that file with your app's context info rather than hard
coding it in server.xml.

Rick


Ian A. Newby wrote:

> Thanks Alexey,
>
> I've turned off the security manager, and now get past that error.
> However, I'm now getting a new error:
>
> org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to
> complete network request to host "127
> .0.0.1".
> Reason: Unable to complete network request to host "127.0.0.1".
> at
> org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource
> .java:305)
> at
> org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:427)
> at
> org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:157)
> at
> org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
> at
> org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnectionPoolDataSourc
> e.java:371)
> at
> org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource.java:203)
> at
> uk.co.tpmi.engine.listeners.BootstrapListener.createDatasource(BootstrapListener.java:43)
>
> I can connect to this database using isql with a connection string of
> localhost:/mydatabase.fdb but not via Java.
>
> Any ideas, I've tried localhost, 127.0.0.1 and 10.0.0.200?
>
> Regards
> Ian
>
> --- In Firebird-Java@yahoogroups.com
> <mailto:Firebird-Java%40yahoogroups.com>, Alexey Panchenko <alex+news@...>
> wrote:
> >
> > Ian A. Newby wrote:
> >
> > > Caused by: java.security.AccessControlException: access denied
> > > (java.util.PropertyPermission FBLog4j read)
> >
> > [...]
> >
> > > org.firebirdsql.logging.LoggerFactory.getLogger(LoggerFactory.java:36)
> >
> > = 1st part of the issue =
> >
> > You are running tomcat with the security manager. It is the java
> > permissions, not the unix permissions.
> >
> > http://tomcat.apache.org/tomcat-5.5-doc/security-manager-howto.html
> <http://tomcat.apache.org/tomcat-5.5-doc/security-manager-howto.html>
> >
> > You can either run tomcat without the security manager, or adjust the
> > permissions.
> >
> > For tomcat they are usually configured in the
> > tomcat/conf/catalina.policy, in some linux distributions this file
> > could be generated from some others, please look how it works in your
> > case.
> >
> > Your should add the following line
> >
> > permission java.util.PropertyPermission "FBLog4j", "read";
> >
> > Also you application may require some other permissions - access to
> > other system properties, files & folders, sockets, etc.
> >
> > = 2nd part of the issue =
> >
> > Firebird client should ignore SecurityException when reading this
> > property.
> >
> > Index: LoggerFactory.java
> > ===================================================================
> > RCS file:
> /cvsroot/firebird/client-java/src/main/org/firebirdsql/logging/LoggerFactory.java,v
> > retrieving revision 1.5
> > diff -u -r1.5 LoggerFactory.java
> > --- LoggerFactory.java 15 Apr 2005 23:08:18 -0000 1.5
> > +++ LoggerFactory.java 10 Jan 2007 03:59:40 -0000
> > @@ -33,7 +33,13 @@
> >
> > public static Logger getLogger(String name,boolean def) {
> > if (!checked){
> > - String sLog4j = System.getProperty("FBLog4j");
> > + String sLog4j;
> > + try {
> > + sLog4j = System.getProperty("FBLog4j");
> > + }
> > + catch (SecurityException e) {
> > + sLog4j = null;
> > + }
> > if (!def){
> > if (sLog4j != null && sLog4j.equals("true"))
> > log4j = true;
> >
> >
> > --
> > Best regards,
> > Alexey mailto:alex+news@...
> >
>
> _

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