Subject unavailable database with type2 and java as a service
Author Carsten Schäfer
Hi,
my app is running as an application with type2-driver in local-mode (configuration as in my last messages).
(all is running, besides the exception at startup if fbclient.dll is not in system32-dir)
Now i wanted to run my aplication as a windows service (Java Service Launcher: http://www.roeschter.com/index.html).
I get the following exception for every datasource.getConnection():
org.firebirdsql.jdbc.FBSQLException: Resource Exception. unavailable database
Reason: unavailable database
at org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource.java:171)
at org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:403)
at org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:156)
at org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
at org.firebirdsql.pool.FBConnectionPoolDataSource.getFreeSize(FBConnectionPoolDataSource.java:314)
at org.firebirdsql.pool.FBWrappingDataSource.getConnectionCount(FBWrappingDataSource.java:353)
at com.TTC_Informatik.PAULA.server.App_Server.getConnection(App_Server.java:9370)
at com.TTC_Informatik.PAULA.server.App_Server.getReadConnection(App_Server.java:7540)
at com.TTC_Informatik.PAULA.server.App_Server.getAllDBObjekte(App_Server.java:2616)
at com.TTC_Informatik.PAULA.server.App_Server$7.construct(App_Server.java:7813)
at com.TTC_Informatik.PAULA.Tools.SwingWorker$2.run(SwingWorker.java:109)
at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: unavailable database
at org.firebirdsql.ngds.GDS_Impl.native_isc_attach_database(Native Method)
at org.firebirdsql.ngds.GDS_Impl.isc_attach_database(GDS_Impl.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.gds.GDSSynchronizationPolicy$AbstractSynchronizationPolicy.invoke(GDSSynchronizationPolicy.java:100)
at $Proxy0.isc_attach_database(Unknown Source)
at org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:540)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:88)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:366)
at org.firebirdsql.pool.FBConnectionPoolDataSource.allocateConnection(FBConnectionPoolDataSource.java:146)
at org.firebirdsql.pool.PooledConnectionQueue.addConnection(PooledConnectionQueue.java:403)
at org.firebirdsql.pool.PooledConnectionQueue.start(PooledConnectionQueue.java:156)
at org.firebirdsql.pool.AbstractConnectionPool.getQueue(AbstractConnectionPool.java:182)
at org.firebirdsql.pool.FBConnectionPoolDataSource.getFreeSize(FBConnectionPoolDataSource.java:314)
at org.firebirdsql.pool.FBWrappingDataSource.getConnectionCount(FBWrappingDataSource.java:353)
at com.TTC_Informatik.PAULA.server.App_Server.getConnection(App_Server.java:9370)

I need to configure the service to allow interaction with the desktop, but so i cannot start the service with a different user account.
Is this a bug in type2 ?

mfg
Carsten

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