Subject firebird datasource & Sun Java application server 8 PE
Author jan_hradek
Hello there,

several days I spend with trying to create the connection to
Firebird 1.0.0.338 from Sun Java System Application server. When I
try to get the connection from data source, I receive this error
message:

Connection could not be allocated because: Resource Exception.
unrecognized database parameter block Reason: unrecognized database
parameter block

when I remove the conf. parameter MinSize or set it to 0. I obtain
this error message:

Target exception message: Connection could not be allocated because:
Could not obtain connection during blocking timeout (5000 ms)

is there any way to find the reason of the timeout above ?

there is my configuration of datasource below:

<jdbc-connection-pool connection-validation-method="auto-commit"
datasource-classname="org.firebirdsql.pool.FBWrappingDataSource"
fail-all-connections="false" idle-timeout-in-seconds="300" is-
connection-validation-required="false" is-isolation-level-
guaranteed="false" max-pool-size="32" max-wait-time-in-
millis="60000" name="fbPool" pool-resize-quantity="2" res-
type="javax.sql.DataSource" steady-pool-size="1">
<property name="CharSet" value="Cp1250"/>
<property name="Type" value="PURE_JAVA"/>
<property name="BlobBufferSize" value="16384"/>
<property name="SocketBufferSize" value="16000"/>
<property name="UserName" value="SYSDBA"/>
<property name="MaxSize" value="10"/>
<property name="LoginTimeout" value="5000"/>
<property name="Database"
value="localhost/3050:c:/data/ejb_experiment.gdb"/>
<property name="Password" value="masterkey"/>
<property name="Pooling" value="true"/>
<property name="BlockingTimeout" value="5000"/>
<property name="IdleTimeoutMinutes" value="35"/>
<property name="IdleTimeout" value="2147483"/>
<property name="TpbMapping" value="1"/>
<property name="PingInterval" value="5000"/>
<property name="SqlRole" value="USER"/>
<property name="MinSize" value="1"/>


Many thanks, Jan