At the moment it is just test code, hardcoded in the java code.

Note that I can connect to the database using isql, remoteley from
another machine using ibexpert. The versions of Tomcat are basically
the same, 5.5, one is 5.5.10 and the other 5.5.17 I think.

Why would the network connection fail? I am also connecting to a
remote SQL server database using the jTDS driver and that works OK.

I've tried connecting to a remote firebird database and that fails too.

Regards
Ian Newby

--- In Firebird-Java@yahoogroups.com, Rick Fincher <rnf@...> wrote:
>
> 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]
>