Subject | Re: [Firebird-Java] Re: unavailable database with type2 and java as a service |
---|---|
Author | Carsten Schäfer |
Post date | 2004-05-11T06:28:42Z |
Roman Rokytskyy wrote:
With more testing i come to the conclusion that
datasource.setMinConnections(5) creates the error.
But if i don't specify minConnections with value >0 i do not get any single
connection.
Only this error:
java.sql.SQLException: Could not obtain connection during blocking timeout
(10000 ms)
at
org.firebirdsql.pool.PooledConnectionQueue.take(PooledConnectionQueue.java:2
96)
at
org.firebirdsql.pool.AbstractConnectionPool.getPooledConnection(AbstractConn
ectionPool.java:208)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnec
tionPoolDataSource.java:218)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnec
tionPoolDataSource.java:237)
at
org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource
.java:127)
at
com.TTC_Informatik.PAULA.server.App_Server.getConnection(App_Server.java:939
6)
Carsten
> Hi,I've tested it on 3 machines, all with the same error.
>
>
> Strange. I cannot reproduce this. I have tried DataSourceExample
> example:
>
> org.firebirdsql.pool.FBWrappingDataSource dataSource =
> new org.firebirdsql.pool.FBWrappingDataSource();
>
> dataSource.setDatabase ("e:/database/employee.gdb");
> dataSource.setType("LOCAL");
> dataSource.setDescription ("An example database of employees");
> dataSource.setSqlRole("USER");
> dataSource.setEncoding("NONE");
> dataSource.setLoginTimeout (10);
>
> java.sql.Connection c =
> dataSource.getConnection ("sysdba", "masterkey");
> c.close();
>
> It works on my XP Professional when I place database on my memory
> stick as well as on the mapped network drive (I use coLinux-enabled
> Debian sarge with Samba, for the clean experiment I have stopped
> Firebird server on that Linux node).
>
> Can somebody else confirm this issue?
>
With more testing i come to the conclusion that
datasource.setMinConnections(5) creates the error.
But if i don't specify minConnections with value >0 i do not get any single
connection.
Only this error:
java.sql.SQLException: Could not obtain connection during blocking timeout
(10000 ms)
at
org.firebirdsql.pool.PooledConnectionQueue.take(PooledConnectionQueue.java:2
96)
at
org.firebirdsql.pool.AbstractConnectionPool.getPooledConnection(AbstractConn
ectionPool.java:208)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnec
tionPoolDataSource.java:218)
at
org.firebirdsql.pool.FBConnectionPoolDataSource.getPooledConnection(FBConnec
tionPoolDataSource.java:237)
at
org.firebirdsql.pool.FBWrappingDataSource.getConnection(FBWrappingDataSource
.java:127)
at
com.TTC_Informatik.PAULA.server.App_Server.getConnection(App_Server.java:939
6)
Carsten